Price Type Application Sequence

Attribute Name: priceTypeApplicationSequence
Data Type: Integer
Max Length: 3
Repeatable: Yes
Code List: No
AVP: No
TPD: No
Applies to: All Levels
Last Modified: 05/02/2024
Description:

Order in which the value associated with a Price Type is applied when calculating the net invoice price. 

- The application sequence is always 1 for the parent price (generally the List Price)

- The application sequence is 2, if the calculation is based on the relevant price in Price Type Application Sequence 1.

-The application sequence can be 3 or more, if the calculation is based on the prior subtotal (cascade)

Example:

Example 1:

List Price                                                Application Sequence = 1

Warehouse Allowance (5%)                   Application Sequence = 2

Trade Allowance (6%)                            Application Sequence = 2

List Price $100

Warehouse Discount 5%

Trade Discount 6% 

 

Example 2:

List Price                                                Application Sequence = 1

Warehouse Allowance (5%)                   Application Sequence = 2

Trade Allowance (6%)                            Application Sequence = 3

List Price $100

Warehouse Discount 5%

Trade Discount 6% 

Useful Tips:
  • Zero is not a valid value for this field

  • Negative values are not allowed in this field.

  • If Price Type is ALLOWANCE or CHARGE, this value must be greater than 1.  

  • If your pricing model does not include allowances or charges, only the application sequence 1 is required.

  • If your pricing model includes allowances and/or charges, but does not apply cascading pricing, use application sequence 2 for all allowances/charges

Metcash / Metcash ALM

  • If there are multiple allowances for a price, cascading application sequence must be used as detailed in example 2 shown above.