In Odoo v19 Enterprise for a wholesale/retail business. I'd like to know your approach to the following inventory issue.
I'd like to know what your approach would be for the following inventory challenge.
Example: a product which is a one-liter oil bottle (unit) packed in boxes of 24 units. We purchase by box, inventory tracking is by box and most of our sales are wholesale, meaning by boxes.
We also have a small dedicated area for retail sales where we sell by individual units.
From what I've researched, the general approach is to define the inventory UoM as the smallest unit (units in this case) and then define larger packages available for purchase and sale. It works fine, however it means the inventory module and its reports show quantities in units — we normally keep stock between 200 and 400 boxes of this product, imagine that multiplied by 24, it's hard to work with.
On the other hand, if the inventory UoM is defined as a box of 24 and the sales UoM as unit, there can be rounding issues when selling individual units, leading to stock quantity discrepancies.
For this case, my questions are:
What would you do in my situation, what would your approach be?
Is there any third-party module that could help with this?
Is there any existing solution I haven't considered yet?
I greatly appreciate your responses.
