Contributors mailing list archives

Browse archives


Re: Manufacturing advice needed - materials of measured units being consumed partially

- 27/01/2022 04:53:37
Hello Radovan,

First, to track your raw materials you should automatically be able to do it. Let’s say you buy rolls of cable every time to produce your own cables. The cable on hand quantity should get always be updated whenever you purchase new stock.

The BOM will look like this:
1. Certain amount of roll cable (maybe 50m for 50m final Ethernet cable)
2. 2 connectors

Now let’s say you have 21 manufacturing order or 21x50= 1050meter manufacturing order. But let’s say you have 1000m (1roll) in stock. The system in the MO will automatically show you that you don’t have enough stock to produce 1050m cable. If you have single MO, you can modify that or if you have 21 MO you can complete the extra MO later when stock arrives.

 If you want to automatically order the raw materials after certain quantity, you can use replenishment order.

Secondly, use multiple UOM for sales and purchase. By that you can purchase in rolls but produce/sale in meters and consume accordingly.

Md. Tanzilul Hasan Khan

On Jan 27, 2022 at 2:37 AM, <Radovan Skolnik> wrote:


sorry for asking stupid questions here but I hope someone can provide some wisdom here that I am missing.

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.

So the idea is tracking remaining quantity of somethings (products? lots? ...) that is bought at certain size and is being gradually consumed. There can of course be more of these (i.e. I have bought 3 rolls at the same time).

Is there a way on how to model this? Manufacturing is not really my domain and looking through code of various modules I didn't find anything that would resemble such thing.

Thank you very much. Best regards

	Radovan Skolnik