We are having a couple of customers selling liquor tots & Full bottles in their businesses.
As customer explained it - he has a "Liquor Restaurant"
They offer the customer the ability to buy full bottles or Tots.
We suggested they start with the Liquor Store Database as most of the products are preloaded.
That takes care of the shrinks - bottles & cases (1 x 12)
Now, what to do with the tots?
Quite simple actually....
Create a 2nd item for eg. Bells (Tots)
You can even have a shrink for singles & doubles : (1 x 2)
Now take it one step further & create a Bill of Material (BOM) from the tot to the bottle item :
Bells (tots)
Item : Bells 750ml : Quantity : 0.03333 (Calculated by 1 bottle divided by 30 tots)
So, when you sell a tot, it will automatically deduct 1 tot from Bells & show your bells stock as 15.667 (15 full bottles & .9667 of a bottle)