BOM Material Description Update from Stock Item via Import Scenario

So you are trying to put the BOM Description to be the same as the Stock Item? If you are looking to do that, then your import scenario needs to be modified. Are you trying to do it using an excel file, or would you like to use the Inventory ID description from the system?

I have also included the XML that you can import into your system. 

If you are trying to use it from the system, you can do this:

for your Data Provider, you can use the following:

I need to ensure the Stock Item description is the single source of truth for the Bill of Materials (BOM).

My goal is to create an Import Scenario that automatically updates the stock item description within the BOM whenever the original Stock Item description is changed.

Once the Import Scenario is validated, I plan to convert this logic into a Business Event that will fire upon a change to the Stock Item description.
 

I have had a really hard time with this and I thank you for your help in trying to solve this! I will use your mapping and see what happens.
Also not sure what to do with the Xml data. 

I dont know where you see the full error message but sometime it shows up in the import scenario table but this time the error didnt have a readable message on this screen

I tried this mapping.
 

and got this error
 

​@jdobish’s version was very close but made an assumption about the Status of your BOMs. A BOM description can only be edited if the BOM is ‘On Hold’. This version will put the BOM on hold temporarily while the description is updated and then remove it again.

Thanks guys! I uploaded that XML. I think its close. I am getting this error

I have verified that my instance gives the same error when processing multiple lines. (I only tested with one initially.) I have also discovered that the issue arises from trying to set ‘Hold’ to ‘False’. If I disable that line, mine import correctly, however, the BOMs are left on ‘Hold’.

I haven’t found a way around that.

I am going to disable the line and try.
 

The import successfully updated the Inventory ID corresponding to the Bill of Materials (BOM), but the component items within the BOM remain unmodified. We are very close to a complete solution!
 

My mismatch description GI is still pulling these values
 

I didn’t realize you wanted to change the component items as well. that is different from just updating the item at the stock header. You may have to delete the item and add it back in. 

Also, as a note, you don’t need to have the BOM on hold when using imports. 

So I have to actually create a delete action in this map dont I? This mapping I know is already a mess but I do have it linked to my GI now and not an excel file.
 

This mapping keeps throwing ‘BOMID’ cannot be empty
 

you may need to look at the inventory id, and then delete it, then add it back in with the same information. The BOMID cannot be empty error is sort of a catch all and not the most helpful. There is most likely something happening in the import scenario that it is trying to do and that is the first error that it throws. 

your import doesn’t have look at for the operationID which is needed to identify the material line number. That is where the error is being thrown.  Also, there should not be a space between the @@InventoryID (Not @@Inventory ID)

i’m a bit tied up today so i can’t mess around with it. 

  try looking here too

Check this one out. You may need to change the name, but also look at the BOM Details itself to make sure that there is not something odd with the GI that you have. 

This mapping actually got one line to process! The operations ID point you made checked out for sure

Glad you got it!