1,652
We have one system database and 6 different application databases (companies). On only one of our companies, when we go to run AP checks, the check number is always defaulted back to 000001 even after I enter a batch number. How do I fix this so I don't have to manually enter the next check number each time?
*This post is locked for comments
It is very strange that it would go to check number 1 if a higher number has been entered!
There are several tables that need to be adjusted, VERY VERY carefully... For obvious auditing reasons, as well as the fact that I might not get all the tables exactly right, I hesitate to give instructions here.
If you have the "Advanced Keychange" program, it will let you change check numbers. Also, your dealer or Microsoft support might be able to give detailed guidance.
If you are using Cash Manager, then it would definitely be a lot of work!
Toni
After a little more investigation, it appears that what happened is that on a batch of checks, the incorrect starting check number was entered so the check number in Solomon does not match the physical check number. Is there a way to go in and change those checks numbers so they reflect the correct physical check number?
it might... especially if it is going to 1, which implies that it thinks this is a brand-new checking account/sub
you could always momentarily change it to a length of 3, (make sure no one else isdoing data entry!) and see if it can find the high number... not sure of a workaround, though.
There are no non-number check numbers. Their flex key definition for the sub-account is set for a length of 6 but their actual sub-account for the cash account used for the AP checks is only 3 characters long. Would that have anything to do with the problem?
That option is not available in SL-- I think Zelle was thinking of another product.
SL always allows you to override (hence, you can enter a different check number as you are doing)
SL picks up the highest check number it finds, so there may be a "junk" check number out there. If you have soemone who knows how to useSQL for Solomon, they should check the REFNBR field in all
APDOC records with DOCCLASS = "C". If they "Order by" they should find the non-numeric one.
I do not see that option anywhere in Payables setup
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (