From Fishbowl
Jump to: navigation, search

Icon.Avalara.png The Avalara module, located in the Integrations group, is an add-on module that can be installed from the Small.Plugin.png Plugin module. After installing the plugin, a new module is added that integrates with Avalara AvaTax. Avalara takes the hassle out of managing the many complex taxing laws and automatically returns a total tax amount based on the product, price, and location.


Integration Agreement

By integrating with Avalara, all tax calculations will be run through Avalara at the time of item fulfillment. An Avalara Order tax rate will be created and set as your default tax rate. In using this integration please be aware of the following processes for orders using the Avalara Order tax rate:

  • Right-click and fulfilling line items must be done prior to shipping or receiving additional items.
  • Avalara taxes will not be calculated for any orders fulfilled through the Fishbowl API.
  • Any errors in getting taxes during receipt of credit returns or drop ship items will need to be handled manually.
  • Calculating tax estimates on a sales order are estimates and are not included in the total invoice until items are processed.
  • Discounts will not be applied to line items in Avalara

By agreeing to using this integration, Fishbowl will not be liable for any loss or damage relating to tax calculations.

The documentation on this page is for the most recent version of the Small.Avalara.png Avalara plugin. To get the most recent version, Update Fishbowl.


  1. In any Fishbowl Client, open the Small.Plugin.png Plugin module, located in the Integrations group.
  2. Select the Small.Avalara.png Avalara plugin and click Install Now.
  3. Completely close all Fishbowl Clients.
  4. Exit the Fishbowl Server by right-clicking the Fishbowl Server tray icon and selecting Exit.
  5. After re-opening the Fishbowl Server, the admin user can access the Small.Avalara.png Avalara module from any Fishbowl Client by opening the Integrations module group.
  6. To grant access to additional users, assign the Avalara-View access right to the appropriate groups in the Small.User Group.png User Group module


Avalara Connect.png

The Avalara plugin requires an AvaTax account number and license key. These can be obtained by logging in at http://admin-avatax.avalara.net. For more information, click here.

  1. Enter the Account Number and License Key into the Small.Avalara.png Avalara module.
  2. The Web Service URL will typically be https://avatax.avalara.net
  3. The other fields are Avalara options, such as the ability to mark transactions as Pending or Committed.
  4. Click the Connect button in the Small.Avalara.png Avalara module to verify that the connection is valid and then click Save.


  1. To get a tax estimate, click the Avalara Button.png Avalara button on the Sales Order module toolbar.
    Avalara Tax Estimate.png
    • If any changes are made to the order (modified quantity, partial shipment, address change, etc.), the estimated amount may vary from the actual amount calculated during shipping.
    • In some cases, local laws and other complexities may also result in the actual tax being different from the estimate.
    • The tax estimate is stored on the Details tab of the Small.Sales Order.png Sales Order module.
    • The Order Estimated Tax column can also be enabled on the Sales Order report.
      Estimated Tax on report.png
    • The order total will not include tax until the order has been shipped.
  2. Once an order has shipped, a line item will be added to the order with the actual tax amount.
    Avalara Actual Amount.png
    • Below is an example of the data that is stored in Avalara when an order ships.
      AvaTax details.png

Avalara will validate the Ship To address when requesting a tax estimate and when the order is shipped. An address can also be validated manually by clicking the Validate Address Icon Button.png Validate Address button above the Ship To address.

Release Notes

Released on 2/9/2017

  • Issue: Products with a number that is greater than 50 characters in length causes an error and doesn't display a clear error message.
  • Resolution: Error message from Avalara is now passed through to Fishbowl.
  • Issue: An error occurs when syncing with Avalara via the estimated tax button if the location group on the order does not have a default address in the company module.
  • Resolution: Estimated tax now displays a message informing the user that an address needs to be entered before estimated tax can be calculated.
  • Issue: Multiple shipments against a single sales order update Avalara with the latest transaction only when the "commit transactions" option is not enabled.
  • Resolution: Multi shipment orders now process each shipment correctly.

Released on 10/13/2016

  • Issue: Validating an address frequently fails when fields contain any additional data like an ATTENTION: listing.
  • Resolution: Rather than a direct fail, Fishbowl now attempts a secondary validate using City/State/Zip.

Released on 6/9/2016

  • Avalara AvaTax integration plugin allows for address validation and item based taxing