Skip to main content
covid-19 thumb.png
Learn more about federal and state actions related to the COVID-19 outbreak with our guide to coronavirus tax relief.
Avalara Help Center

Why are we seeing this error in Microsoft Dynamics GP: "A get change operation on table failed accessing SQL..."?

  1. Last updated
  2. Save as PDF

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"

 

GP error.PNG

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.