...
Stop all EngageIP Windows Services
Login to the EngageIP database and run following query to find all of the existing branded owners where BillSoft is configured
Code Block SELECT owner.Name FROM TaxVendor tv INNER JOIN Owner ON Owner.ID = tv.OwnerID INNER JOIN TaxVendorType tvt ON tvt.ID = tv.TaxVendorTypeID WHERE tvt.Name = 'BillSoft'
Note the owner names from the query result above
Run the following query to update the tax vendor configuration
Code Block UPDATE TaxVendor SET Name = 'AvaTax Vendor', TaxVendorTypeID = (SELECT TOP 1 ID FROM TaxVendorType WHERE Name = 'AvaTax'), ChargeScript = 'return true;', InvoiceChargeScript = 'return true;' FROM TaxVendor tv INNER JOIN TaxVendorType tvt ON tvt.ID = tv.TaxVendorTypeID WHERE tvt.Name = 'BillSoft'
In the database delete the Tax Exempt Levels which are unsupported by AvaTax cloud ('Unincorporated', 'Other','All','County_Local','State_County_Local')
Code Block IF EXISTS(SELECT * FROM TaxExemptLevel WHERE Name IN ('Unincorporated', 'Other','All','County_Local','State_County_Local')) DELETE FROM TaxExemptLevel WHERE Name IN ('Unincorporated', 'Other','All','County_Local','State_County_Local')
In the AdminPortal access theĀ Setup tab and load theĀ Actions page. Delete the action script which the Billsoft configuration used to add the jurisdiction code to addresses on contacts (this script may be named 'EZtax pcode' and will have an event code value of 'ContactPointAddress.Create,ContactPointAddress.Update')
Load the Setup tab for each branded owner that was configured to use Billsoft and populate the AvaTax Vendor settings (provided by Avalara)
Perform an iisreset on the EngageIP server and restart EngageIP Windows Services
Test to verify jurisdiction code updates and taxation is functioning
...