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
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,
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (