Excel report

[yshenoy]

Dear sirs,

We have developed an ERP where in we have created BOM in production module . each BOM is created for each components of WIP by using RM items as child items and in turn created BOM for the FG by using WIP items are Child items . Now we want to know the RM consumption of FG items . Fro the BOM report we download , we are not in a position to know how much RM is used for FG. Since there are thousands of such BOM is created , we are not able to extract this report in ERP. Can we make such report in Excel using any excel function from the data downloaded from ERP . I have enclosed a sample file for your understanding

please let me know if there is any solution
regards

Yogish Shenoy

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[yshenoy]

Hi
Sorry I forgot to attach the file . Please find the attachment
regards

Yogish Shenoy