Consume product that is bought in certain measure partially only

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

subcontracting MRP equipment manufacturing BoM

O tym forum

Consume product that is bought in certain measure partially only

manufacturing partially measures

1 Odpowiedz

1243 Widoki

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
how can i get MFg date in Inventory module? manufacturing	2 sie 25	490
Change in Work Center Productivity Accounting manufacturing	0 lip 25	473
Suddenly MO's from SO's are being generated as confirmed instead of draft ... we need to change the BoM manufacturing	1 lip 25	904
Manufacturing: two products at once from the same materials Rozwiązane manufacturing	1 lip 25	1299
add more than 1 product to work order manufacturing	0 cze 25	606

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!