Skip to Content
This question has been flagged
manufacturingpartiallymeasures
1 Respondre
1578 Vistes
Avatar
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.

Avatar
Descartar
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.

Avatar
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

Avatar
Descartar
KEMA SK s.r.o
Autor

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 Respostes Vistes Activitat
How to make Odoo schedule manufacturing in parallel?
manufacturing
Avatar
0
d’oct. 25
408
Change in Work Center Productivity Accounting
manufacturing
Avatar
Avatar
1
de set. 25
1243
How to disable form view if there are not registers?
manufacturing
Avatar
Avatar
2
de set. 25
951
Columna calculada en orden de producción
manufacturing
Avatar
Avatar
2
de set. 25
810
v18: 2 step manufacturing route:picking & manufacture. Problem trigger picking ignored
manufacturing
Avatar
Avatar
Avatar
3
d’oct. 25
1141