Sign in

Importing Locations

The following is an explanation of each of the fields you can provide when importing Locations.

Field Name Required? Maximum length Description Accepted Values Additional Information
Location Name* Yes 100 characters The name of this Location.   Key field.
Requires an exact match with the desired Location's name (for updating).
Active? No N/A Denotes if this Location is active or inactive. Active
Inactive
Requires an exact match with one of the accepted values.
All records are automatically set to Active when created; they cannot be created and set to inactive in the same import.
Description No 4000 characters The description of this Location.    
Location ID* Yes 40 characters The ID of this Location.   Key field.
Requires an exact match with the desired Location's name (for updating).
Parent Location Name No 100 characters The name of this Location's parent.   Requires an exact match with the desired Location's name.
Parent Location ID No 40 characters The ID of this Location's parent.   Requires an exact match with the desired Location's name.
The desired Location must be active in Bill.com, or created during the same import.

Please note: If you are specifying the Parent Location, both Parent Location Name and Parent Location ID MUST be provided.

 

 

Have more questions? Submit a request
Powered by Zendesk