I want to print a report where I can see the information of all the raw materials (Items) that are needed, its inventory quantity and the quantity needed(quantity that I have to purchase) that are up for all the Sales Order. Its hard specifically in the case of the BOM materials.
I use Planning worksheet to check the quantity but what it does is, it shows me the material required for just one item. I want the total quantity of raw material for all the Items that are on Sales order. There are many BOM items where the raw materials used are same. So, in planning worksheet, I have to finally add all those quantity which is really time consuming.
Please inform me which is the report for that. I am sure Microsoft must have created some report for that but I am unable to find it.