Skip to Content
This question has been flagged
manufacturingpartiallymeasures
1 Atsakyti
1630 Rodiniai
Portretas
KEMA SK s.r.o

Let's imagine this scenario: I produce Ethernet cables of various lengths - i.e. 25m, 50m, 75m, 100m, ... Each such final cable requires 2 connectors and that particular amount of "raw" cable. I can only buy raw cable in rolls of 1000m.


So when I buy a new roll and produce one final 50m cable, 950m of raw cable remains. When I produce another of 100m length, 850m of raw cable remains. When my remaining raw cable on certain roll is 50m I cannot produce 100m final cable and need to order another raw cable roll.


Can anyone please suggest on how to model this? Thank you.

Portretas
Atmesti
Lars Aam

This a sort of complex MRP is not solved in Odoo as standard. It might possible with development, but I know this a a very complex situation.
I have experience from 20 years in the cable business, running SAP R/3 with " cable solution".
In short: Each lenght of cable must have a unique LOT number.
In all order line view: For cable products yuo must specify Individual lenghts. Let say you will produce 100 pcs of 50 M cable, then you specify you need 100 x 50 M raw material. Then in availabilty check, you can only reserve lot number where qty > 50m.

But this part is only a small part of the complexity you will have in MRP, with managing individual lenghts.

Portretas
Lucas
Best Answer

It would be helpful to include the Odoo version and the Apps that you are using. 

There are several ways to solve your problem using Odoo standard

You can configure the raw cable as using different units of measure for purchasing and sale: https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/products/uom.html

In this case you can purchase the raw cable in 'Units' where 1 unit = 1000m

The ethernet cables should be sold in metres (or consume metres of raw cable in manufacturing)

Assuming you are using the MRP app, you can create Bills of Materials for each finished ethernet cable.

e.g. 100m ethernet cable has components: 100m raw cable & 2 x connectors.

If you are not using the MRP app then you can just enter the components on the sale order lines.

If you do not have enough raw cable in either case, you will not be able to sell / manufacture the ethernet cable.

If you set up reordering rules, you can trigger the creation of a purchase order when the inventory of raw cable becomes too low.

I hope this answers your question

Portretas
Atmesti
KEMA SK s.r.o
Autorius

Well yes and no. What would happen if I have 2 rolls of 50m and want to produce 100m cable? I guess Odoo would try to "combine" these 2 rolls as it would seem together they provide enough. That would be OK if we were talking about pieces, kilos, litres, etc. - i.e. any units that are "joinable". But this is a different case.

Lucas

Ahhh, I did not think of that....interesting problem.
You could treat the shorter offcuts as separate products.
E.g. Cutting a 100m cable into a 75m piece and a 25m piece with the intention to sell the 75m piece.
In that scenario you could consume 100m in the components on the BoM and have the 25m piece as a byproduct as a separate product.
Consume: 100m raw cable (A), Output: 75m ethernet (B) + 25m OFFCUT (C)
The offcut could then be handled differently in your inventory

In your example, 2 rolls of 50m would be separate products. So your inventory would show that you have 0m of raw cable required to make a 100m roll.

The Offcuts could be used as alternate BoMs for any length shorter than the offcut.
E.g. Preferred BoM for 25m Ethernet = 25m of raw cable
Alternate BoM for 25m Ethernet = 50m OFFCUT (with a 25m OFFCUT byproduct)
and so on...

Related Posts Replies Rodiniai Veikla
Master Production Scheduling in "Manufacturing module"
manufacturing
Portretas
Portretas
1
lapkr. 25
188
How to make Odoo schedule manufacturing in parallel?
manufacturing
Portretas
0
spal. 25
524
Change in Work Center Productivity Accounting
manufacturing
Portretas
Portretas
1
rugs. 25
1329
How to disable form view if there are not registers?
manufacturing
Portretas
Portretas
2
rugs. 25
1008
Columna calculada en orden de producción
manufacturing
Portretas
Portretas
2
rugs. 25
867