Hi
I recently had to reverse some bank recs for a client that was on GP 2016. I have also done this for a client on GP2015.
As you are on GP2013, the following should work as I don't think the CM tables have had any changes.
Your first step is to make sure that you have a good working backup before you do anything else.
Here are the steps to Undo a Bank Rec after it has been posted. I have gathered these instructions from several posts that are out there on this topic to make it a bit more concise.
SQL queries:
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’
If you are at all uneasy about performing these steps you should engage your partner for assistance.
