Hello Guys,
Recently we notice, one of our manufacturing company is facing production cost miss calculation per SKU due to clubbing of multiple SKUs in a single work order. when multiple SKUs of the same class or family are clubbed together in a single production work order, Sage X3 prorate the quantity of the common component in the work order by adding together the required quantity for all the SKUs according to BOM and dividing it by the total planned quantity for all the SKUs and multiplying it by the planned quantity for each SKU and does not follow the required quantity defined in the BOM( Bill of Materials).
Please can anyone advise if there is any setup requirement in Sage X3 so it does not prorate the common component and for the system to follow the required quantity defined in the BOM, kindly see the below screenshot for details.
Stock keeping UOM is EA(Each)
Sage X3 Version 11 patch 12
You advise will be highly appreciated.
Item Code | Description | Planned Qty | Required Qty per Unit according to BOM | Required Qty according to BOM | Consumed Qty in Production Tracking according to Sage X3 Proration | |
M1009 | 1 Gallon Pack | 523.00 | 3.79 | 1,982.17 | 390.30 | |
M1001 | 180 Milliliter Pack | 1190.00 | 0.18 | 214.20 | 888.07 | |
M1005 | 1 Liter Pack | 1400.00 | 1 | 1,400.00 | 1,044.79 | |
M1003 | 250 Milliliter Pack | 5760.00 | 0.25 | 1,440.00 | 4,298.55 | |
M1004 | 500 Milliliter Pack | 6680.00 | 0.5 | 3,340.00 | 4,985.12 | |
M1006 | 2 Liter Pack | 7374.00 | 2 | 14,748.00 | 5,503.04 | |
M1002 | 200 Milliliter Pack | 11010.00 | 0.2 | 2,202.00 | 8,216.50 | |
Total | 33937.00 | 25,326.37 | 25,326.37 |