BOM Export Options
Here are some options for exporting your bill of materials.
1. Exporting All BOMs and Routings (File - Data Export)
To export all of your existing BOM routings and BOM components you can go to our File - Data Export menu.
2. Exporting a single BOM Routing and Components
You can export individual BOMs from the BOM routing tab and the BOM component tab and exporting the result to a spreadsheet. The following screenshots demonstrate how you can select the output button and then choose all of the columns you wish to have in your export sheet. You can then save your preferred format for repeat use.
3. Database Queries
You can run a query for exporting individual components and routings. Here are a couple of queries that would give you the same results as the step two above. You can run by specific item by changing the statement in bold to your particular BOM parent part number. Or, if you get rid of the segment in bold you will get a result of all of your BOM routings and all of your BOM components.
select BM.PITEMCODE, BM.METHOD, BS.STAGE, BS.DESCRIPT, BS.WORKCENTERNAME, BS.MACHINESID, BS.SETUPHOURS, BS.UTILIZATION, BS.PARTSHOUR, BS.BACKFLUSH, BS.QTYDAYS, BS.NOTES, BS.SUPPNAME, BS.LEADTIME, BS.COST, BS.PONOTES from BOMSTAGES BS, BOMMASTER BM where BM.bommno = BS.bommno and BM.PITEMCODE = '1080-000'
select BD.PITEMCODE, BM.METHOD, BD.CITEMCODE, BD.LINNO, BD.INVTYPE, BD.USAGE, BD.NOTES from BOMDEL BD, BOMMASTER BM where BM.bommno = BD.bommno and BD.PITEMCODE = '1080-000'
4, ODBC for use in outside programs
Some companies use ODBC to query info from DBA to export to an external program. The following link provides a KB on setting up ODBC.