You are receiving error related to AvaTax for GP and all other troubleshooting steps have failed. So, you would like to drop the AvaTax tables.
Microsoft Dynamics GP
- In some instances in AvaTax for GP, errors that can not be overcome require dropping our tables in SQL, to repair the connector.
- The primary data in the tables is historical data about existing transactions that is not displayed anywhere, for the majority of our clients.
- Note: Dropping the AvaTax tables should never be the first line of troubleshooting. This process should be used after all other attempts to fix the issue have failed
- NOTE: Only a qualified GP administrator / DBA should perform this operation. A backup of your entire database is highly recommended before proceeding. Any customizations made that mine data from our tables will be erased when this procedure is performed.
- To Drop AvaTax tables: