Notifications
Announcements
No record found.
I erroneously entered and posted a bank transaction dated June 27th but should have been July 27th. I immediately saw the error and completed a journal entry reversing the previous entry. Now, the item shows up on my July bank reconciliation as an open transaction to be cleared, even though I see the reversing entry on the account detail report. If I select it on my July bank reconciliation, it shows there is a difference. How do I remove it from my bank reconciliation?
Hello,
If you don't want to see the entry populate any longer you can use SQL to remove it from the CM20200 table at your discretion.
However, please note that this may change the Book Balance value in the reconcile as this balance starts with the Current Balance of the checkbook plus/minus the unreconciled entries in the CM20200 accordingly.
As such, if the reconcile does not complete you may need to produce an additional increase/decrease transaction in the Bank Transaction window so the Current Balance is adjusted and the ending book/bank balances tie out to complete the reconcile when the adjusting entry is included accordingly.
Please note that when you create such an entry you can use the same Cash account tied to the checkbook for the debit/credit amounts so a 'wash' transaction is created if ever posted to the GL that will not update the cash account.
Best Regards,
Jeff Grant
Microsoft Dynamics GP Support
If the reversing JE was made directly in GL, it is not updating the Adjusted Book Balance To correct the Jul Bank rec, another work around is to make a correction entry in the Reconcile Bank Adjustment window as part of your July Bank Reconciliation.
You should be able to VOID the original transaction. Then re-enter it on July 27th. This keeps everything synchronized. Just make sure your VOID date and posting date are the same.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 551 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
