Using Advanced Price Lists

29 0 0 21/12/2020

You can use price lists, to preset how the unit price/cost will be transformed, when the corresponding item is put on the Document.

The Document inherits the Price Lists from the Trading Partner Master.

The transformation of the unit price/cost is defined by rules and conditions set by the user.

Price List considerations

There are multiple considerations when you specify a Price List:

Where will it be applied? On Sales or Purchasing Documents, or both?
How will it be presented on Documents?
- The normal unit price is displayed as a reduced figure, OR
- The discount value i.e. -10% is displayed in a column on the same row as the discounted Item.
What parameters(s) trigger its application? Specific Item:
1. - Specific Item Category,
  - Specific Item Class,
  - Specific Customer or Supplier,
  - Specific Customer or Supplier Class,
  - Quantity of Items quoted or Ordered.
What calculation is applied? For example,10% off all Items for this Customer, 30% off if the quantity of this Item exceeds 1000.
In which Currency the Prices are defined?

Advanced Price Lists

Advanced Price Lists enable you to specify:

Price Lists for trading partners i.e. Customers, Suppliers or both.
Price Lists for any given Currency.
Global price discounts i.e. 10% of every Item.
Global and Item specific quantity discounts.
Global total order value discounts.
Pricing formulas based upon Item, Classification, Customer, etc.

You can apply a Price List to a Supplier’s Price List. You’d probably use this to manipulate supplier catalog prices.

NOTE Advanced Price Lists supersedes Price Levels, Price Lists and Price Break Plugin. This legacy functionality will remain in the system until its users have transitioned to Advanced Price Lists.

Advanced Price List settings

To access this setting, go to:

PRODUCTS/SERVICES > Advanced Price Lists > Select an Advanced Price List > View Advanced Price List

The Advanced Price List settings are available under :

Advanced Price List Details tab and
Pricing Table tab.

Advanced Price List Details tab

Field	Purpose
Name	A short name, to identify the Price List on; Customer and Supplier masters, and transaction Documents.
Currency	The Currency of values/amounts used in the Pricing Table.
Use as default for Customers	When checked, it presets this Price List on all new Customers.
Apply to	It can be applied to Customer, Supplier or both.
Customer Discount Method	Controls how the result of this price list is displayed in the Line Item table. Discount = show discount in the discount column on the Line Item table. Unit Price = the value in the Unit price column shows the net result.
Exclude Items not in Pricing Table	When unchecked, apply this rule to all Items. When checked, apply this rule to only the Items selected in the Pricing Table.
General Price Discount	A simple discount i.e. 10.5%. A matching rule in the Pricing table will take precedence over the Discount stated here.
Price Formula on Item	A formula to express how the pricing is calculated and applied.

Pricing Table tab

Column	Purpose
Item	Select an Item to which the rule you set in this row will apply.
Item Category	Select an Item Category to which the rule you set in this row will apply.
Item Class	Select an Item Class to which the rule you set in this row will apply.
Customer	Select a Customer to which the rule you set in this row will apply.
Customer Class	Select a Customer Class to which the rule you set in this row will apply.
Base Cost	Set the Base cost for the Item selected in this row.
Base Price	Set the Base price for the Item selected in this row.
Actual Price / Discount	A number to represent a Price i.e. 1.65 or a percentage to represent a discount.
Price Formula	See Pricing Formulas below.

The Pricing table is intelligent. Based upon which combination of columns within which you select a value, other columns will be enabled/disabled to ensure the pricing rule is practical.

For example: If Item is selected, then Item Category, Item Class are not editable and the remaining are editable.

Pricing Formula syntax

Formulas are always in square brackets. The formulas have a specific format to express:

Prices based upon cost i.e. [C+10%], cost plus ten percent.
Prices based upon quantity price breaks i.e. [10-20:5%], buy ten or any number up to and including 20 then discount by 5%.

A series of price breaks would be annotated as follows:

[10-20:5%] [21-30:10%] [31-:15%]

You can specify a discount on a single case i.e. [31-:15%] represents a 15% discount on a quantity greater than 31.

A price can be specified in three ways:

Absolute i.e. 34.03.
Percentage i.e. 20% of the base price.
Calculated from cost i.e. C+20% (cost plus 20%).

Base Price List(s)

To access this setting, go to:

PRODUCTS/SERVICES > Advanced Price Lists > Show Base Price Lists

Examples

1. 10% Discount off all Items on Sales Documents.

This example uses settings on the Advanced Price List Details tab.

Field	Value
Name	-10%
Description	10% of all Items (Sales).
Currency	Base or any currency. The Price rules in this new Advanced Price List use this in their calculation.
Use as default for Customers	When checked presets this Price List on all new Customers.
Apply to	Customer
Customer Discount Method	Controls how the result of this price list is displayed in the Line Item table. Discount = show discount in the discount column on the Line Item table. Unit Price = the value in the Unit price column shows the net result.
Exclude Items not in Pricing Table	When unchecked apply this rule to all Items. When checked, apply this rule to only the Items selected in the Pricing Table.
General Price Discount	10%

2. Discount Items in the Item category ‘Chandeliers’ by 10%.

This example uses the Pricing Table tab.

Column	Setting
Item
Item Category	Chandeliers
Item Class
Customer
Customer Class
Base Cost
Base Price
Actual Price / Discount	20%
Price Formula

3. Discount 15% for all VIP Customers.