Skip to main content
Avalara Help Center

Why am I seeing the message " One of the rows is missing required value for field: Location ID" when uploading data in Trustfile?

Overview

You want to know why the message " One of the rows is missing required value for field: Location ID" is showing up when uploading data in Trustfile.

Environment

Avalara Trustfile

Resolution

  • Please check your import file to make sure that all of the rows have a valid Location ID.
    If there are any special characters in the column for the Location ID, they are treated as zeros.
  • The Location ID is also known as the Certificate Number. Entering the Certificate Number 
    in the Location ID column/row will resolve this error.