Why are we seeing this error in Microsoft Dynamics GP: "A get change operation on table failed accessing SQL..."?
Overview
We have recently installed AvaTax on terminal servers and local machines. We now receive the following error when trying to calculate tax:
"A get/change operation on table failed accessing SQL data" "Number of results columns doesn't match table definition"
Environment
Microsoft Dynamics GP
Resolution
- This will happen if there are mixed versions of the AvaTax integration across your server and local machines.
- To resolve simply ensure all machines and/or your terminal server are on the same version of the AvaTax integration.