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?
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
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
Any idea of the table to use for exporting the BOMs using Config Packages?
There are 2 tables required - headers, and lines.
Production BOM Header (Table 99000771)
Production BOM Line (Table 99000772)
Thanks, I will try this. I've only exported on table at a time in the past.
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
For assembly BOM the information is stored in BOM Component (Table ID 90)
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,275
Sumit Singh 2,677
Nimsara Jayathilaka. 2,526
