# Advanced Price Lists
Media [Advanced Price Lists](https://salesorder.wistia.com/medias/5r3b2odfi9)
### Advanced Price Lists - Need to know You can preset a price list on a customer master. Subsequent transactions inherit and apply pricing to line items. 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% off every Item * Global and Item specific quantity 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. {% hint style="warning" %} **Advanced Price Lists supersedes ‘Price Levels’, ‘Price Lists’ and the ‘Price Break’ Plugin.** This legacy functionality will remain in the system until its users have transitioned to Advanced Price Lists. {% endhint %} ### 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. **Which** parameters(s) trigger its application? * Specific Item * Specific Item Tag(s) * Specific Item Class * Specific Customer or Supplier * Specific Customer or Supplier Class * Qty 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. **What** Currency are the Prices? ### Advanced Price List settings Products/Services>Advanced Price Lists>+ #### Advanced Price List Details tab | Field | Purpose | | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Name | A short name, to identify the Price List on; Customer and Supplier masters, and transaction Documents. | | Description | A summary of the Price List, what is done, and where it is used. | | Currency | The Currency of values/amounts used in the Pricing Table. | | Use as default for Customers | When checked 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 Tag | Select one or more Item Tags 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 below, ‘Pricing Formulas’ | ### Pricing Table Automation 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.

Pricing Table Behavior

### Pricing Formula syntax Formulae are always in square brackets. The formulae 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%]1 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 20cat%) ### Base Price List(s) Advanced Price Lists>Action bar>Show Base Price Lists ### Examples #### 10% Discount off all Items on Sales Documents This example just 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 a 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% | | Price Formula on Item | n/a | #### Discount Items with the Item Tag ‘Chandeliers by ‘10% This example uses the Pricing table | Column | Setting | | --------------------- | ----------- | | Item | | | Item Tag | Chandeliers | | Item Class | | | Customer | | | Customer Class | | | Base Cost | | | Base Price | | | Actual Price/Discount | 10% | | Price Formula | | #### Discount 15% for all VIP Customers | Column | Setting | | --------------------- | ------- | | Item | | | Item Tag | | | Item Class | | | Customer | | | Customer Class | VIP | | Base Cost | | | Base Price | | | Actual Price/Discount | 15% | | Price Formula | |