Troubleshooting: Save Transaction Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

From AutoCount Resource Center

Question: When I save Invoice, this message prompted “SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.” Why?

Version: 1.8 / 1.9 / 2.0

Sqldatetime.png


Possible Reason:

Suspect a date column was input with invalid date which is out of 1/1/1753 – 12/31/9999.

Example field: Our P/O Date.


Solution:

Find out the incorrect date and correct it.
Then you should be able to save the transaction.


Note: Please make sure all workstation and Server computers are having updated date and time too.


By: Lay Swan 220527, P220627


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations