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.

To use AvaTax Update for Microsoft Dynamics 365 for Retail:

Configure the retail module

  1. Go to Modules > Avalara AvaTax > Setup > Configuration Setting > Retail.
  2. From Sales tax group, select AVATAX. AvaTax Update sales tax calculation is enabled.
  3. To format the store data and create the required retail jobs:
    1. Click Initialize.
    2. If you want to schedule jobs in recurring batches instead of immediately beginning processes, set Batch processing to Yes.
    3. Click OK.
  4. Click Location to store mapping, assign location codes to their associated Store number, and then click Save.
  5. To store AvaTax Update rates in the database:
    1. Click Fetch Tax Rates  
    2. If you want to schedule jobs in recurring batches instead of immediately beginning processes, set Batch processing to Yes.
    3. Click OK, and then click Save.

Configure the database

To create AvaTax Update tables in the Retail Channel database:

  1. Run the SQL procedure AVA_d365ops_Retail_ChannelDBS.sql for 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.
  5. Make sure the status of all jobs is Applied.

Configure the retail server

To save .dll files for AvaTax Update on the retail server:

  1. Place the following libraries, found in the release package, in the retail server iisInstallation directory:
    • 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.CRT.Extension" /> immediately after the <composition> node.
  3. Save the config file.

 Configure offline MPOS

To save.dll files for AvaTax Update in the MPOS directory:

  1. Place the following libraries, found in the release package, in the retail server MPOS directory:
    • 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.Local.Extension" /> immediately after the <composition> node.
  3. Save the config file.

Reset IIS

Reset all the data in the cache of IIS so AvaTax Update functions correctly.

To reset the data:

  1. Open the command prompt with elevated access.
  2. Type iisreset, and then press Enter

Set up retail stores

 Assign specific stores to use AvaTax Update.

  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, set the Sales tax group as AVATAX, and then click Save. AvaTax Update is now the default sales tax calculation method for that store.

Match warehouse addresses to AvaTax Update location addresses

Each warehouse address must match the location address in AvaTax Update to make sure AvaTax Update can exchange data with Microsoft Dynamics 365 for Retail for an accurate tax calculation based on this address.

  1. Go to Retail and Commerce > Channels > Retail Stores > All Retail Stores.
  2. Right-click each warehouse and click View Details.
  3. Make sure the addresses match, and then click Save.

Move data to channel and offline store databases

Run a script to move tax calculation data to channel and offline store databases. Once it completes, you're ready to use AvaTax Update for Microsoft Dynamics 365 for Retail.

  1.  Go to Retail and Commerce > Retail IT > Distribution Schedule.
  2. Filter for AVA-001, click Run Now, and then, in response to the "Do you want to run job AVA-001?" message, click Yes. The script takes about 2-3 minutes to run.