Bank reconciliation - will not reconcile even though the difference is zero

(0) Share

Report

Posted on by Carla Fowler

485

We are on GP2010 and are at the final stage of reconciling the bank account. The difference between the Adjusted Bank Balance and the Adjusted Book Balance is (0.00). However, when we hit reconcile we get the message "The difference must be zero before you can reconcile this checkbook". We don't know why this is happening as the difference is zero.

Any suggestions would be greatly appreciated!

Thanks,

Carla

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: Bank reconciliation - will not reconcile even though the difference is zero

Carla,

There is KB article on this that may help: mbs2.microsoft.com/.../KBDisplay.aspx
Community Member Microsoft Employee on at

Like (0)

Report

RE: Bank reconciliation - will not reconcile even though the difference is zero

Check CM00100 to see if the balance is more than two decimal places. If it is, you can find which transaction has more than two decimal places by looking in CM20200.

You can then change the transaction through SQL to two decimal places. These are the tables that I changed when this happened:

CM00100 CURRBLNC

CM20200, change TRXAMNT, ClrdAmt, ORIGAMT, Checkbook_Amount

PM30200, DOCAMT

PM30300, APFRMAPLYAMT, ActualApplyToAmount, APPLDAMT, ORAPPAMT