CNA L&P - Error message: SQL Value was either too large or too small for an Int32

This article will describe an error message when printing checks and how to resolve it:


The Error:

Error message: "Value was either too large or too small for an Int32." 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.OverflowException: Value was either too large or too small for an Int32."

The error message is generating because there is a very large check or EFT number in the system.


The Resolution:


ConnectNow Accounting generates the next check number by either:

1.  Finding the highest existing check number and adding one.

2.  Or, when a check ceiling is set, finding the highest existing check number below the ceiling and adding one.


To correct the problem go to Accounts → find the bank account for which you are printing checks, and enter a number in the check ceiling field that is approximately 10,000 higher than your paper checks, but lower than the large check number. Entering a number in the check ceiling will prevent the system from seeing the large check number, therefore when you print checks you should not get the error message.  The system should reset its internal counter such that the next check number should be correct the next time you go in the Print Checks screen.

Note: if adding 10,000 to the paper check number does not work, you may have to try to enter a smaller or larger number, it depends on the data in the system, there is no single right answer.


Have more questions? Submit a request



Please sign in to leave a comment.