Advanced Price Management Sales Line Details

Sales Line detail

In Advanced Price Management, each sales line can include multiple discount levels. These are stored in a dedicated table called Sales Line Detail, which provides full transparency into how the final price is calculated.

For each discount level that will be applied to the sales line, there’s a line in the Sales Line Detail table. The first line is always of line type Price.

Field Description
Price Header Code Code of the Advanced Price List used for the calculation.
Price Template Code Code of the originating Advanced Price Template.
Price Type Code Discount Type Code applied at this level.
Line Type Define the line type. Only one line of type Price is allowed and is always the first.
Discount Caculation Method Defines how the discount is calculated: can be Base Value, Net Value or Cumulated Net Value (see Understanding Discount Calculation)
Calculation apply code Identifies the reference Sales Line Detail used as the base for the discount. If empty, the first Price line is used.
Base Value The amount used as the basis for calculation. For Price lines, this is the item tariff. For Discount lines, this is the value used to compute the discount.
Application Value The discount percentage or fixed value retrieved from the Advanced Price List.
Result Value Specifies the discount calculation result in amount.
Net Value Specifies the calculated Net Value for the line. (Base Value-Result Value).
Cumulated Net Value Specifies the Cumulated Net Value for the Line. This is Base Value of the first line (Line of type Price) less the sum of the Result Value of all the Sales Line Details up to the current one.
Using the Personalize mode you can display additionnal fields such as Promotion Code, Priority (field used to sort and prioritize discount levels) and Print Level.

Unit of Measure Conversion in Price Calculation

When the Unit of Measure field on an Advanced Price List Line is left empty, the system assumes that the Base Unit of Measure of the item is used for pricing.

If the Sales Unit of Measure on the sales document differs from the Base Unit of Measure, the system automatically adjusts the price using the Quantity per Unit of Measure defined on the item card.

This way:

  • The price is calculated based on the Base Unit of Measure.
  • The system converts the price to the Sales Unit of Measure using the defined conversion ratio.
  • This ensures accurate pricing regardless of the unit used on the sales document.

The Sales Line Detail page displays both:

  • Price in Base Unit of Measure
  • Price in Sales Unit of Measure

This provides full transparency into how the final price was derived.

This feature is especially useful when items are sold in multiple units (e.g., pieces, boxes, kilograms) but priced consistently at the base level..

These fields are also available on Sales Lines:

Previous
Next