Modules»Inventory Control»Price Based on Quantity Discou…
  • RSS Feed

Last modified on 2/7/2017 1:38 PM by User.

Price Based on Quantity Discount Tables

The following is an explanation on how the Discount Quantity Table works - with breaks at Quantity Sold. The tables are setup in the Inventory Module in Discount Table Master (Task 22). The table "codes" are placed in the Item Master (Task 17) on field #30 - Quan Table.

 NOTE:  other dimensional types can be used with these instructions, such as R for Repro-No Quantity, N for Non-dimensional, D for Sets/Originals/Width/Heights, etc.….the example given is for O (originals x copies) and C (copies)


In Order Processing, the system looks at how an item is being sold - whether by Selling Unit or Stocking Unit. If an item is sold by Selling Unit, the system looks for a Discount Quantity Table that starts with a "Q". If an item can be sold by Stocking Units, the system looks for a table that starts with an "M".


1… 2… 3… 4… 5… 6… 7… 8… 9 < the nine pricing levels a customer gets (field 13 on customer record)

A…D…E……………B…J……...Q < nine fields in Quan Table (field 30) on the item record

QA..QD..QE……………..QB..QJ….…QQ < Quantity Table names - Task 22 in Inventory module


The Q or M is known by the system, based on whether its selling units or stocking units being sold. Therefore, only the second letter of the Quantity Table name is entered - see middle line of the example above.

Using the example above:

If a customer has a Price Level 1 for an item, the system will look to table QA or MA for quantity breaks.

If a customer has a Price Level 6 for an item, the system will look to table QB or MB for quantity breaks.

If a customer has a Price Level of 4, 5 or 8 then there is no special pricing for buying in larger quantities.

If a customer gets the same quantity breaks for all price level, enter the same table (ex: EEE) in all 9 spaces. 



When selling Copies and Originals and using Quantity Discounts, the key is having the "Dimensional?" field (field #26) on the item set correctly. The two options are C or O.

If you are pricing on copies only use a C in the "dimensional" field. I.e. 20 copies of 6 originals will pick up the price break at 20 copies.

If you are pricing on total of copies and originals use an O in the "dimensional" field. I.e. 20 copies of 6 originals will pick up the price break at 120.


 Below is a chart, assuming a "C" - looking at copies for a price break - was placed in the "dimensional" field on the item.


Price per Copy













A customer bought 20 copies of one original, the price would be $2.00

  • (1 original x 20 copies) X ($.10) = $2.00 [$.10 comes from price break of 20 copies.]

A Customer bought 30 copies of 6 different originals, the price would be $18.00.

  • (6 originals x 30 copies each) X ($.10) = $18.00 [$.10 comes from price break of 20 copies]

A customer bought 150 copies of 1 original, the price would be $9.00

  • (1 original x 150 copies) X ($.06) = $9.00 [$.06 comes from price break of 100 copies]



Before a customer can get a price break based on the quantity purchased, all areas of the system must be setup properly.

First (Discount Table):

The Discount Table Master (Task 22 in the Inventory module) must be setup before it can placed on an item. Remember the rules: if an item is being sold by Selling Units, use a Q in the Table name. If an item is being sold by Stocking Units, use an M in the Table name. Also, Break on = Q (for Qty) and Amount type = $.  The second character is alphanumeric, capital letters A - Z, lower case letters a - z and numbers 0 - 9 can be used -- giving a total of 62 Discount Quantity tables that can be set up and used.  Note: if a quantity discount table is needed for a specific customer, set up the table in the Customer Contract Item File (task 21 in Order Processing module)

Second (the Item):

  • has 9 price levels (fields 11 -19) that a customer can get. If the item is always sold by quantity and price breaks are given on additional quantities, then only the first price level needs to be filled in because the system will look to the Discount Table for the actual price that will be charged per copy/original.
  • field 26 (Dimensional?) determines how the item will be looked at by the system
  • field 30 (Quan table) determines which Discount Table the system looks at for the price breaks. If customers will be using the same Quantity Table for all price levels, fill in the same table letter in all 9 spaces (which is the ‘norm’).

Third (the Customer):

The customer record needs to reflect which price level the system will look at for pricing - field 13 (price type). If the customer receives pricing based on Price Level 1, then fill in all nine spaces with a 1 (using the same Price Level in all spaces is the ‘norm’).

See the document Price Levels for an explanation on how the Price Levels work with the Product Codes.

NOTE:  if pricing for a combination of copies and originals is used (example: using a table for pricing-  look down the left side for # of originals, and look across the top of the table for # of copies - where the row and column intercept is what the price charged will be) then look at the document titled:  Price Based on a Matrix Table - Originals x Copies x Price