Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. Native error:242-when generating finance and late charges

When generating finance and late charges, users may receive this error if their workstation's regional settings are set to English (Canada).

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Native error:242
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
Native error:16945

We resolved this issue in version 7.82.104, patch 20. 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. Open the Start Menu
2. Open Control Panel
3. Click on Regional and Language Options
4. Temporarily change the format from English(Canada) to English(US)
5. Exit and Sign out, and sign back in to the software
6. Calculate the finance and late charges
7. Repeat Steps 1 - 5 to change the date format back to English(Canada)

Environment

 7.82.104, patch 18
 7.82.104, patch 20

Was this article helpful?