Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have attached a file with two sheets.
One is BOM (Bill of materials) 1st columns is Finished Goods and 2nd column is components.
The second sheet is inventory ledger.
It has production of Finished goods and consumption of Raw materials.
i want an output as follows:
FG | RM | FG Qty | Std Qty | RM Qty | Variance |
300025024 | 100270130 | 130 | 130 | 130 | 0 |
300025024 | 100270560 | 130 | 130 | 130 | 0 |
300025024 | 100270570 | 130 | 130 | 130 | 0 |
300025024 | 100843330 | 130 | 130 | 130 | 0 |
Std Qty is BOM Qty X FG Qty.
i have also attached BOM file.
please check and give me a solution.
I am using personal edition. Hence, please write the script and do not upload qvw file.
Maybe this is helpful: Bill of Materials
- Marcus
Hi Kartik,
How you Calculated this fields output like this .Can u explain me?
FGQty ,STDQty , RMQty,Varience
130, 130, 130 , 0
130, 130, 130 , 0
130, 130, 130 , 0
130, 130, 130 , 0
Regards,
Mahesh.