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. We recommend you schedule a weekly job.
    3. Click OK, and then click Save.

Configure the offline database

To create AvaTax Update 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 Update 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 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 store addresses to AvaTax Update location addresses

Each store 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 Organization administration > Organizations > Operating Units.
  2. Make sure the primary address of each store matches the address for that store in AvaTax Update.
  3. Update the incorrect entry if addresses don't match:
    • If the error is in the Microsoft Dynamics 365 for Retail address entry, update it on the open Microsoft Dynamics 365 for Retail screen.
    • If the error is in the AvaTax Update address, edit the company in AvaTax Update 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 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.