Indented BOM

Question

Hi, 
 Version is Sage 500 7.4x 
 
 I would like to get Excel export of Indented Bill of Materials out of Sage 500. Does any one know how to get a indented Bill of Material? 
 
 Any help you can provide would be great.

jmallory · Accepted Answer

In the Manufacturing menu under the Insights folder you'll find a report called Bill of Material Report. Make sure the Print Single Level BOM Only checkbox is not marked on the Options Tab. Preview the report to the screen and Export it to Excel. This isn't perfect but it does give you the information and the subcomponents are indented from the finished good assembly. There are probably better ways to do this through backend SQL Queries. 
 The other option is to pull the data into Excel directly from the Bill of Material View. Go to Excel. Click on Data. Select "From Other Sources" and then select "SQL Server." Next you will need to identify the Server where Sage 500 is located. You will also need to use Windows Authentication or enter the user name and password to access the data. On the next screen you can select the Sage 500 database that you want to look at. You will then check the "Connect to a specific table" checkbox and find vdvBillofMaterial which is a view of the Bill of Material table. This will not show an indented list per se but the report you'll get does list the BOMtLevel which is the bill of material level for the routing. Level 0 are finished goods. Level 1 are one level down and level 2 are two levels down. And so on. You could then manually separate the unique routings and indent the materials per the BOM level in the report. Again, this isn't perfect but it's definitely an option. Good luck.

Sage 500

Indented BOM

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING