How to resolve Error, "SQL Value was either too large or too small for an Int32" when printing checks
The error message is generating because there is a very large check or EFT number in the system.
The accounting software generates the next check number by either:
- Finding the highest existing check number and adding one.
- 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.