Skip to main content

Notifications

Announcements

No record found.

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?

  • troverman Profile Picture
    troverman 35 on at
    RE: Any way to mass-export BOM's?

    Thanks. This gives me what I was looking for.

  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    RE: Any way to mass-export BOM's?

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

  • troverman Profile Picture
    troverman 35 on at
    RE: Any way to mass-export BOM's?

    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

  • troverman Profile Picture
    troverman 35 on at
    RE: Any way to mass-export BOM's?

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

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    RE: Any way to mass-export BOM's?

    There are 2 tables required - headers, and lines.

    Production BOM Header (Table 99000771)

    Production BOM Line (Table 99000772)

  • troverman Profile Picture
    troverman 35 on at
    RE: Any way to mass-export BOM's?

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Any way to mass-export BOM's?

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Any way to mass-export BOM's?

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans