Setting up inventory for buying in cases, selling in bottles/packs/cases etc Help please - Odoo 11 CE
I've seen this question - or similar - asked a few times but I'm struggling to get any of the suggestions to work.
I need to buy products in cases of 24 (or 6, 12 or 20 depending on the product - but let's stick to 24 here) and then sell them in 1's, 6's, 12's or 24's etc
I need these to be product variants so the shopper can choose on the product page. And all purchases need to deduct from the same stock-taking item.
As I say, I've tried a few methods but I can't seem to get any to work.
I have Units of Measure set up with a base unit of Bottle, a case of 6 (6 * bottle reference unit), case of 12 (12 * reference unit) and case of 24 (24 * reference unit).
When I think I'm getting it working, I hit on a problem where a change to one variant is affecting the others - in particular stockable vs consumable (I'm making the case of 24 stockable with a buy route, and the rest consumable with a manufacture/make to order route - then trying to set up BoMs), and also the units of measure setting (if I change a variant to 1 bottle, all the others are now 1 too)?
Presumably I am doing something totally incorrect and/or just don't understand it properly.
I'm also a bit unsure about setting up the BoMs. If I want the Purchase Unit to be a case of 24, but I want to keep the stock at bottle level, is there a built-in way to say eg 498 bottles in stock (20.75 cases) or 498 bottles in stock (20 cases and 18 bottles) or is this something I'd have to create/amend a template for.
Or is it best to use the purchase cases as the stock-taking unit? But then how do I set up the UoM based on the case of 24?
The Wine By The Glass PDF that has been mentioned here a few times talks about having the 750ml bottle as the stock-taking unit, and the glasses a fraction, ie a 250ml glass is 0.33 of the 750ml unit. But if I were to use a case of 24 as the stock-taking unit, a bottle would be 0.041666 - would that work? Would it round up correctly? It seems a strange way to do it rather than use the bottle as the base unit and say 6*, 12*, 24* etc.
Sorry, hope that makes sense. I've spent the last two days trying various things and getting a bit frustrated and lost at something that seems like it should be quite straight-forward.
Any pointers/help very much appreciated.