--> Skip to main content
Avalara Help Center

Validate Addresses

This article applies to:Avalara AvaTax for NetSuite

Quickly validate one address or many addressesHoverTT.png at once in order to ensure that the address is formatted correctly for AvaTax to calculate tax accurately. Validate a variety of addresses: your company's addresses, your customers' addresses, and your vendors' addresses.

At this time, AvaTax for NetSuite only validates addresses in the United States and Canada.

Validate one address

To quickly validate one address, follow these steps:

  1. In NetSuite, go to Avalara > Address Validation and click Quick Validate.
  2. On the Validate Address page, type part of the address and then click Validate.
  3. In the Address Validation was Successful message, click OK.
  4. On the Validate Address page, see the validated address.

Validate multiple addresses

To validate multiple addresses at the same time, follow these steps:

  1. In NetSuite, go to Avalara > Address Validation and click Validate Records.
  2. On the Address Validation Assistant page, follow these steps:
    1. In the Select Type pane, click the type of record to validate, and then at the lower right, click Next.
    2. In the Set Data Filter pane, select any of the following filters:
      • Type: Click Lead, Prospect, or Customer.
      • What type of customers?: Click Individual, Company, or Both.
      • Additional Filters
        • Customer name starts with: Type the first few characters of the customer name that you would like to search for.
        • Date created: Select a Start Date and End Date to filter a range of customer records.
        • Address Type: Click All, Default Billing, Default Shipping, or Default Billing & Shipping to filter a range of address types.
        • Only Active Records: Click to validate only records that are active in NetSuite.
    3. At the lower right, click Next, and in the Summary Information pane, next to Batch Name, type a name for the batch, and then at the lower right, click Next.
    4. On the Avalara menu, point to Address Validation, and then click View Batches.
    5. On the Address Validation Processes page, wait until under Progress you see 100%, and then at the right, click View Details.
    6. On the Address Validation Batch page under SUBLIST CRITERIA:
      • Click All to see all records in the batch. This is the default selection.
      • Click Validated - address not updated to see all records that AvaTax for NetSuite that were validated but not updated.
      • Click Not Validated to see any records that are not validated at all.
      • Click Validated - address updated to see all the records that AvaTax for NetSuite validated and saved from this batch.
      • Click Update Failed to see all records that AvaTax for NetSuite could not save from this batch.

View multiple addresses

Once you validate multiple addresses, you can go back into the details to update the validated records and export the batch details.

  1. In NetSuite, go to Avalara > Address Validation and click View Batches.
  2. On the Address Validation Processes page, to view batch details, click View Details.

    ViewBatch.png

  3. On the Address Validation Batch page:
    1. To update validated records, click Update Validated Records.
    2. To export the batch details, click Export CSV. Each exported CSV can support up to 1000 records.
       ExportCSV.png

Validate a customer's address

To validate a specific customer's address, follow these steps:

  1. On the NetSuite, go to Lists > Relationships, and click Customers.
  2. In the Customers pane, next to the customer whose address you want to validate, click Edit.
  3. In the Customer Card, click the Address tab, and in the Address pane, at the upper left, click Validate Address.
  4. Depending on what you see next, follow one of these steps:
    • If you see a message that shows a valid address and asks "Accept Validated Address?", click OK.
    • If you see any other message about the address, do this:
      1. In the Customer Card, in the Address pane, click the Edit icon.
      2. In the Address pane, type the correct address click Validate Address, and then at the upper left, click OK.

Validate a vendor's address

To validate a vendor's address, follow these steps:

  1. On the NetSuite, go to Lists > Relationships and click Vendors.
  2. In the Vendors pane, next to the vendor whose address you want to validate, click Edit.
    NetSuite2014_ValidateVendor1.png
  3. In the Vendor Card, click Address, click the address you want to validate from the list, and then click Validate Address.
    NetSuite2014_ValidateVendor2.png
  4. Depending on what you see next, follow one of these steps:
    • If you see a message that shows a valid address and asks "Accept Validated Address?", click OK.
      NetSuiteOneWorld2014_ValidateCustomer4.png
    • If you see any other message about the address, do this:
      1. In the Customer Card, in the Address pane, click the Edit icon.
        NetSuiteOneWorld2014_ValidateCustomer5.png
      2. In the Address pane, type the correct address click Validate Address, and then at the upper left, click OK.
        NetSuiteOneWorld2014_ValidateCustomer6.png

Validate a ship-to or bill-to address

To validate a ship-to address or a bill-to address, follow these steps:

  1. Create any of the transaction types.
  2. Select a customer.
  3. To add the address details, go to the bottom toolbar and click Address.
  4. To validate the bill-to address:
    1. From the Bill To Select drop-down menu, select the bill-to address. If the required address is not in the list, select Custom to add a new location. In the Address window, type the address and click Save.
    2. Click Validate Bill-To Address. The validated address is displayed for confirmation. Click Ok to accept the validated address. If the invoice bill-to address is incomplete, it is replaced with the validated bill-to address.
  5. To validate the ship-to address:
    1. From the Ship To Select drop-down menu, select the ship-to address. If the required address is not in the list, select Custom to add a new location. In the Address window, type the address and click Save.
    2. Click Validate Ship-To Address. The validated address is displayed for confirmation. Click OK to accept the validated address. If the invoice ship-to address is incomplete, then it is replaced with the validated ship-to address.
  6. At the lower left, click Save.