Using Price Management

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,
    • 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

Setup Price List and 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.

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.

Web Page Price Mngmt Pricing table Key Snapshot
Web Page Price Mngmt Pricing table coulum snapshot

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.

This example uses the Pricing Table tab.

Column Setting
Item
Item Category
Item Class
Customer
Customer Class VIP
Base Cost
Base Price
Actual Price / Discount 15%
Price Formula

In this article

Was this helpful?