Assistance Required for Material Request Behavior in ERPNext

[mayurpansheriya]

@snv @ankush

We need little help. Let me explain you.

Recently, we are trying to migrate our ERP from Odoo to ERPNext. We are in green house accessories manufacturing. We making many of item which has semi finished goods (i.e intermediate item). These semi finished item needs to have stock so we have proper inventories as this item can be used to manufacture other items also. So we have made intermediate item with its BOM as we do in Oddo.

But we have issue with Material Request and Work Order. Let me explain process.

We have item called Clamp with is made from GI Sheet. GI Sheet has stock UoM as Kg and Clam has Nos. Between them there is 4 semi finished goods item we called as (GI Sheet Nos, BSH, SSH, PPP, PPE) and all has Nos as default UoM. 1 Sheet 49.060 Kg (its varied every time). So here are the BOMs.

GI Sheet (KG) - GI Sheet (Nos) – BHS – SSH – PPP – PPE - Clamp

49.060Kg–1 sheet– 4 sheet cut (BHS)– 62 sheet cut (SSH) –1 piece (PPP) –1 piece (PPE) –1 (Clamp)

So here 1 sheet can produce total 248 Camps.

Now the problem is that if I raised MR/WO for 1 Clam then ERPNext will be raising the request of 0.198 Kg not full sheet i.e, it should be raised 49.060Kg. Here is the sample use cases:

Expected vs. actual behavior is attached.

So expected MR/WO should raised full sheet Kgs as we can not procure cutting GI sheet its need to be in full.

Could you help us how we can handle this scenario as we have many items which has this type of items.

Any help or insights would be greatly appreciated! Thanks.

Best regards,
Mayur Pansheriya

[max_morais_dmm]

Hi @mayurpansheriya on the item master, you will need to apply the conversion rate between G1 Sheet Kg and Nos, also ensure that the purchase UOM is Nos, but the minimal purchase quantity is 49.060

It’s kind counter-intuitive, but you need to pass the purchase quantity in stock unit, while you say, the default purchase unit will be another unit!

This will ensure that when a purchase is raised from the Production Plan, it always purchase whole units.

[mayurpansheriya]

@max_morais_dmm Thanks for your quick reply.

That’s the way to manage the material request but while creating the work order, its not allowing to change the “Required Qty” as it will fatch directly from BOM and while submitting it’s not allowed as stock UoM is in fraction. Please refer the below image. So we are in deadlock situation. Anything we can do?

[mangroliya]

Hi,

You can untick “Must be Whole Number” in Unit of Measure for Nos.

Regards,

Divyesh M.

[mayurpansheriya]

@mangroliya it should be whole number in our case. Please read the first post so you have better idea what we are trying to achieve.

Regards,
Mayur

[max_morais_dmm]

@mayurpansheriya , this is an optimization problem, I had to deal with this several times dealing with woodworking in ERPNext

So, let’s think about a Kitchen Cabinet

Each part is made of the same sheet of plywood, so, each part is a fraction of the whole plywood sheet

Each plywood 1200mm x 2400mm

To address this in ERPNext, I had to implement the following structure and customization

Each Part has it’s own BOM, that requires as raw materials the plywood sheet, the quantity field is the squared size of the piece length mm x height mm

And I have the cabinet, that requires all the sub-boms

So Hierarchy looks like

Cabinet

• Back
  • Plywood
• Side
  • Plywood
• Base
  • Plywood

So, the plywood is used everywhere and if I run the production plan as it’s right now, it will fail!

So, I had to develop an optimization, that does the following

It analyse all cuts, and create a BOM, where my produced item is “Plywood Scrap” and the real produced parts goes into the Scrap section

After the physical cut, the work order fort this BOM is completed on the system, and the stock of all sub parts is fulfilled

Then I can run the production plan, properly!

I think that you will need to face a similar situation to resolve your issue