AP Check Number Sequence

(0) Share

Report

Posted on by Community Member

While cutting checks, we had inadvertently used the reference number of the document being paid (798668) instead of the next check number (436245). We voided the check in the system, but now when we go to cut new checks, it defaults to 798667.

Is it possible to get the default to go back to our actual check number sequence? We are on SL2015 CU1.

Thanks in advance for any advice.

*This post is locked for comments

All responses (3)

Answers (2)

Community Member on at

Like (0)

Report

RE: AP Check Number Sequence

I went with a similar method to this. I updated the APDoc, APTran, and APAdjust tables to change the document/transactions type from "CK" to "EP", electronic payment.

Thanks,
Verified answer

Community Member on at

Like (0)

Report

RE: AP Check Number Sequence

Rather than modify the SL code to ignore one reference number used out of sequence, look at updating the incorrect check reference number with a different number, at least one that won't interfere with the next available check sequence. Remember that at a minimum the reference numbers in APDoc, APTran, and APAdjust would require correction. This is independent of the SL version being used.
Verified answer

Mark E 6,445 on at

Like (0)

Report

RE: AP Check Number Sequence

Not really, the stored proc to retrieve the next check nbr will take the max RefNbr value from APDoc for AP Checks (not including Manual "HC" checks). Only way I can see it working is to modify the "FindLastAPCheck" proc to exclude that RefNbr from the query.