Sage 100: How to set up or maintain pricing by customer or item, or determine the Item Pricing Hierarchy for Item Codes on Sales Orders or Invoices in Sage 100

Products

Sage 100

Description

How Sage 100 determines the Item Pricing Hierarchy (or priority) for item codes on Sales Orders or Invoices

Where to set up and maintain pricing by Sales Promotion, Customer Price Schedule (Customer Pricing), Item Pricing, Price Codes, or Standard Price

How to set up pricing for customers and items in Sage 100

Resolution

Each time an Item Code is entered on a Sales Order or Invoice, Sage 100 checks the customer, date, item, and quantity to determine which pricing method to use. This establishes the Unit Price that will display for the line item. However, the Unit Price can be manually overridden by the user. Customers using National Accounts should look at the Bill to account for pricing options setup

Note: For the Item Costing Hierarchy, see the Related Resources section.

The Item Pricing Hierarchy is as follows (from highest to lowest):

Sales Promotion – This price is used if a sales promotion is in effect covering the item and the current date and if the sales promotion price is lower.
- Notes:
  - Sales Promotions are set up and maintained in Inventory Management, Sales Promotion Maintenance
  - Use the Apply button to access an Apply Sales Promotion window where a particular promotion may be applied to a range of Item Code(s), Product Line(s), Price Code(s), and/or Primary Vendor Number(s).
Customer Price Schedule (Customer Pricing) – Also known as contract pricing, this is pricing specifically set for item and customer. Aside from possible promotion pricing, this pricing has the highest priority.
- Notes:
  - There are two ways to access (either achieves the same result, saves to the same records):
    - Customer Price Schedule is set up and maintained in Item Pricing Maintenance, which is accessed from Inventory Management, Item Maintenance, by clicking the More button (or drop-down chevron at the upper right corner), selecting the Pricing button, choosing the Pricing Option of “Customer Price Schedule”, and selecting a Customer.
    - Customer Pricing is set up and maintained in Customer Pricing Maintenance, which is accessed from Accounts Receivable, Customer Maintenance for a Customer, by clicking the More button (or drop-down chevron at the upper right corner), selecting the Items… button to open Customer Sales History, then clicking the Pricing… button to access Customer Pricing Maintenance.
  - Pricing Methods available include Cost Markup Amount, Cost Marking %, Price Discount Amount, Price Discount %, Price Override
  - Quantity Breaks can be set for price levels.
Item Pricing, alphanumeric Price Level – This is pricing set specifically for an item. This price is used if there is a match between the customer’s assigned price level and the item code’s Item Pricing.
- Notes:
  - Item Pricing is set up and maintained in Item Pricing Maintenance, which is accessed from Inventory Management, Item Maintenance, by clicking the More button (or drop-down chevron at the upper right corner), selecting the Pricing button, and choosing the Pricing Option of “Item Pricing”.
  - Price Level – Enter an alphanumeric character. While non-alphanumeric characters may work, it is not recommended to use them.
  - Pricing Methods available include Cost Markup Amount, Cost Marking %, Price Discount Amount, Price Discount %, Price Override
  - Quantity Breaks can be set for price levels.
  - Customers may be assigned Price Levels on the Additional tab of Accounts Receivable, Customer Maintenance
Item Pricing, Standard (blank) Price Level – This is pricing set specifically for an item. This price is used if the customer does not have a price level assigned, or if there is no match found between the customer’s price level and an existing alphanumeric price level for the item code’s Item Pricing.
- Notes:
  - Item Pricing is set up and maintained in Item Pricing Maintenance, which is accessed from Inventory Management, Item Maintenance, by clicking the More button (or drop-down chevron at the upper right corner), selecting the Pricing button, and choosing the Pricing Option of “Item Pricing”.
  - Price Level – A standard (blank) price level should always be created for a price code prior to creating any alphanumeric price levels. Place the cursor in the Price Level field, then press the Enter key to create a Standard (blank) price level.
  - Pricing Methods available include Cost Markup Amount, Cost Marking %, Price Discount Amount, Price Discount %, Price Override
  - Quantity Breaks can be set for price levels.
  - Customers may be assigned Price Levels on the Additional tab of Accounts Receivable, Customer Maintenance
Price Code, alphanumeric Price Level – This is pricing by price code, which may be assigned to one or more items, or as a default for new items in a product line. This price is used if there is a match between the customer’s assigned price level and the item’s assigned Price Code‘s price level
- Notes:
  - Price Codes are set up and maintained in Inventory Management, Price Code Maintenance, where the Price Level is an alphanumeric character entered by the user.
  - Price Level – Enter an alphanumeric character. While non-alphanumeric characters may work, it is not recommended to use them.
  - Quantity Breaks can be set for price levels.
  - Customers may be assigned Price Levels on the Additional tab of Accounts Receivable, Customer Maintenance
  - Product Lines may be assigned default Price Codes in Inventory Management, Product Line Maintenance. Newly-created item codes will take the default price code of the product line, although that can be changed.
  - Item Codes may be assigned Price Codes on the Additional tab of Inventory Management, Item Maintenance
Price Code, Standard (blank) Price Level – This is pricing by price code, which may be assigned to one or more items, or as a default for new items in a product line. This price is used if the customer does not have a price level assigned, or if there is no match found between the customer’s price level and an existing alphanumeric price level for the item’s assigned Price Code.
- Notes:
  - Price Codes are set up and maintained in Inventory Management, Price Code Maintenance. Where the Price Level is blank, that is the Standard price level.
  - Price Level – A standard (blank) price level should always be created for a price code prior to creating any alphanumeric price levels. Place the cursor in the Price Level field, then press the Enter key to create a Standard (blank) price level.
  - Quantity Breaks can be set for price levels.
  - Customers may be assigned Price Levels on the Additional tab of Accounts Receivable, Customer Maintenance
  - Product Lines may be assigned default Price Codes in Inventory Management, Product Line Maintenance. Newly-created item codes will take the default price code of the product line, although that can be changed.
  - Item Codes may be assigned Price Codes on the Additional tab of Inventory Management, Item Maintenance
Standard Price – This price is used if there is no other higher priority price setting
- Notes:
  - The Standard Price for an item Code is set on the Main tab of Inventory Management, Item Maintenance

Note: Pricing can also be affected by Discounts. For example, one-time discounts can be set at the line item level, such as in Sales Order Entry, Lines tab, or in S/O Invoice Entry, the Lines tab. One can selects an Item Code and enters a Discount. Or on the Totals tab, when one enters a Discount Percentage or Amount to be deducted from the Amount Subject to Discount.

Note: Another method of pricing calculation that works in conjunction is Pricing by Total Quantity. This setting allows the quantities of all lines, the quantities of all lines belonging to a single Product Line, or the total quantity of all lines belonging to a single Category… to be added together before looking at pricing that uses quantity breaks to determine unit price. For more information, see the Related Resources section on how to set up Item Pricing by Total Quantity.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.