How can I define order units for products that are used as input material for production? For example I produce bags from a textile which is measured in meters and always want to know how much meters of textile I have in stock. To produce one bag, I need 1.2 m of textile. So if I produce 100 bags, I need 120 meters of textile. A supplier delivers textile on a roll with 100 meters per roll. Therefore I can either order 100 meters (1 roll), 200 meters (2 rolls), 300 meters (3 rolls),... To produce 100 bags I need to order two rolls (200 m) of textile.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Apskaita
- Atsarga
- PoS
- Projektas
- MRP
This question has been flagged
3
Replies
10271
Rodiniai
In this case i suppose you buy "units", the you can buy 1...2...3...N rolls. so the length (in this phase) is not that important because you're about to place 3 rolls in your warehouse. Indeed, you'll probably want to use just 1 meter then you'll need to convert rolls into meters. By assigning a lot number to a roll you'll be able to track the usage.
When you need to get 1 mt from a specific roll you can use 1/100 of roll for instance.
Otherwise you can use different UoM and specify the conversion coefficient. This way you'll be able to buy rolls and put meters into your warehouse.
In order to be able to specify this infos, you have to grant you user the "Manage Secondary Unit of Measure" permission.
Thank you! I would prefer working with different Units of measure. so I created a new unit of measure "roll 100" m which has the type lenght and a ratio of 100 towards the reference UoM which is m and it works fine for m. A big plus would be if I could change the unit of measure for a product per supplier as maybe I got the same material from one supplier 100 m on a roll and from another supplier 50 m on a roll. But as far as I can see, it automatically ads the product UoM also to the supplier.
We have a solution for the same. We have developed set of custom modules to manage this as 'CatchW8', where you can manage the inventory, sales, purchase, invoicing, manufacturing etc. in dual units of measure.
https://apps.odoo.com/apps/modules/browse?search=catchw8
https://www.youtube.com/watch?v=klucnmDxZk8
https://www.youtube.com/watch?v=zATy9uf31HE
https://www.youtube.com/channel/UC06LOpRSKlmdepz4KXhZ8vQ
I have something similar solved with manufacturing. We have drums of xxx kg on stock, sometimes we sell in yy kg or zz litres packings. I created a product of 1 kg, if necessary it takes one xxx kg drum from stock to produce xxx times 1 kg. Done so with re-ordering rules etc. yy times this 1 kg is then used to create the product we sell. In the case of litres, it is converted into this unit.
So we have on stock: aa drums (of xxx kg), can be your rolls of 100m bb x 1 kg of this product, which is used to create the endproducts. Can be a roll from which some cloth is taken. If because of the (pending) manufacturing orders this (bb) will be <0, the re-ordering rules will take again one drum from stock, etc.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registracija| Related Posts | Replies | Rodiniai | Veikla | |
|---|---|---|---|---|
|
3
vas. 24
|
2804 | ||
|
1
gruod. 23
|
2518 | ||
|
3
rugp. 20
|
5134 | ||
|
Sales order line pop-up
Solved
|
|
5
spal. 19
|
9901 | |
|
3
bal. 23
|
6417 |
do you mean you by a roll of 100 mt then sell rolls of 200 mt?
No, I mean that I can either buy 1 roll = 100m or 2 rolls = 200m, or 3 rolls = 300 m,... I admit that my wording was a bit confusing. I re-typed the question to make it clearer.
In this case i suppose you buy "units", the you can buy 1...2...3...N rolls. so the lenght (in this phase) is not that important because you're about to place 3 rolls in your warehouse.
Thank you for the quick answer. Unfortunately this approach does not work for me as I need the textile as raw material for production and keep track of how many meters are left. In this example I need 1.2 m of textile to manufacture one bag. So if I manufacture 10 bags I consume 12 m and have left 88 m on the roll.
sorry...i did hit the return button too early
I know what you are trying to do, and i have not found a good solution in openERP yet. You would have to define a unique identity for every roll, and track every roll individually. In openERP right now that is not possible without custom programming. Products get lumped together, unless you create a new product for every item of inventory.
what's wrong with tracking each roll individually? IMO, assigning each roll to a lot then specify that lot when using the textile can work fine
Your suggestion is fine if the parents and children are finite, but if you want to store more information than "child consumed X feet of parent" it gets complicated very quickly. Like if you are buying 30,40,50 mm wide rolls and producing 30,40,50 mm wide children, simple 6 products, but if you want to produce children and parents that vary 1 mm you have to create and store a product for every width variation - 40 products.