Notifications
Announcements
No record found.
A client with many transactions each month just requested that I reverse a bank rec.
Restoring isn't an option as they have 20 users in 4 cities and the bank rec was completed the last week of December.
Is this possible?
I found this blog post from 2017:
www.loganconsulting.com/.../
You might want to try these steps in a test company first to actually make sure they are going to actually unreconcile the bank account transactions. I'd also think you would need to make manual transactions to back out anything that was posted at the time of reconciliation (fees, decrease adjustments, increase adjustments, etc).
Joe
I wasn't sure if this was possible ... seeing over 70 views without a response I wasn't overly hopeful. Your post basically identifies the data in the tables and how they relate. I'll have to work out the scripts to remove the transactions as well as set them up back in the unreconciled pile. It will be a bit of work but at least I have something to get back to the client with.
20 years of GP experience and I've never had to reverse a GP bank rec. This is mostly because most of my clients use Encore, which has a dandy utility tool that can easily move the data in and out of the reconciled tables.
Thanks ... database is already restored into test awaiting results.
I'll repost when complete with scripts that I've created and exactly what it entailed as there is a fair amount of analysis of the data that I need to do before resolving this. :)
Interesting ... when I checked on the YES button at first it popped up a different site
support.microsoft.com/.../kb-872693-description-of-bank-reconciliation-tables-in-microsoft-dynamics-gp-72eff676-eb43-7537-8ecd-b47794ba801d
I thought this is what I was working with, but then I clicked on the Logan consulting link after my last post and it does have all of the scripts.
It actually appears to be a relatively simple 4 step process.
I will definitely re-post and let you know how it went
Thank you
I reviewed the post. This additional script should be added for the newer outstanding transaction table:
delete CM20502 where RECONUM = ‘##.#####’
I hope that helps.
Cheryl
Microsoft Dynamics GP Support
Thank you Cheryl!
Steve, I hope this all helps out.
Thank you for your help ... it did require the last script as well.
This worked perfectly and has been approved in test
Production will be corrected tonight after the backup
Have an awesome 2022!
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 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
