You’re offline. This is a read only version of the page.
175
Is there any way to back out a batch that has been posted through the sub-ledger (AR,AP), but not posted through the the GL? The client inadvertently posted to GL using batch date rather than transaction date. They have adjusted the settings to post by transaction date now, but all of the transactions in the batch to be posted in GL are showing the batch date instead. So far the only resolution I have come across is to post through to the GL, void the transactions, and recreate them. Since there are a large amount of transactions, I'd like to see if there is anyway around this. My only other thought on this would be to identify all of the related tables in SQL where the posting date is listed and write a script to update those accordingly, but I can only assume that that will have some ill effects within GP. Any thoughts?
*This post is locked for comments
Just to add to what Richard is saying - this will also cause your subledger to not equal the GL for the period(s) in question. For example, running the Historical Aged Trial Balance with the GL posting date (so as to reconcile it to the GL) will use the subledger GL posting date, but the GL will have different transaction dates for these transactions. If you perform subledger reconciliations, be prepared to know the exact amount your reconciliation will be off by due to this. If these dates cross fiscal years, there may also be an audit issue because of this.
Either method works, the second, however, will produce a strange audit trail where the source transaction (in AR/AP) shows one posting date and the actual GL transaction shows the other. If you don't care about this, use the second method as it is easier. Print the posting reports and maintain them for the auditors with good notes about the discrepancy.
Hi Mariano, yeah, I think the second one is the way to go alright...just not sure I understood the post correctly.
Best regards,
Hi John. Don't go the SQL route. Void the transactions and re-enter them (you will need to leave things at 'Batch Date' for the void postings...then change to transaction date and post the sub ledger documents again... in order for your GL journals to hit your GL correctly.
However...the GL batch is not posted? What happened is that the sub ledger transactions were entered with the correct document dates?..and the sub ledger batch was then posted...the GL posting date was set to be the batch date...but the journals were not posted in GL?
Why not just update the posting date on the GL Journals that are now sitting in your GL waiting to be posted?
Or you could post as is...and then post a reversing GL journal to clear out the journals, then re-enter them properly - I know that there would be a mismatch between the sub ledger transactions and the GL (in that you couldn't drill back to the sub ledger transactions from the GL Journal), but it might be easier than voiding the sub ledger transactions and re-entering them.
Let me know if I am missing something. Is the document date on the sub ledger transactions correct?
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (