# 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 | |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://helpwith.salesorder.com/products-services/advanced-price-lists.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.