Question

Avalara Integration using Avalara APIs

  • 18 March 2024
  • 5 replies
  • 116 views

Userlevel 1

We have a customer who would like the ability to enter Sales Tax information for Customers and Locations in Acumatica, including an uploaded certificate image, and have that same information populated in AvaTax’s Certificate Management database without having to manually enter it. We’re aware of a library of APIs Avalara provides, and we’re wondering if anyone has developed scripts to accomplish this? The overarching goal is to enter the data once rather than having to add the info in both Avalara and Acumatica. The other driving factor is that customer exemption information entered in Avalara is not visible in Acumatica and requires users to log in to Avalara to determine if a customer already has an exemption certificate on file.


5 replies

Userlevel 6
Badge

Hi @rickh45, with 2024 R1, we have an integration to Avalara Exemption Certificate Management (ECM). You are able to:

  • create/update customer records from Acumatica to Avalara
    • can be done in bulk 
  • view available exemption certificates for a customer
    • includes certificate ID, state, reason for exemption, effective date, expiration date, certificate status, company code
    • you can also save or print the certificates
  • request for new certificates for a customer straight from Acumatica, using Avalara templates
  • update customer record in Avalara from Acumatica

let us know here if you were looking for additional functionality once you have had a chance to test the features.

Userlevel 1

Thank you very much, Omar. We’ll review this and confirm its applicability, but it certainly looks like it will address our client’s requests.

Userlevel 1

One more question for clarification: Will this integration include the ability to upload the exemption certificate image (pdf, jpg, etc.) from within Acumatica or will that need to be completed as a separate step in Avalara?

Userlevel 6
Badge

@rickh45 not with the current implementation. You can launch the request process from Acumatica (using the email templates created in Avalara first). However, if you already have the file (PDF/image) you’d have to upload that to the appropriate customer record on Avalara side. 

 

We have opted out of that feature with our initial launch. Mainly because we need to validate use cases from customers learn more about the behavior.

For instance, if you upload the certificate from Acumatica without having to login to Avalara, should Acumatica also store that file in the database? Now you will have the same file in Acumatica and in Avalara. Then it’s a case of knowing which one is the system of record for the certificates and which one can be trusted/is the latest one.

Another option could be that you upload the file through Acumatica and send it to Avalara for the customer record but not store that file in the Acumatica database. But that could have its own technical challenges and we’d need to figure out whether the file was successfully uploaded to Avalara as expected.

 

However, if you think this is something that will be a common ask from clients, please create an idea so we can have a thorough discussion and explore further.

Userlevel 1

Here is the link to vote for the functionality. Avalara Integration - Upload Exemption Certificates through Acumatica | Community

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved