Why am I getting errors on my imports with what appears to be a blank row?
Overview
Imports are generating an error file with the following error messages and the row appears to be blank:
Invalid Process Code - expecting either 3 (Import new transactions with tax calc) or 4 (Import new or adjusted transactions with tax calc) or 0 (Void transaction)
DocCode is required.
Invalid Document Type - expecting 1 (SalesInvoice), 3 (PurchaseInvoice) or 5 (ReturnInvoice)
Amount format is invalid
Environment
Avalara AvaTax
Resolution
- The original import had blank lines that were "active" in the workbook, so the system attempted to import them, but since there was no data errors occurred.
- The line included no data, so no data was missed in import.
- You do not need to take any action to correct this error, since the row(s) were blank.
- If you want to see a "Complete" status on the file you are importing simply delete multiple rows under the last row containing data.