Buying by the case, selling by the each
Units of measure — counting stock in one unit while buying and selling in others, with supplier prices per case and pack prices of their own.
Watch it done: Buy by the case, sell by the each
Most distributors buy in one unit and sell in another: a case of 24 from the supplier, singles or a box of 6 to the customer. BeanDish counts stock in one unit and converts everything else to it, so a case received and a single sold land in the same stock figure.
The units
Units live under Tables – Utilities › Units of measure. For a weight or volume unit, Decimal places says how many decimals it shows.
On an item's Specs tab, the stocking unit is what stock is counted in. It locks once the item has stock or documents, because changing it would change what every past quantity means.
Packs and their prices
On the item's Pricing tab, click Add unit, choose the unit and type how many stocking units are in one. Leave the price blank to sell it at that many times the single price, or give it its own price and its own barcode.
Choose the Buy unit (what purchase orders, bills and requisitions open in) and the Sell unit, then click Save changes.
What each supplier charges
On the item's Purchases tab, the pencil on a supplier's row takes their own item number, description, purchase unit and price. The supplier's own Items tab lists the same rows from the other side.
Buying and receiving
A purchase order line opens in the supplier's unit at their price; change the unit and the price converts. The order and its PDF show both your item number and the supplier's.
Receive in the unit the supplier ships. Stock goes up in stocking units, and the order counts what has been received and what is outstanding the same way.
Create the bill from the delivery, correct the price to the supplier's invoice and post it. The supplier's row takes the new price for your next order.
Selling
On a sales order, each line picks its own unit. A unit without its own price is the single price times its size, and every line shows what it comes to in stocking units.
See every step
The video above shows an item bought by the case and sold by the each in under three minutes. The tutorial below goes slower, setting the item up first. The same tutorial is in BeanDish under Learn › Tutorials.
Buy by the case, sell by the each, step by step
An item bought in cases and sold one at a time: its units, a box with its own price and barcode, the supplier’s item number and price per case, then bought, received, billed at the supplier’s new price, and sold by the each and by the box. (4:47)