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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Try the following option

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

You could try the following option:

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,911 Super User 2025 Season 2 on at

Like (3)

Report

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

Was this reply helpful? Yes No