Skip to main content
Avalara Help Center

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.