Hi All,
I want to calculate the consumption of Raw Material based on my Master Data and Finished Goods Production Report.
Here, I have attached the 2 screen-shots 1st for Master Data where I have consumption of Raw Materials per PCS for each Finished Goods like;
and here I have production report, in Sold/Consumption column I want to calculate Total Consumption of Raw Material 1 based on Manufactured Units + Master Data.
Thanks,