Skip to main content

Notifications

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

Any way to mass-export BOM's?

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,907 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,907 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 73,110 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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans