I buy and sell water. I always buy master cases (96 bottles). I want to manage my inventory in bottles. I sell bottles, cases (12 bottles), or master cases (96 bottles) in my store. I can break cases and master cases. How can I configure Odoo Purchase, Inventory, and POS to do this?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
5546
Views
- Create 1 product "Bottle". Make it purchaseable. The purchase UoM should be master case that you configure as 96 times the default UoM bottle. Make it also available in the POS. The sales UoM should be Bottle and it will be the UoM for inventory. You should also create a third UoM Case which is 12 times bigger than Bottle. Bottle should be your base UoM.
- Create 1 other product "Case" with a BoM that has the Bottle product as a component and is made of 12 Bottles. Configure Case as make to order and manufacturing. Do not make it purchaseable.
- Create 1 other product "Master Case" with a BoM that has the Bottle product as a component and is made of 96 Bottles. Configure Master Case as make to order and manufacturing. Do not make it purchaseable.
- Install the module procurement_jit.
The flow will be as follows:
a. Create a PO, select the product Bottle and the UoM Master Case and buy 5 of them.
b. Receive the shipment. This will increase your stock by 5*96 = 480 bottles.
c. Go to your POS and sell 2 cases. JIT will be triggered and 2*12 = 24 bottles will be consumed to make 2 cases and they will be moved to the customer location. Essentially, your stock of cases is going from 0 to 2 and back to 0 in one click here. And your stock of bottles is going from 480 to 456 because 24 are being consumed.
I mainly deal with single bottles and case of 24 bottles. The above method does work, but doing store-wide inventory in bottles rather than counting large cases is difficult and involves constant extra math.
Also, on delivery order picking slips it always says to deliver 24 bottles to customers instead of 1 case, not ideal for employees. This can get confusing very quickly on large orders.
I was trying to setup in the following way. BoM for "single bottle" has component 1 unit of "24 case" and MRP byproduct of 23 units "single bottle". This way if qty bottles=0, when a bottle is sold in POS, 1 unit is deducted from "24 case" and I now have qty of 23 more "single bottles" to sell until I have to "manufacture" more by opening another case. This would solve all my issues (and probably for many other people too) but unfortunately I cannot seem to get "byproducts" module to work at all. Quantity of byproduct is never updated whether selling through sales order or POS. Even if I could get this to work, it still does not seem to fix the issue of the BoM components show up on delivery sheet instead of products ordered.
I would greatly appreciate any help/advice, thanks!
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up