You’re offline. This is a read only version of the page.
Hello:
About a month ago, we came across an identical payables voucher number in SQL. Since GP would not allow us to post or void this corrupt transaction, we had to remove this transaction from history within GP.
With the removal of the transaction, the end user was then able to post her batch of vouchers. But, now, the payables subledger is out of balance with the general ledger of course.
This payables transaction originated from the posting of a manual payables credit card transaction.
So, the remedy for this issue is not as simple as re-opening the fiscal period for last month and entering a new "replacement" transaction to get the subledger in balance with the general ledger.
So, does anyone out there have a "primer" for entering this voucher on the back-end through SQL "INSERT" querying?
If this transaction can essentially be "recreated" in SQL, the payables department could process the transaction and then have the subledger in balance with the general ledger.
Thank you! Much appreciated!
John
*This post is locked for comments
Thank you, Leslie!
John
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (