Price Based on Partial Case Qty

Situation:  An item is sold by two different units (i.e. Each and Case).  If a customer buys by the Each, there is a ‘mark-up’ price because the case was broken.  If the customer buys by the Case, there is a different price.  As an example, assume that there are 15 Eaches in a Case.  The Case price is $300.00, where as buying by the Each will cost the customer $30.00 Each.

First, the Item Master (found in 5-17) needs to be set up correctly, below is an example of an item with the important fields:

 01. Item #                   741-15

 02. Description            DRIVER AMP

 04. Sell by                  Each      

 05. Stock by               Case

 06. Master units           15

 07. Avg. cost               100.00

 08. Last cost               100.00

 11. Price 1                  450.00    

 30. Quan table             JJJJJJJJJ

(Note: the $30.00 each price comes from dividing the Master Unit of 15 into Price 1 of $450.00)

Next a Quantity Discount Table (found in 5/22) needs to be set up correctly, below is an example of a table with the important fields:

 01. Table name            MJ  (A table name beginning with an M means ‘stock by’, beginning with a Q is for ‘sell by’)              

 02. Table descr           STOCK SELL                

 03. Break on D/Q       Q                       

 04. Amount type          $ (% L $) *                 

 05. Fixed / Cume:        F                                                                   

 06. Quantity    :            1                         

 07. Price  :                   300.00 

In Order Processing when the item is entered it will be shown in the Stock by unit, with pricing of $300.00 for each Case bought.  By pressing the TAB key, the system will change to the Sell by unit of Each.  For everyEach bought, the price will be $30.00.

* If multiple items, each having a different price, fall into the same scenario, you may decide to use a Price Level or Percentage versus an actual dollar amount.  For example, on the Item Master if a Price Level is empty and the case amount for that item is placed on it, then the Quantity Discount Table can have field #04 set to L (for Level) and field #07 will indicate which Price Level would have the $300.00 on it. (Note:  if there are further quantity breaks, i.e. buy 10 and the price becomes $260.00 per case, then additional price levels would be needed to record those breaks)