Hi community,
We’re facing an issue in ERPNext where Work Orders are not calculating raw material quantities using the sub-assembly’s BOM, even though a multi-level BOM structure is correctly defined.
Use Case: Multi-Level Manufacturing
Raw Material: GI Sheet (in Kg)
Sub-Assembly Item: “Sheet” in Nos
Has its own BOM: 1 Nos = 49.060 Kg GI Sheet
Final Product: Cut Sheet
BOM: 4 Cut Sheets = 1 Sheet (Nos)
i.e., 1 Cut = 0.25 Sheet
If we manufacture 5 Cut Sheets:
ERPNext should calculate that 5 × 0.25 = 1.25 Sheets
Hence raw material of the Sheet’s BOM to calculate:
1.25 Sheets × 49.060 Kg = 61.325 Kg of GI Sheet
While it should calculate 98.12 Kg of Raw Material.
Sample other cases:
Cut Pieces GI Sheet Required (Kg) ERPNext Pulls
1 49.060 12.265 Kg
2 49.060 24.530 Kg
4 49.060 49.060 Kg
5 98.120 61.325 Kg
8 98.120 98.120 Kg
9 147.180 110.385 Kg
Any help or insights would be greatly appreciated!
Regards,
Mayur