Skip to main content
Avalara Help Center

How do I resolve error, "LineNo is required. This value must be specified" when importing my transactions?

Overview

Error Message when importing transaction:  LineNo is required. This value must be specified.

Environment

AvaTax Admin Console
Import Transactions

Resolution

  • To resolve the following error message: 
    LineNo is required. This value must be specified.

  • Go to Tools:

    • View Imported File Status

      • Click on the (blue hyperlink) Error of the file you were importing

  • Once the Excel spreadsheet opens, then scroll all the way to the right to the the (BZ = Error) column you will find the error message:  "LineNo is required. This value must be specified."

  • You will then need to scroll back to the left and find (H = LineNo.) column and if you find that nothing is entered there, then that is triggering the error. 
  • On the file you are importing > enter a  line number each line of transactions> Save the file
  • Re-import your transactions.  

  • Please click on the link below if you need assistance with importing your transactions.  

Add or Import Transaction