Selling the same product as single unit or as a full box keeping inventory QTY on Hands accurate
==CONTEXT==
Quickbooks Desktop Pro + Advanced Inventory
We use the tool called “Sales Receipt” in Quickbooks Desktop Pro to sell items to customers that shows up at our retail stores.
When we order from our distributors, we buy in bulk… the items we sell as single items most likely came from a box of 10.
Right now, when we receive merchandise using the QB tool “Purchase Orders”, the inventory parts created are single items so the box of 10 is turned into 10 units to be sold.
There are moments where we would sell a full box, in this case, we’d make a Sales Receipt of 10 items and adjust the price if required. (most likely)
The industry we work in has tons of laws and regulations in regards to giving rebates, bundling, liquidation, minimum total amount of a pre-tax sale… so we have to be vigilant on how we operate and volume discount could lead to being fined or even put out of business if we get audited.
==WHAT WE ARE LOOKING FOR==
Basically I’d be interested in QB feature would allow us to sell Product A sometime as 1 unit or the full box if needed.
Preferably I’d rather have 2 SKUs:
Product A (1 unit) - 19.99
Product A (full box - 10 units) - 179.99 (something like 10% off)
Issue with 2 SKUs is if I sell “Product A (full box) - 179.99” and quantities are turned into units out of a box like suggested above, I end up with a SKU with negative stock and have to transfer stock periodically to keep stock level healthy… this leads to potential discrepancies in our fast pace inventory turn around.
== EXEMPLE ==
Best exemple is Cartons of Cigarettes, they are packaged as 8 packs of cigarettes, sometime you sell them by the carton but most of the time, you sell individual packs. Whatever the accounting system or POS system you use, there must be a way to properly track the stock. They don't expect the convenient store clerk to adjust inventory of both SKUs every time they open a carton.
Any recommendations on how to proceed?
==OPTIMAL RESULT==
The best end result for us would be to see a line on the invoice with:
- Product A (full box) - 179.99
as it’s being prepackaged by the manufacturer and we did not bundled it ourselves giving out volume pricing in the transaction… all of this keeping the inventory levels accurate.
==POSSIBLE SOLUTIONS==
- Any add-ons to QB you would recommend to do this?
- Inventory assembly/Bundle part number that would be a different SKU that would deduce units from the single SKU once a box is sold
- Using the QB Communication tool and build a routine that would actually create a inventory adjustment periodically every days we’d sell any Product X (full box)