AP check numbers

(0) Share

Report

Posted on by Community Member

The check sequence was for AP. However, the check batch I ran was for 300 checks and all I did was input the starting check number and I let them print. The numbers went from 9963-9999 and then started over from 0000 - 0259 instead of going 10000 and on. I noticed the number sequence when I printed the attached check register.

This means the check's will not match the bank statement in September.

How do we fix that in GP so it continues with more than 4 digits?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Mike Smith 6,840 on at

Like (0)

Report

Re: AP check numbers

GP next check number is controlled by the "Next Check Number" located in Checkbook Maintenance accessed from Financial > Cards > Checkbook Maintenance. A "0" can be added to the sequence to move it to "10000" (assuming is was done previous to printing the checks).

Have you already posted the checks or is the batch still sitting in the Post Checks window?

If so, you could void the checks, correct the Next Check Number in Checkbook Maintenance and re-print the checks. Starting Check Number may need to be adjusted during this process on the Post Checks Window.

You'll just need to make sure that both check numbers match up with the next in the pile (assuming pre-printed check stock).

Without SQL work, there will be somewhat of a mess still as those resequenced checks will still show in GP, even though voided.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: AP check numbers

Mike is correct. If your check will go from 5 digits to 6 or even 7 you would start out with check number 0000001. The way the routine works is it works from right to left and looks for the first non-digit or the end(beginning). So if check number 5000 was your next check number when you started using this checkbook, you would set the next check number to 005000. This would allow you to grow to 9999999.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: AP check numbers

The checks were already posted.

Was this reply helpful? Yes No
Verified answer

Carol Livingston 30 on at

Like (0)

Report

Re: AP check numbers

In your Checkbook, I believe you need to add some leading 00's in front of the next check number, that will give you the room to expand. So just reset your starting check number to be something like 010260 or 0010260. The next numbering only goes to the highest number of value in your next numbering and does not automaticallly expand the number of digits when you hit the top of that range.

Also, you should make sure that the box is checked to NOT allow duplicate check numbers. Thinking if you had used the 0-259 check range before, you may not want these to be used again.

If you haven't sent out the check run, maybe void the checks. Reset the checkbook and rerun run the checks.

If the checks are already sent out, then just make sure you note the corresponding numbers to clear when you do your bank recon.

Good luck. Carol

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AP check numbers

We had the same problem so we reset the check number with preceding zeros but get a message saying changing the length of the field may cause problems with auto-reconcile, which we don't use. Do we ignore the message?

Was this reply helpful? Yes No
Brenda Willey 2,520 on at

Like (0)

Report

RE: AP check numbers

Long the same line we had leading zeros in a client check number but the bank is deleting them in an BAI file and they are not matching so we added a number to the beginning of the check numbers and it prints one check ok but then adds the leading zero back on the next check. I get the message about the auto reconcile but we are not using the GP reconcile so we ignored it. We added another zero in the middle thinking there was a mandated number of digits somehow but it cleared the middle zero and then added back in the leading zero. Bizarre. Anyone have any ideas at all??

Was this reply helpful? Yes No