CHECK NUMBERS OFF ON PRE-PRINTED CHECKS

Hello,

We use preprinted checks at our company so the check number is already on the checks.  We had a situation where checks were printed and mailed out to vendors, then noticed that the check numbers were off by one.  We had a positive pay file and the system (payment_tbl) that matched, but the physical checks were off one.  Since they were mailed out and we did not want them all to get rejected at the bank, I manually fixed the positive pay file and resent to the bank.   I did sql updates on the database to fix any records that had