Bill Cat loves GP Bank Reconciliation and he didn’t know this either.
In the 20 years I have been using, training on, administering Microsoft Dynamics GP, this has never come up. Well, it finally did last week because of an audit.
After freaking the absolute hell out about what to do and scouring the Internet, I found two articles on what to do. For my sake, I am consolidating it into a single post if I ever need to do this again in the future.
It’s actually pretty simple and just a bunch of SQL statements. Of course, it would be really nice to get to do this *in* GP, but that’s OK.
Here we go!
Step 1: Get the reconcilation number from the CM20500 table (CM Reconcile Header)
SELECT * FROM CM20500
ORDER BY RECONUM DESC
If you have a lot of bank reconciliation transactions, sort by RECONUM descending so you don’t have to scroll!
Step 2: Set the transactions as unreconciled in the CM20200 table (CM Transaction)
UPDATE CM20200
SET RECOND=0, CLRDAMT=0, CLEAREDATE=0000-00-00, RECONUM=0
WHERE RECONUM = the RECONUM you got from Step 1
Step 3: Delete the record in the CM20500 table (CM Reconcile Header)
DELETE CM20500
WHERE RECONUM = the RECONUM you got from Step 1
Step 4: Delete the unreconciled history in the CM20502 table (CM Unreconciled History)
DELETE CM20502
WHERE RECONUM = the RECONUM you got from Step 1
Step 5: Update the checkbook with the last completed reconciliation date and amount
UPDATE CM00100
SET LAST_RECONCILED_DATE = the last completed reconciliation date from the CM20500 table, LAST_RECONCILED_BALANCE = the STMNTBAL amount in the last completed reconciliation from the CM20500 table
WHERE CHEKBKID = 'the checkbook ID you are reconciling'
THAT’S IT! You’ve now successfully unreconciled a bank account so you can re-reconcile it again!