Skip to main content
Avalara Help Center

Validate a batch of addresses in Microsoft Dynamics GP

This article applies to:Connector for Microsoft Dynamics GP

AvaTax address validation is a feature that verifies, corrects, and formats addresses according to the USPS database. At this time, AvaTax only validates addresses in the United States and Canada. Validating addresses may incur additional usage fees.

To validate addresses, make sure address validation options are enabled when you configure Connector for Microsoft Dynamics GP

Validate a batch of addresses

To validate many addresses at once:

  1. In Microsoft Dynamics GP, go to Microsoft Dynamics GP > Tools > Utilities > Avalara AvaTax > Update, and then click Address Validation Batch Utility.
  2. In the Select Options dialog box, next to Content Type, select the type of address you want to run the utility on.
  3. Next to Customer ID from and Customer ID to, click the Search icon.
  4. In the Customers and Prospects dialog box, select the range of addresses you want to validate.
  5. In the Select Options dialog box, next to Country, select the country in which you'd like to validate addresses you selected. If you select No Country Name, AvaTax validates addresses for which no country has been assigned to the record.
  6. Next to State From and State To:
    • To validate all addresses in the country you selected, don't select any states.
    • To validate only addresses in certain states, select a range of states.
    • To narrow your validation to a single state, set both fields to that state.
  7. Click Validate.
  8. In the report screen, select Valid/Validated Addresses, and then click Mark All.
  9. Click Accept.
  10. In the [Number] Address Validated and Accepted message, click OK.
  11. To see and update addresses that didn't validate, select Not Validated Addresses, and then click an address to open the record for editing.