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)