Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Power Hely]

We are using Avalara AvaTax to do our sales tax calculations. One of the ways that exemptions can be calculated in Avalara is through the use of Entity/use codes, accessible through the GUI under Cards->Sales->Addresses, Additional->AvaTax Entity/Use Code.

Does anyone know the table these are stored in? I need to add an Entity/Use code to 617 entries, and I’d rather not have to do so through the GUI…

——————————
Power Hely
VP of Operations
Hely & Weber
Santa Paula CA
——————————

[Audrey Forrest]

Power, 
The entity/use codes are unique to the Avalara plug-in and are stored in the custom table AVAENTITYUSECODE.

——————————
Audrey Forrest
Senior Accountant and Business Analyst
GP 2015 R2, D365 CRM V9
CRMUG Chapter Leader – Seattle
——————————
——————————————-

[Carlos Cockerham]

The table that you want to import the exemption info is AVA_CUST_ENTITY_CLASS.  This table has the customer ID, Address Code and the Entity ID.  The AVAENTITYUSECODE table only has the entiy code and description.

Hope this helps.

——————————
Carlos Cockerham
IT Manager
Southland Printing Company
Shreveport LA
——————————
——————————————-