
I am new to GP and I made a mistake when reconciling one of our bank accounts for the first time. I didn't change the "last reconciled balance to match my account's regular ZBA balance $10,000. Instead I changed the statement cut off amount to zero to match the transactions total that I knew would fall out after ticking the transactions. Now there is a difference in the "current checkbook balance" and the "cash account balance" of $10,000. Is there any way to undo what I have done or adjust the checkbook balance to $10,000 without affecting the Ledger?
*This post is locked for comments
I have the same question (0)The way I've fixed this is a number of times is to manually change the CURRBLNC amount in the CM00101 table in SQL. Have never had any issues. Make sure you test in a test company first and that you have a fresh backup before playing in the SQL tables.
Hope this helps,