Price list hierarchy

Edit online

In a price list hierarchy, prices are searched for in reverse hierarchical order.

The following figure shows a price list hierarchy.

Price list hierarchy graphic"

In the price list hierarchy shown above, prices are searched for in reverse hierarchical order, at the lowest level of the region first, then up the hierarchy. For example, if Sterling Order Management System Software is searching for a price list for Item 3 and the organization on the order is 235, it looks first at 235. If the price is not found, the search for Item 3 goes up to the California region, then the West Coast region, and then finally to the Enterprise level, which does have a price of $100. If a defines its own price lists for certain items, such as when 235 defines Item 2’s price at $65.00, the search does not go up the hierarchy if it is found at the level.

If the following two price lists were added to the lists above, Item 3 could have an even lower price for Gold Customers ($80.) or for Employees ($65.).
  • Gold Customers – Price List 5
    • Assignments:
      • : All
      • Customer: Gold Customers
        • Item 3 - $80.
        • Item 5 - $90.
  • Employees – Price List 6
    • Assignments:
      • : All
      • Customer: Employees
        • Item 3 - $65.
        • Item 5 - $85.

This search behavior is governed by the way you configure precedence. In the previous price list example, if the customer happened to be a Gold Customer and also an Employee, Sterling Order Management System Software would pick the lowest price of the two, provided that precedence was defined as the third option, "Consider both and choose the lowest priced price list."