Modules»Order Processing»Partial Case Pricing
  • RSS Feed

Last modified on 10/7/2015 10:39 AM by User.

Tags:

Partial Case Pricing

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 selling 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 every Each 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)