Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

can you back track a bank reconciliation?

Posted on by Microsoft Employee

i have reconciled bank statement through 1/2/2018 and realized a mistake in my 12/28/2017 reconcile.  can i 'undo' the bank reconciliation process and go back to 12/28/17?

*This post is locked for comments

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: can you back track a bank reconciliation?

    Hi Tbarna

    As a general rule there is no 'undo' button

    But, via the back end you can undo the bank rec.

    I strongly recommend that you first try this out in a test environment. Or if you do not feel comfortable, this would be a good time to enlist the services of your Microsoft GP partner.

    1) Determine the Recon# of the reconciliation to be un-done (replace XXXXX with the appropriate Checkbook ID):

    select * from CM20500 where CHEKBKID = ‘XXXXX’

    order by RECONUM

    2) Change the transactions in that recon to not reconciled (replace the ##.##### with the exact RECONUM determined in #1 above):

    update CM20200 set Recond = 0 where RECONUM = ‘##.#####’

    update CM20200 set ClrdAmt = 0 where RECONUM = ‘##.#####’

    update CM20200 set clearedate = 0000-00-00 where RECONUM = ‘##.#####’

    update CM20200 set RECONUM = 0 where RECONUM = ‘##.#####’

    3) Remove the Recon from history (replace the ##.##### with the exact RECONUM determined in #1 above):

    delete CM20500 where RECONUM = ‘##.#####’

    4) Update the Checkbook Master with the revised Last Recon Date and Last Recon Amount (Replace MM with the desired Month and DD with desired day. Replace #######.## with the appropriate amount – no commas. Replace XXXXX with the appropriate Checkbook ID):

    update CM00100 set Last_Reconciled_Date = ‘2010-MM-DD 00:00:00.000′ where CHEKBKID = ‘XXXXX’

    update CM00100 set Last_Reconciled_BALANCE = ‘#######.##’ where CHEKBKID = ‘XXXXX’

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans