Skip to main content
Avalara Help Center

Install and Configure Avalara AvaTax for Microsoft Dynamics NAV

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.

If you've previously installed the integration, learn how to upgrade to the latest version.

Prior to installing AvaTax Update for Microsoft Dynamics NAV, your organization’s Microsoft Dynamics NAV Solution Developer should review your source code to resolve the following:

  • If there are add-on applications, third-party products, or custom-written enhancements within the Microsoft Dynamics NAV application, it's imperative that your organization’s Microsoft Dynamics NAV Solution Provider properly merges the AvaTax Update code with any other add-ons or custom-written enhancements.
  • If you receive an error when you import the avalaraX.fob file, ask your Microsoft Dynamics NAV Solution Developer to merge the code changes, rather than importing them.
  • If your Implementation Partner or Development Team customized your database, don't import the .FOB files. Ask your Microsoft Dynamics NAV Solution Developer to merge the code changes.

Download AvaTax Update for your accounting software

To connect your accounting software to AvaTax, download your integration software. 

  1. In AvaTax, on the Home tab, click Get Started.
  2. In the Download and Install Your Integration Software section, click Download Software
  3. In the Download Your AvaTax Connector Software window, click the arrow next to the name of your software, and then download the latest version of your integration. If the file isn't available for download, clear your browser's cache, and log back into AvaTax.
  4. Save the .zip file somewhere on your computer that's easy to find.
  5. Right-click the .zip file and extract the installation folder or file (.exe, .pdf, or .msi). 

Install AvaTax Update for your accounting software

We recommend you contact Avalara Professional Services before you install and configure AvaTax for your accounting software for help with implementation.

There are two distinct elements to the AvaTax Update for Microsoft Dynamics NAV: the adapter and the connector objects. After you download AvaTax Update for Microsoft Dynamics NAV, install and register the adapter on the server hosting the Microsoft Dynamics NAV application and then install and register the adapter on each workstation where the Microsoft Dynamics NAV client is installed.

Run the AvaTax setup wizard

Once you have downloaded the AvaTax Update ZIP file from AvaTax Update, run the AvaTax Update setup wizard as an Administrator on every Microsoft Dynamics NAV application server.

  1. Run Avalara AvaTax™ for Microsoft Dynamics NAV.exe to install AvaTax Update for Microsoft Dynamics NAV.
  2. On the Welcome to the InstallShield Wizard screen, click Next.
  3. On the Ready to Install the Program screen, click Next. Wait for the installation to complete while the Install Wizard copies Avalara *.fob integration object files to your local machine and registers the adapter.
  4. When the installation is complete, click Finish to exit the wizard.

Import the .fob files

If you have a non-customized Microsoft Dynamics NAV database, import the Avalara.fob and AvalaraX.fob files to finish installing AvaTax Update for Microsoft Dynamics NAV.

  • The Avalara .FOB files are compatible only with a non-customized CRONUS database for {{CRONUS database for {{DNAV}}.
  • If you have a customized CRONUS database, ask your {{CRONUS database, ask your {{DNAV}} Solution Developer to merge the code changes with existing objects.
  • Always use Change to change the existing license file.
  • Don't click Import because it removes the current .FLF file from the Microsoft Dynamics NAV folder.

To import the .fob files:

  1. Launch Microsoft Dynamics NAV Development Environment.
  2. In the Tools menu, click License Information to change the License File to the developer. You must have a license that grants you access to the Object Designer.
  3. In the Tools menu, click Object Designer.
    NAV-ObjectDesigner.png
  4. In the File menu, click Import.
  5. In the Import Objects window, locate the Avalara.fob  and AvalaraX.fob files. If you have pre-existing copies of the file, click Replace All.
    • For 32-bit Windows, browse to C:\Program Files\Avalara\AvaTax Connect Adapter\Bin.
    • For 64-bit Windows, browse to C:\Program Files (x86)\Avalara\AvaTax Connect Adapter\Bin.
  6. Click the Avalara.fob file and then click Open.
  7. The Avalara.fob file creates and modifies various objects. You're prompted with a warning, informing you that there are objects in the database with conflicting versions. Click OK to open the Import Worksheet to proceed with the import.

    NAV-YestoImport.png
  8. In the Import Worksheet window, click Replace All. To avoid MenuSuite conflicts, select specific unused MenuSuite IDs from the worksheet and import objects. Click OK.

  9. Click the AvalaraX.fob file and then click Open. Repeat steps mention in #6 to #8. 
  10. When the import is complete, recompile all native objects (all objects that Avalara.fob and AvalaraX.fob have replaced).

Essential Configuration

The more you personalize the configuration of Microsoft Dynamics NAV, the better your experience may be. It may also help your tax calculations be more correct. While some of the procedures on this page are optional, the procedures in this section are essential.

Configure AvaTax Update with the Setup Assistant

When you install AvaTax Update for Microsoft Dynamics NAV, the AvaTax Update Setup Assistant guides you through the configuration settings required to calculate tax.

  1. To confirm your account credentials:
    1. Next to Enter your Account Credentials and Company Code, click the Assist button SetupAssistant-AssistButton.png. The Avalara Account Credentials page opens,
    2. Fill in the following, and then click Test Connection to confirm you've accurately entered your account credentials :
      Field Action
      • Account Number
      • License Key
      Use the information provided in an email from Avalara (sent to the email account you used to activate your account). It must match what's saved in AvaTax Update.
      Web Service Select Development if you have an AvaTax Update development account or Production if you have an AvaTax Update production account.
  2. To map your tax area code:
    1. Next to Map General Ledger Accounts(s) to AvaTax Tax Area Code, click the Assist button SetupAssistant-AssistButton.png. The Tax Area Code page opens.
    2. In the Map Tax Area Code section, from the Tax Area Code list, select AVATAX, and then click Close.    
  3. To manage address validation:
    1. Next to Enable Address Validation for USA and Canada, click the Assist button SetupAssistant-AssistButton.png. The Validate Address page opens.
    2. Optional: If you disable address validation, AvaTax Update uses the customer's ship-to address to calculate the correct sales tax. Sales tax might be calculated incorrectly if this option is disabled.
    3. To enable address validation for a country, under Country Codes, select the country name, and then click Map for Address Validation. Countries for which address validation is enabled are listed under Mapped Country Code.
    4. To disable or remove a country from address validation, select the country Name, click Remove from Address Validation, and then click Close
  4. To test your AvaTax Update connection, next to Test Calculating Tax, click the Assist button SetupAssistant-AssistButton.png,  and then follow one of these steps, as appropriate:
    • If you see a message that says "Congratulations! You are connected to AvaTax Update. You may still need to complete additional configuration tasks," click Close.
    • If you see any other message, follow steps 1-4 again until you receive a success message.
  5. Click Click here to launch the AvaTax Tax Profile Assistant to launch and configure AvaTax Update for Microsoft Dynamics NAV.

Configure AvaTax Update for your accounting software

Many configuration options in Microsoft Dynamics NAV are available in the Edit - AvaTax Configuration dialog box.

To open the Configuration dialog box and configure AvaTax Update for Microsoft Dynamics NAV:

  1. In Microsoft Dynamics NAV, in the left pane, go to Home > Departments > AvaTax > Setup.
  2. In the right pane, under Administration, click AvaTax Configuration. The Edit - AvaTax Configuration dialog box opens.
  3. On the Home tab, in the Process group, click Edit Settings.

    NAV2013_ConfigEditSettings1.png

  4. To modify your AvaTax Update account credentials in Microsoft Dynamics NAV, in the Account Credentials section, enter the correct information in the following fields:
    Field Action
    • Account Number
    • End User License Key
    Use the information provided in an email from Avalara (sent to the email account you used to activate your account). It must match what's saved in AvaTax Update.
    URL Select Development if you have an AvaTax Update development account or Production if you have an AvaTax Update production account.
    Company ID Enter your AvaTax Update company code
  5. On the Home tab, in the Process group, click Verify Credentials.
  6. Complete or modify fields in the remaining sections, using the following information, to configure AvaTax Update for Microsoft Dynamics NAV as appropriate for your business:
    • The General section:
      Field Description
      Display All Warning Messages Optional: If not selected, you see only error messages.
      Tax Mapping Code Select Tax Group Code, the preferred way to map tax codes. If you need to use Tax Table instead, email Avalara Support.
      User Defined 1 and 2 Optional: Select the type of data you want to send to AvaTax.
      Enable Entity Use Code Optional: Enable to map entity/use codes for your customer addresses to flag them as exempt from sales tax.
      Send Item Account to AvaTax Optional: Select to send the associated general ledger account number to AvaTax Update for reporting purposes. This data displays in the Revenue Account field in the line item.
      Return Address

      Select the address you want to use for sales tax calculation of return orders and credit memos.

      • Shipping: The most common selection; uses the ship-to address
      • Customer: Uses the bill-to address
      • Invoicing: Uses the location code address
      Enable Service Module Integration Optional: Select this to use AvaTax Update with service orders in Microsoft Dynamics NAV.
      Update Default Data Select Country Code.
      Enable Logging Optional: This function is primarily used for troubleshooting issues. If you choose to enable logging, all success, warning, and error messages are included in the log. Only enable logging if you've been instructed to do so by Avalara Support, because it can significantly slow down your service.
      Extensive Logging Optional: Select to automatically log AvaTax Update activities and save the details in a local log file.

     

    • The Tax Calculation section:
      If you want to change any of these settings that we recommend leaving at the default setting, contact Avalara Support
      Field Description
      Disable Tax Calculation Optional: If you choose to disable tax calculation, your accounting software no longer uses AvaTax Update to calculate tax on transactions.
      Always Check Addresses Before Calculating Tax Optional: Select to validate addresses before AvaTax Update for Microsoft Dynamics NAV calculates tax. Don't enable this unless you absolutely need to; it may cause extra charges.
      Show AvaTax Tax Details Before Sales Statistics Window Optional: Select to have AvaTax Update for Microsoft Dynamics NAV show sales tax details before it shows sales statistics.
      Use UPC as Item Code Optional: Select to send a UPC instead of an item code to AvaTax. Using this feature may trigger additional fees. Talk to your Customer Account Manager (CAM) for more information. For more information, learn how to map items to UPC.
      Enable COGS (cost of goods sold) Leave at default setting. If you enable this option, you can choose the Tax Group Code. If the selected Tax Group Code is the same as the line tax group code of the transaction, the tax is calculated based on the unit cost (instead of the unit price) specified on the item card. If the selected Tax Group Code is not the same as the line tax group code of the transaction, the tax is calculated based on the unit price specified on the item card.
      Tax Group Code Leave at default setting. You can select a Tax Group Code only if Enable COGS option is enabled.
      Enable Tax Amount Adjustment Leave at default setting unless you want to add a SALESTAXADJUST line item for sales credit memos and service credit memos.
      Exempt Processing

      Leave at default setting. Available options are:

      • Sell-to Customer: Default setting; exemption processing is based on the sell-to customer exemption details.
      • Bill-to Customer: Exemption processing is based on the bill-to customer exemption details.
      • Transaction Level: Exemption processing is based at the transaction level exemption details. (As of now, this option is not applicable and reserved for future use.)
      Tax Area Code Select AVATAX to use AvaTax Update to calculate sales tax. If you don't select this, AvaTax Update won't calculate sales tax.
      At Order Release

      Leave at default setting. Available options are:

      • Quantity (Order): Default setting; order quantity is considered for calculating sales tax.
      • Quantity (Ship): Ship-to quantity is considered for calculating sales tax.
      • Quantity (Invoice): Invoice quantity is considered for calculating sales tax.
      At F7 Statistics Select an option to display statistics about it when you press F7.
      Initiate AvaTax based on Tax Area Code Select to enable AvaTax Update as the tax-calculation method if an AvaTax Update tax area code appears on a sales or billing transaction.
      • Map US Country Code
      • Map CAN Country Code

      Optional: Disabled by default. To enable the map country code, ensure the Initiate AvaTax based on Tax Area Code option is disabled, and then select the map country code type to enable. Map the relevant country codes. Based on the country code, perform Statistics and post to AvaTax Update.

      If enabled, the country code overrides Tax Area Code (in an invoice) and Tax Group Code (on item lines of a transaction). 

      Enable Asynchronous AvaTax Posting 

      Optional: If disabled, when transactions are posted, AvaTax Update calculates sales tax, and then posts the transaction to both Microsoft Dynamics NAV and AvaTax Update. After the posting, the Doc Status of this transaction shows as Committed in AvaTax Update. 

      If enabled, when transactions are posted, AvaTax Update calculates sales tax, and then posts the transaction to Microsoft Dynamics NAV only. The Doc Status of this transaction shows as Uncommitted  in AvaTax Update. To post the transaction in AvaTax Update, use the Asynchronous Posting utility. After you run this utility, the Doc Status of this transaction shows as Committed in AvaTax Update.

      Country Codes Leave at default setting.

     

    • The Address ValidationHoverTT.png section:
      Field Description
      Disable Address Validation Optional: If you disable address validation, AvaTax Update uses the customer's ship-to address to calculate the correct sales tax. Sales tax might be calculated incorrectly if this option is disabled.
      Return Results in Uppercase Optional: Select to save all address validation results in uppercase format.
      Abort Batch Posting with Errors Optional: If enabled, the Batch Address Validation Utility stops processing addresses if it encounters an error.
      Batch Processing Options Select one of these options:
      • During Batch Address Validation, continue processing regardless of errors: The Batch Address Validation Utility continues to process addresses even after it encounters an error.
      • Scan, Accept and Report Validated Address during Batch Address Validation manually: Select addresses to validate in batches.
      Country Codes Optional: Select a country name on the left, and then, under Country Codes, click Map For Address Validation to make AvaTax Update validate addresses in that country. (AvaTax Update only validates addresses in the United States and Canada.)
      Mapped Country Codes Optional: To stop validating addresses in a country, select it, and then click Remove from Address Validation.

Optional Configuration

Use the procedures in this section for further customization and control.

Add tax jurisdiction codes

  1. In Microsoft Dynamics NAV, in the left pane, go to Home > Departments > Financial Management > Setup.
  2. In the right pane, under Sales Tax, click Tax Jurisdictions. The Tax Jurisdictions pane opens.
  3. Select a jurisdiction, and then click Edit List. The Edit - Tax Jurisdictions dialog box opens.
  4. Next to a jurisdiction, select a chart of accounts to which to apply the jurisdiction, and then click OK.

Add tax details

  1. In Microsoft Dynamics NAV, in the left pane, go to Home > Departments > Financial Management > Setup.
  2. In the right pane, under Sales Tax, click Tax Details. The Tax Details pane opens.
  3. Under Tax Type, select Sales and Use Tax for every tax jurisdiction, and then click OK.

Configure resource records

  1. In Microsoft Dynamics NAV, in the left pane, go to Departments > Warehouse > Assembly.
  2. In the right pane, under Lists, click Resources. The Resources pane opens.
  3. Select a resource. The Edit - Resource Card dialog box opens.
  4. In the Invoicing section, next to Tax Group Code, select a tax group code for the resource, and then click OK.

Configure the General Ledger Account

  1. In Microsoft Dynamics NAV, in the left pane, go to Departments > Financial Management > General Ledger.
  2. In the right pane, under Lists, click Chart of Accounts. The Chart of Accounts pane opens.
  3. Double-click an account. The Edit - G/L Account Card dialog box opens.
  4. From the Tax Group Code list, select a tax group code for the account, and then click OK.

Configure item charges

  1. In Microsoft Dynamics NAV, in the left pane, go to Departments > Financial Management > Inventory > Setup.
  2. In the right pane, under Administration, click Item Charges. The Edit - Item Charges dialog box opens.
  3. Select an item, under Tax Group Code select a tax group code for it, and then click OK.
  • Was this article helpful?