Understanding Discount Calculation
One of the most powerful features of Advanced Price Management is the ability to configure and apply multi-level discount structures. This allows for highly granular and strategic pricing logic, tailored to complex business scenarios.
Each Sales Line on a sales document can include multiple discount levels. These are stored and visualized in the Sales Line Detail table, which provides a full breakdown of how the final price is calculated.
Sales Line
The Line Discount % on the sales line is the consolidated result of all discount lines.
Sales Line Details
The Sales Line Detail always begins with a single Price line, followed by one or more Discount lines, depending on the pricing structure.
At the bottom of the Sales Line Details you’ll find an overview (totalization) of the line details.
Price Line
On this line the Base Value is the sales price retrieved with the Price Calculation Method.
Net Value is equal to the Base Value unless a manual price is applied. In that case, the Net Value reflects the manually entered price(see manual price).
Discount Lines
Discount line can behave differently depending on the Discount Calculation Mode.
Base Value
When a Discount line is with Discount Calculation Mode = Base Value, this means that the discount is calculated using the Base Value of the referenced line.
In this example, there’s two scenario’s.
- QTY-DISC (in green): This line is with Calculation Apply Code empty. This means that the reference is the Price Line.
- WAREHOUSE (in red): This line is with Calculation Apply Code = SCS. Since Calculation Apply Code is specified, the reference is the Base Value of the indicated discount line.
Net Value
When a Discount line is with Discount Calculation Mode = Net Value, this means the discount is calculated using the Net Value of the referenced line.
- SCS (in red): This line is with Calculation Apply Code = ASSORTMENT, meaning the reference will be the ASSORTMENT line and uses this line Net Value as its own Base Value.
Cumulated Net Value
When a Discount line is with Discount Calculation Mode = Cumulated Net Value, this means the discount is calculated using the Cumulated Net Value of the referenced line.
In the example.
- SCS (in red): This line is with Calculation Apply Code = ASSORTMENT meaning the reference will be the ASSORTMENT line and uses this line Cumulated Net Value as its own Base Value.