BOM Excel Export for Costing for Microsoft Dynamics 365 Business Central
Final costing and budget work on a product often happens in a spreadsheet, and rebuilding a multi-level bill of materials (BOM) there by hand is slow and error-prone. Multi-Level BOM Viewer exports BOM data from Business Central to Excel for final costing and budget analysis.
The spreadsheet starts from the BOM as it stands in Business Central, not from a copy someone typed.
How BOM Excel export for costing works in Multi-Level BOM Viewer
- Open the production BOM in Multi-Level BOM Viewer.
- Export the BOM data to Excel.
- Complete final costing and budget analysis in Excel.
- Return to Multi-Level BOM Viewer to adjust the BOM if the costing calls for it.
Key capabilities
Export from the viewer
Multi-Level BOM Viewer sends BOM data to Excel, so the structure does not have to be rebuilt in a spreadsheet.
Final costing in Excel
Cost accountants and planners complete final costing in Excel, starting from the BOM data instead of a blank sheet.
Budget analysis
Combine the exported data with other figures for budget analysis in the tool the finance team already uses.
Part of the workflow
Export, complete the costing, and come back to the viewer to edit BOM lines if the numbers call for a change.
Details that matter on the floor
Costing happens in Excel
Multi-Level BOM Viewer provides the BOM data; the costing itself is done in Excel. Plan the costing workbook with that split in mind.
Who uses BOM Excel export for costing
Cost accountants and financial analysts
Start costing and budget work from current BOM data in Excel.
Production planners
Hand a BOM to finance without copying it line by line.
Questions about BOM Excel export for costing
Can I export a multi-level BOM to Excel from Business Central?
Yes, with Multi-Level BOM Viewer. Multi-Level BOM Viewer exports BOM data to Excel for final costing and budget analysis.
Does Multi-Level BOM Viewer calculate product cost?
No. Export the data to Excel for final costing. For actual against expected cost on production orders, see Production Order Analysis, which comes with the Enhanced Planning Pack.
Can I change the BOM after costing it?
Yes. Return to Multi-Level BOM Viewer and edit the lines that need to change.
Related Multi-Level BOM Viewer features
All Multi-Level BOM Viewer features →Part of Multi-Level BOM Viewer
Easily visualize and edit complex BOM hierarchies for streamlined operations.
Have a question about BOM Excel export for costing?
Send us a note and the Multi-Level BOM Viewer team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.