How to do dynamic inventory in oDoo?

Question

We sell custom width tape what we cut from vendor roll. Vendor roll always fix width - 1500 mm. We cut fix width for online store like 6mm, 9mm, 12mm, 20mm (most popular sizes). But we can cut custom width when customer come into store. from 6mm - 500mm.
we would like to implement dynamic inventory:
If we received roll 1500mm in the inventory we can cut:
6mm - 250 rolls
9mm - 165 rolls
12mm - 125 rolls
and so on...
But if we sell 10 rolls by 9mm inventory should be dynamically recalculates as we

Sergiy Genyuk · Answer

Awesome !!! Thank you very much Mark !!! Only last question still open for me. each vendor roll what we purchase has fix width 1500 millimeters. And when we cut different sizes it is come to the point where we cannot cut from roll number 1 30mm tape but we can do it from roll number two. How to manage inventory in this case? I assume that we should do some internal mark of rolls...
Thank you.

Marc De Costa · Answer

Hi Sergiy,
I will assume that you maintain the inventory in width but sell them as rolls.
1. You could create a new unit of measure category called width (any name you like). Then create several units of measures
image [1]
2. Create a product with the following UoMs
image [2]

3. Create a purchase order with the UoM 1500 roll - I have received 3 * 1500mm rolls. This means now you have 4500mm in the inventory.
image [3]
4. Create a sales order. In the sales order, you can decide if you are sellin

This question has been flagged

Enjoying the discussion? Don't just read, join in!