1,600
Hi folks,
I ran a smartlist cash disbursement report for the period from Feb 2013 to Nov 2013 for testing. As you can see, the same check number was used for different customers. I didn’t realize that the Duplicate Check Numbers option was selected in Checkbook Maintenance. So, what should I do to fix this issue? Can I use SQL to change the check number in the backend?
*This post is locked for comments
You would need to change not only the payables transaction history table but the payables history apply table. The second table records the payments applied to invoices by document (check) number.
For details on these tables, check out our newly updated Information Flow and Posting at www.AccoladePublications.com
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (