Skip to content
Multi-Level BOM Viewer app iconMulti-Level BOM ViewerExport and extension

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

  1. Open the production BOM in Multi-Level BOM Viewer.
  2. Export the BOM data to Excel.
  3. Complete final costing and budget analysis in Excel.
  4. 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.

Multi-Level BOM Viewer app icon

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.

Ask a product question

Product Questions