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

How to export all BOM structure from BC?

(2) Share

Report

Posted on by SC666

241

Hello everyone,

BOM structure under item card can show per top item breakdown in different levels WIPs and raw material, including work centers. Under production BOM I can only view next layer materials.

I use page inspection and fond the BOM structure page is a temporary page. Is there a way to export all the BOM structure in the system? How can I do that?

Thanks!!!

Shinee

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ben Baxter 6,620 Super User 2025 Season 2 on at

Like (2)

Report

As you mentioned the "Structure" view is temporary, but it can be "Open in Excel" if you are needing it for a specific Item.

You could also use the Cost Shares Breakdown report and send it to Excel. It isn't exactly the same, and the formatting isn't great, but it will get you the BOM level information. I don't think it includes the sub-assembly Routings though, so it isn't a complete picture.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,551 Super User 2025 Season 2 on at

Like (2)

Report
Perhaps exporting all the BOMs to Excel using Configuration Packages could help? To do this, you would need to export the following two tables:

Production BOM Header (Table 99000771)

Production BOM Line (Table 99000772)

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Satish Srivastava 242 on at

Like (0)

Report
Hi Shinee,

export all the Bills of Materials (BOMs) to Excel using Configuration Packages in Microsoft Dynamics 365 Business Central is a practical solution. This approach allows you to easily extract and manipulate the data outside of the system. Here's how you can proceed:

Steps to Export BOMs Using Configuration Packages

Create a Configuration Package:

Navigate to the Configuration Packages page in Business Central.

Create a new package and give it a meaningful name (e.g., "Export BOMs").

Add the Required Tables:

Add the following two tables to the configuration package:

Production BOM Header (Table 99000771): This table contains the general information about each BOM, such as the BOM number, description, and status.

Production BOM Line (Table 99000772): This table contains the detailed component information, including item numbers, quantities, and unit of measure.

Select the Fields to Export (Optional):

For each table, you can customize the fields to include in the export by selecting Table Fields within the configuration package.

Include only the fields you need to make the Excel file concise and relevant.

Export the Data:

Once the tables are added and configured, click Export to Excel.

The system will generate an Excel file containing the BOM data from the selected tables.

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

Like (2)

Report

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

Solved: Any way to mass-export BOM's?

Best Regards
Gerardo

Was this reply helpful? Yes No
SC666 241 on at

Like (0)

Report

Hello All,

I don't think the answers below worked.

I wanted to have a report like BOM structure showing all different level of ingredients including work center and machine centers.

I am not able to get the report from a standard page.

Is there a build in report with similar functionality?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, hope the following helps.

https://community.dynamics.com/forums/thread/details/?threadid=59b7baea-e35a-4212-8abd-769dfbdfba8c

And if you are a developer, you can also try the solutions below.
How to use Excel Buffer to Export data: https://yzhums.com/4180/

How to Export and Import Data (Using XMLports): https://yzhums.com/4809/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,947 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well: https://community.dynamics.com/forums/thread/details/?threadid=90888792-cc92-4053-9b8c-3a286c2e30f2

Was this reply helpful? Yes No