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
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
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’
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156