Weird problem. Appropriate for a Monday.
The box office is entering a check payment. The check number is 10 digits. When they enter the number and then tab out of the field, the check number changes itself to a different 10 digit number.
Has anyone seen this before?
Levi,This is a known issue, I reported it about a year ago and this is the response I received from support:
This is a well known issue. The check_no column is a data type int field, which would hold a maximum of 10 characters. However, if the actual value of the check number exceeds the max value for a data type int field, the check_no is saved with the max value allowable for such a field, which is 2147483647. If you enter a number greater than 999999999 (9 digits), 2147483647 is saved in the database. We suggest using a note to record the correct check number.
Thanks Dale,
Just what I needed to know :)