Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. Native error:8114 when saving a batch

Error converting data type varchar to numeric. Native error:8114

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Alternative Solution:

1.  Prior to creating gift batch, open Regional Settings on the workstation
2.  Click Customise (or Additional Settings)
3.  Select Currency and change the symbol to either £, $ or
4.  Apply and OK Regional Settings

5.  Create batch, save and/or commit batch
4.  Exit batch and change Regional Settings on the workstation back to correct currency

The Regional Settings should not be changed while the batch is open as this could cause issues.

Environment

 7.91.5056, patch 15 ; 7.92.5508.2
 7.93.5782, patch 10

Was this article helpful?