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.
Grouped Line Discount
When an Advanced Price List includes a line with Line Type = Grouped Line Discount, the calculation process depends on the setup defined in Advance Price Management Setup:
Application Mode:
-
Manual – The discount is calculated only when the user triggers the action.
-
On Release – The discount is calculated automatically when the document is released.
Calculation Logic
The system checks if the threshold is met before applying the Grouped Line Discount.
- The order amount is calculated by summing all sales lines matching the rule scope, after applying any existing line-level discounts, but excluding any Grouped Line Discount.
- This ensures the discount applies only when the net value of the order (excluding itself) meets the defined criteria.
- If multiple Grouped Line Discount rules apply to the same sales line (e.g., one by Item Discount Group and another by specific Item No.), the system calculates all applicable discounts for the customer.
The applied discount can be reviewed in Line Details.
