Skip to main content
Avalara Help Center

Install and Configure Avalara AvaTax for Microsoft Dynamics 365 for Retail

After you activate AvaTax and set up your company profile, install and configure AvaTax for your accounting software. During configuration, customize your setup to fit your unique business needs for things like:

  • Tax calculation settings for various tax types
  • Exemption settings if you have exempt customers
  • Product taxability settings

Update these settings when your business needs change.

In order to use AvaTax for Microsoft Dynamics 365 for Retail, install Microsoft Dynamics 365 for Finance and Operations, Enterprise edition and set up all locations codes in AvaTax.

Configure the retail module

  1. Go to Modules > Avalara AvaTax > Setup > Configuration Setting > Retail.
  2. For the Sales tax group, select AVATAX in order to enable AvaTax sales tax calculation.
  3. Click Initialize to format the store data and create the required retail jobs. Choose to schedule jobs in recurring batches or start processing now. Click OK.
    Initialize.jpg
  4. Click Location to store mapping to assign location codes to their associated Store number, and then click Save.
  5. Click Fetch Tax Rates to store AvaTax rates in the database. Choose to schedule jobs in recurring batches or start processing now. Click OK, and then click Save.
    FetchTaxRates.jpg

Configure the database

Create AvaTax tables in the Retail Channel database.

  1. Run the SQL procedure AVA_d365ops_Retail_ChannelDBS.sql. Repeat this step in each channel and offline database.
  2. Go to Retail Channel Schema > AX 7 > Import in retail distribution schedule.
  3. Import AVA_RetailTableDistrubtion.xml and click Generate queries.
  4. Go to Distribution schedule > AVA-0001, and then click Run Now. Make sure the status of all jobs is Applied.

Configure the retail server

Save .dll files for AvaTax on your server.

  1. Go to your Retail server iisInstallation directory and place the following libraries (found in your release package) in there:
    • Avalara.AvaTax.Adapter.dll
    • Avalara.AvaTax.Adapter.dll.config
    • Avalara.Ax7.CRT.dll
    • Avalara.Ax7.CRT.Extension.dll
    • Avalara.Ax7.Local.dll
  2. Open CommerceRuntime.config and place <add source="assembly" value="Avalara.AX7.Local.Extension" /> just after the <composition> node.
  3. Save the Config file.

 Configure offline MPOS

Save.dll files for AvaTax in your MPOS directory.

  1. Go to your MPOS Installation directory and place the following libraries (found in your release package) in there:
    • Avalara.AvaTax.Adapter.dll
    • Avalara.AvaTax.Adapter.dll.config
    • Avalara.Ax7.CRT.dll
    • Avalara.Ax7.Local.Extension.dll
    • Avalara.Ax7.Local.dll
  2. Open CommerceRuntime.MPOSOffline.config and place <add source="assembly" value="Avalara.AX7.CRT.Extension" /> just after the <composition> node.
  3. Save the Config file.

Reset IIS

Reset all the data in the cache of IIS in order for the AvaTax component to function correctly.

  1. Open Command Prompt with elevated access.
  2. Type iisreset, and then press Enter
  3. Once it finishes, close the command prompt.

Set up Retail stores

 Assign specific stores to use AvaTax.

  1. Go to Area Page > Your Company > Retail and Commerce.
  2. Click Retail stores and select All retail stores.
  3. For each store, click Edit and set the Sales Tax Group as AVATAX. AvaTax is now the default sales tax calculation method for that store. Click Save.

Match warehouse addresses to AvaTax location addresses

If you have multiple addresses for a single store, it's important for accurate tax calculation that the warehouse address matches the location address in AvaTax.

  1. Go to Retail and Commerce > Channels > Retail Stores > All Retail Stores.
  2. To view store details, right-click the Warehouse and click View Details.
  3. Make sure the warehouse address matches the address in AvaTax to ensure that AvaTax can exchange data with Microsoft Dynamics 365 for Retail for an accurate tax calculation based on this address. Click Save

Move data to channel and offline store databases

Run batch scheduler scripts to move tax calculation data to channel and offline store databases.

  1.  Go to Retail and Commerce > Retail IT > Distribution Schedule.
  2. Filter for AVA-001 and click Run Now. Click Yes on the message asking, "Do you want to run job AVA-001."
  3. This script takes about 2-3 minutes to run. Once it completes, you're ready to use AvaTax for Microsoft Dynamics 365 for Retail.