Skip to main content
covid-19 thumb.png
Learn more about federal and state actions related to the COVID-19 outbreak with our guide to coronavirus tax relief.
Avalara Help Center

Install and Configure Avalara Connector for Microsoft Dynamics 365 Commerce

  1. Last updated
  2. Save as PDF
This article applies to:Connector for Microsoft Dynamics 365 Commerce

After you activate AvaTax and set up your company profile, install and configure AvaTax for your business application. 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 for Microsoft Dynamics 365 Commerce:

Configure the retail module

  1. On the Modules menu, select Avalara AvaTax > Setup > Configuration Setting.
  2. On the Configuration page, select Retail.
  3. In the Setup options for Retail pane, select Tax Area Code.
  4. On the Sales tax group menu, select AVATAX. AvaTax sales tax calculation is enabled. ​​​​​​
  5. To format the store data and create the required retail jobs, select Fetch tax rate and Item Tax code, and then do one of the following:
    • To immediately start the process, select Initialize.
    • To schedule jobs in recurring batches, set Batch processing to Yes.
  6. Select OK.
  7. Select Location to store mapping, assign location codes to their associated Store number, and then click Save.
  8. To store AvaTax rates in the database:
    1. Click Fetch Tax Rates  
    2. To schedule jobs in recurring batches instead of immediately beginning processes, set Batch processing to Yes. We recommend you schedule a weekly job.
    3. Click OK, and then click Save.

Configure the offline database

To create AvaTax tables in the Retail Channel database:

  1. Run the SQL procedure AvaTax_Retail.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 offline MPOS

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

  1. Place the following libraries, found in the release package, in the retail server MPOS directory:
    • AvaTax.RestClient.net45.dll
    • AvaTax.RestClient.net45.Wrapper.dll
    • AvaTax.RestClient.net45.Wrapper.dll.config
    • Avalara.Ax7.CRT.dll
    • Avalara.Ax7.CRT.Extension.dll
    • Avalara.Ax7.Local.dll
    • Avalara.Ax7.Local.Extension.dll
    • Newtonsoft.JSON.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 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.

  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 is now the default sales tax calculation method for that store.

Match store addresses to AvaTax location addresses

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

  1. Go to Organization administration > Organizations > Operating Units.
  2. Make sure the primary address of each store matches the address for that store in AvaTax.
  3. Update the incorrect entry if addresses don't match:
    • If the error is in the Microsoft Dynamics 365 Commerce address entry, update it on the open Microsoft Dynamics 365 Commerce screen.
    • If the error is in the AvaTax address, edit the company in AvaTax to update the address.

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 Connector for Microsoft Dynamics 365 Commerce.

  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.