Reference Price Calculation

Calculation detail

Reference Price is an informative Pricing information calculated based on the List Price and the Product Group Dicount Value using the following formula :

CODE

Reference Price = List Price *(1-Prodduct Group Discount)

To get the Product Group Discount the system will calculate the Product Group Associated to the Finished Good Product and query the Product Group Lookup table to define the Start Target and Floor Discount. This is exactly the same algorithm that is used to define these values for the product Group list.

The Product Group value for the Finished Good is calculated using the Level 3 value field from the product. with the action of replacing the prefix of values.

CODE

Replace "ATR_GROUP_ID_3_" by "PG_"

This is important in order to reuse the lookups already in place.

Data Flow

The Diagram below show how the data flow and fields interact in the system.

list price source should be defined