Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.
The import works if I only import inventory ID’s that are in Acumatica.
Best answer by pwills69
View original
+12
Hi
can you disable both the check box and try once
Still the same issue
+12
is the error saying record cannot be processed because of next records?
can you give me one try by disabling below mapping
The import shows that it worked but when I look at the Sales Order it only created one line item, the last item on the list.
+12
Hi
Thank you but I don’t see any differences from my import.
+12
Hi
I tested above import scenario and able to import the sales order with multiple lines.
take the reference file in the import scenario aboutthe excel provider and compare the mapping.
Thanks
if you still found an issue then share me the list and import in xml format
Attached are my files. I’m able to import sales orders, the issue is when one of the inventory items is not setup in my Acumatica system.
Hi
Acumatica support was able to help and get it so that only the order that had the bad inventory items failed, but the rest of the orders would import. This helped because we could then filter the import scenario results on the failed orders and inactivate the bad inventory items and the orders would then import. Not what we were looking for but a suitable workaround.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
