By using this website, you agree to our Terms of Use (click here)
We often need to upload orders from an Excel file due to many SKUs. We use the "Load Records From File" button. Sometimes there is a mismatch with the SKU (Inventory ID) which is not formatted exactly how it's in our system. When there is an error, the entire upload errors out and there is no way of knowing which SKU caused the problem. Sometime we must resort to doing a VLOOKUP against our SKU database in Excel to identify the culprit.
Is there some solution to this in Acumatica that I have overlooked?
I think you'd need to use an Import Scenario if you want to see where the error occurred.
You could also build some pre-validation in the Excel file using an OData connection.
Online Members