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

Notifications

Announcements

No record found.

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,105 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
    95,329 Super User 2025 Season 2 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,764 Super User 2025 Season 2 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,764 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans