Hey does anyone have any import scenarios that are just simple to update stock item descriptions from an excel provider?
Here is what I have so far, it should just be look up the inventory item, fill in the description, and save. But for some reason, I keep getting errors saying
Error: The [InventoryCD] identifier is already used for another business account record (vendor, customer, employee, branch, company, or company group).
Best answer by bodiec
This is the Import Scenario that finally worked.
+6Instead of selecting the key, select Inventory ID field. The key will be added in a new row automatically.
Hello
Here is a sample
Thanks
But I still get the same error?
It still seems like the system is trying to create a new Inventory ID, instead of just locating the existing one and changing it.
+6
No I don’t believe they are, they look like HELLO1000013
+6I just noticed you have the wrong object and field for description field. Change it to Stock Item Summary, then select Description as the field.
I think that is likely the problem, but if still doesn't work, check your Excel file and make sure the ID's have no leading or trailing spaces.
I even redownloaded the stock item excel sheet to make sure I had the correct IDs and verified there is no spaces.
+6
If that's not the case, would recommend contacting your Acumatica support. I would need access to troubleshoot further.
But now the error message seems to have changed. It only says “92 items have not been processed successfully. View name: Item.” This means it cannot find the Inventory IDs right?
But I literally just exported an excel sheet out of the system and brought it right back in. I don’t see why they don’t match.
+6
In this context, ID refers to the UI field which is the CD, not the database field, so that shouldn’t be the issue.
This is the Import Scenario that finally worked.
+6
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
