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: 27/11/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%

Invoice Price = $89

$100 x 5% = $5 [$100 - $5 = $95]

$100 x 6% = $6

$100 - $5 - $6 = $89

 

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%

Invoice Price = $89.30

$100 x 5% = $5 [$100 - $5 = $95]

$95 x 6% = $5.7

$95 - $5.7 = $89.30

 

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.