web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Any way to mass-export BOM's?

(0) ShareShare
ReportReport
Posted on by 35

We have a number of items with Bill of Materials to make the parent item number. Is there a way to export these all at once instead of one at a time?

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,165 Moderator on at

    You can export them using a configuration package if you are familiar with them.

    And if you have a developer at hand they can do more customized exports depending on the data you need to export.

    learn.microsoft.com/.../set-up-standard-company-configuration-packages

  • Suggested answer
    YUN ZHU Profile Picture
    99,086 Super User 2026 Season 1 on at

    Hi, the Configuration package feature is a great solution that doesn't require any customization.
    More details: https://yzhums.com/4286/

    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

  • troverman Profile Picture
    35 on at

    Any idea of the table to use for exporting the BOMs using Config Packages?

  • KasparsSemjonovs Profile Picture
    4,817 Super User 2026 Season 1 on at

    There are 2 tables required - headers, and lines.

    Production BOM Header (Table 99000771)

    Production BOM Line (Table 99000772)

  • troverman Profile Picture
    35 on at

    Thanks, I will try this. I've only exported on table at a time in the past.

  • troverman Profile Picture
    35 on at

    OK, I created the config package and attempted to export to excel - but it came up empty. These are assembly boms which I know have many components to a parent item. What am I doing wrong? Thanks

  • Verified answer
    KasparsSemjonovs Profile Picture
    4,817 Super User 2026 Season 1 on at

    For assembly BOM the information is stored in BOM Component (Table ID 90)

  • troverman Profile Picture
    35 on at

    Thanks. This gives me what I was looking for.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans