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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Can you import BOM components?

(0) ShareShare
ReportReport
Posted on by 774

Is it possible to import BOM components into D365 Business Edition?

If so, is there a template for importing BOM Components?

If not, are there plans for this in a future release?

  • Verified answer
    Tammy Torgerson Profile Picture
    Microsoft Employee on at

    Hi MCarrero,

    Thank you for the questions.

    It is possible to use the Edit in Excel functionality to add existing items as components on a BOM Assembly. In order to do this, I viewed one of my existing Items in the Item Card page. I then clicked on the Navigate tab in the ribbon and then chose Assembly - Assembly BOM. This opened the Assembly BOM page. Here I clicked the Edit in Excel button. I was able to add a new line in the spreadsheet--what I did was to add an existing item as a component.

    When you use this Edit in Excel option, the spreadsheet which opens provides the necessary fields. I populated these fields:

    • Type
    • No
    • Description
    • Assembly_BOM
    • Quantity_per
    • Unit_of_Measure_Code
    • Parent_Item_No
    • Line_No

    Adding the BOM Components does require that the desired Items already be added--both those which will be the Assembly (parent) item and those that will be the Component (child) items. There are a number of ways in which Items can be imported/added, in addition to hand-entry:

    • Import from Excel under the Migration tools
    • Configuration Packages
    • Edit in Excel from the Items page or Item Card page

    I hope that this information helps.

  • MCarrero Profile Picture
    774 on at

    Thank you Tammy.  I had found this way to do it while waiting on your response but wanted to see if there was any other way to do it.  It does work as you stated.  

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans