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.