Skip to main content

Notifications

Announcements

No record found.

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

Bill of Materials

(0) ShareShare
ReportReport
Posted on by 15

Is there a way to export all Bill of Materials (BOM) at once so we can update and then import back in? We have in excess of 10,000 BOM's

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 41 on at
    RE: Bill of Materials

    Adding my input:

    I suggest configuration packages if number of BOMs is small as it is simple and less chance of error.

    But for a large number of BOMs as in your case it will take hours and hours and exhaust memory (I have experienced).

    So use AL code and create xmlport to import and export data very fastly.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Bill of Materials

    Instead of exporting them for updating, maybe you can talk with your partner and they can write code to do the changes you want automatically without having to do the export and import.

    I think that would be safer and more efficient.

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,997 Super User 2024 Season 2 on at
    RE: Bill of Materials

    I have to agree with Narang.  The process can be accomplished using the Configuration Packages, but with the number of records it will take a long time.  If you were only updating a handful of BOMs at a time, and could easily filter to those records, the processing would be faster.  If you are trying to do all 10k BOMs its going to take a LONG time.

    You would save tremendous time and frustration creating for an XML port to handle the export and import of the data.  The other HUGE advantage of an XML port is the ability to add logic to the import.  Often times you don't have to manipulate as much data if you can build logic into the import.

    If you don't have a developer on staff, I would encourage you to reach out to your Business Central partner for this.

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,238 Super User 2024 Season 1 on at
    RE: Bill of Materials

    Hi John - While configuration packages can be the OOTB Way of exporting & importing data in Business Central (via Excel), sometimes it can take time. Since the number of records is too much, it may take you a while to import but nonetheless your job will be done. I recommend first try importing/exporting in a Sandbox environment as configuration packages can behave funny in some cases

    www.youtube.com/watch

    Alternatively, if you are developer/can hire a developer, check with him if he/she can build a CSV Import tool for you (Via XMLPort) to import  this data faster. However customization can cost you time and additional $$, so it's not always the way to go, unless you want to

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,050 Super User 2024 Season 2 on at
    RE: Bill of Materials

    Did you consider 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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans