Share
ReportHello:
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
All responses (
Answers (
65,271
