Price and Value Books

If you require more complicated pricing functionality than that fulfilled by applying price bands in the Item Master, you can use the hierarchical structure provided by Price Books.

Price Books

Price Books are an advanced form of a Price List and contain pricing pages containing such complex pricing requirements as promotional and cumulative structures. These pricing pages can be grouped into hierarchies which can then be used by the Purchasing and Sales modules in Order Fulfilment.

This hierarchy enables you to hold prices for different date ranges which may be open-ended and may overlap. If they do overlap, the entry with the latest start date takes precedence.

You can establish a list of prices for combinations of any groups of items or customers. Each Price Book contains up to five selection categories or subcategories, as follows:

  • Account analysis dimensions.
  • Address analysis dimensions.
  • Item analysis dimensions.
  • Transaction analysis dimensions.
  • Customer account code.
  • Customer invoice address.
  • Customer delivery address.
  • Item code.
  • Location code.
  • Transaction type.

A range of prices is available for each Price Book. The value of an order is used to determine which entry in the range to use. Each Price Book range specifies either a set price value, a variance relative to one of the Item Record Base Selling Prices, or any other calculation value. The variance must be a percentage, a rate or an amount.

You can also specify alternative pricing. This means that the Price Book value is used if one is found, otherwise an alternative item base price is used instead.

Value Books

Value Books are similar to Price Books but handle quantities instead of monetary values. Value Books do not include promotional options and cannot be grouped into hierarchies.