How to set up Sage 100 Item Pricing by Total Quantity

Note: When Enable Based On is set to None, then Pricing by Total Quantity is not enabled. Instead, standard Sage 100 pricing will determine the unit price in Sales Order Entry and Invoice Data Entry for each line entered independent of any other line(s). For more information, see the article on the Item Pricing Hierarchy in the Related Resources section.

However, when Enable Based On is enabled (by selecting one of the options other than None), then Pricing by Total Quantity 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.

1. Open Sales Order, Setup menu, Sales Order Options
2. Access the Line Entry tab
3. In the Item Pricing by Total Quantity section, set Enable Based On to one of the following options:
   • None
   • All Lines
   • Item Category  – This is the Category 1 Description (as set up in Inventory Management, Setup menu, Inventory Options, Additional tab)
   • Item Category  – This is the Category 2 Description
   • Item Category  – This is the Category 3 Description
   • Item Category  – This is the Category 4 Description
   • Product Line
4. When a Sales Order or S/O Invoice is entered, Sage 100 will add together the quantities of all lines with the same attribute (i.e. Item Category or Product Line). This total quantity will then be used for the price lookup for each line item, as if that were the actual quantity for that line.
5. Each line will be priced separately (from all other lines) using this total quantity using the How to Set Up Sage 100 Customer and Item Pricing. (For more information, see the Related Resources section.)