Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

subcontracting MRP equipment manufacturing BoM

Despre acest forum

Consume product that is bought in certain measure partially only

manufacturing partially measures

1 Răspunde

1631 Vizualizări

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.

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.

Lucas

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

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

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

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Master Production Scheduling in "Manufacturing module" manufacturing	1 nov. 25	188
How to make Odoo schedule manufacturing in parallel? manufacturing	0 oct. 25	524
Change in Work Center Productivity Accounting manufacturing	1 sept. 25	1329
How to disable form view if there are not registers? manufacturing	2 sept. 25	1008
Columna calculada en orden de producción manufacturing	2 sept. 25	867

Această întrebare a fost marcată

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