Small and medium business | Business Central, N...

Quantity Exmplosion Format

(5) Share

Report

Posted on by MP-26111204-0

Hello,

In Navision 2018, I am making a BOM explosion, this gives me the below format in Excel.

This format is nice for reporting, but I need the raw data format

In Business Central when I do it I get another format, is there a way to get the same format from Navision

Categories:

Microsoft Dynamics NAV

All responses (6)

Answers (0)

Suggested answer

Mansi Soni 5,682 on at

Like (3)

Report

Quantity Exmplosion Format

Hello,

You can run the Quantity Explosion of BOM report in Business Central, this report will provide you the data as per your requirement and if you want it in excel then click on Send to > Microsoft Excel Document (data and layout).

Hope this answer will help you!

Regards,
Mansi Soni
Gerardo Rentería Ga... 20,949 Most Valuable Professional on at

Like (1)

Report

Quantity Exmplosion Format

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central: How to export data from tables to CSV (comma-separated values) file | Dynamics 365 Lab

Walkthrough: Exporting Data from Tables to CSV Files

Best Regards
Gerardo
Suggested answer

Andrés Arias 1,378 on at

Like (1)

Report

Quantity Exmplosion Format

Hello,

You could try the following option:

I hope I can help.

Regards,

Andres
Suggested answer

YUN ZHU 85,982 Super User 2025 Season 1 on at

Like (1)

Report

Quantity Exmplosion Format

Hi, Try the following option

Thanks

ZHU
Suggested answer

Sohail Ahmed 4,829 on at

Like (2)

Report

Quantity Exmplosion Format

In NAV 2018, the BOM Explosion report was often customized or exported via Excel in a tree-like format for reporting. In Business Central, the standard format is different and more data-centric.

To get the same raw format as in NAV:

You’ll need to customize the report or use queries/pages based on:

Production BOM Line (99000772)

Item (27)

Item Where-Used page (99000773)

If you're looking for a flat, explodable structure for Excel, consider using Power BI connected to those tables, or export via a custom report or query.

👉 If the NAV format was a custom layout, replicate that layout through Word/Excel Layout or custom report in BC.

✅ Let me know if you want help replicating it.
Suggested answer

Ramesh Kumar 5,496 on at

Like (0)

Report

Quantity Exmplosion Format

If I am not mistaken you need to check "Production BOM Line" table (Table 99000772)

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.