Trying to create a mass import scenario to change existing location IDs to new location IDs. I want to retain the history of the location so I don’t want to create new locations.
In the import scenario, there isn’t an option to Change ID like there is for stock items, warehouses, etc.
Once I map to the key field, is there a way to change the ID?
Or is there a way to do this directly from the locations table upload feature?
Best answer by bryanb39
The key is to make sure the description field is unique. You may need your current import scenario to edit descriptions first, then use the @@Descr as the key to update the IDs. Also don’t put any segment separators in the import file, it will break it!
+15Hi
I came across related articlet https://www.augforums.com/forums/everything-else/change-warehouse-location-id-via-an-import/
Could you please check?
Also attaching the import scenario
+6The key is to make sure the description field is unique. You may need your current import scenario to edit descriptions first, then use the @@Descr as the key to update the IDs. Also don’t put any segment separators in the import file, it will break it!
The key is to make sure the description field is unique. You may need your current import scenario to edit descriptions first, then use the @@Descr as the key to update the IDs. Also don’t put any segment separators in the import file, it will break it!
Thanks Bryan - I’ve tried this scenario but seems to still just create a new location rather than updating the existing one. See anything off with my scenario below?
OK - looks like the 4th row down needs to be:
Locations → Location Table @@Descr =[location.Descr]
It is working now - thanks both.
+6The key is to make sure the description field is unique. You may need your current import scenario to edit descriptions first, then use the @@Descr as the key to update the IDs. Also don’t put any segment separators in the import file, it will break it!
Thanks Bryan - I’ve tried this scenario but seems to still just create a new location rather than updating the existing one. See anything off with my scenario below?
Sorry about that, I forgot I was messing with the Import the other day. The Field should be =[location.Descr].
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
