You’re offline. This is a read only version of the page.
1,501
Hello!
My client has about 10 checks that are sitting in Bank Reconciliation. They are from several years back and will never be cleared. There were some data issues, specifically dealing with the fact that the Checkbook ID had been changed since the checks were originally entered, and we cannot void the checks.
My question is how can we get rid of these old checks so they no longer show in Bank Rec? The other thing to consider is the checkbook balances and the GL is correct. This means the solution needs to be two-fold. First, we need to delete the checks and secondly, we don't want the Adjusted Bank Balance to change.
Does anyone have any ideas? I'm sure this will be a SQL update, so guidance to the tables to update would be appreciated.
Thanks,
Steve
*This post is locked for comments
I have the same question (0)
Look at all your CM10xxx and CM20xxx tables and delete any evidence of the transactions. Run Check Links on the CM Transaction tables, which hopefully will produce no errors. Then, in table CM00100 and CM00500, update the CURRBLNC value for that checkbook to reflect the removal of the checks. Of course, do this in a test company first :)
Share
Report
All responses (
Answers (
