web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Undo Bank Recon with previous month

(0) ShareShare
ReportReport
Posted on by 393

We are in Feb and we need to undo July bank recon to correct the bank reconcile again. And I found the below article as it is possible via SQL but I need to understanf what last balance and last reconciled date should I update in TABLE CM00100.

Article: https://www.loganconsulting.com/blog/dynamics-gp-undo-a-bank-account-reconciliation/

Thanks

Categories:
I have the same question (0)
  • Cheryl Waswick Profile Picture
    on at
    RE: Undo Bank Recon with previous month

    The last reconciled date and last reconciled balance are INFORMATIONAL ONLY fields that you see on the checkbook (Cards | Financial  | Checkbook).   I don't even bother updating those, as they are informational only, and will be overwritten the next time you complete your next bank reconciliation again, so you can just skip updating the CM00100 table in those steps.  These fields will be overwritten again soon. 

    Cheryl Waswick
    Microsoft Dynamics GP Support

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans