Dear Fellow GP Consultant,
My client has problem with Reconcile Bank Statement.
Their last reconcile was 31th July 2017, the amount still tally with their manual.
But then when they tried to do reconcile in august, they found that their checkbook is no longer balance.
There is problem with their checkbook beginning balance.
But we managed to fixed that with some scripts.
what we found out later that, turns out they have made a Reconcile Bank Statement for current checkbook in save mode.
the adjusted book balance is until now has about 1B difference with their total and checkbook balance inquiry.
Correct me if I'm wrong.
What I read about field Adjusted Book Balance is supposed to be has same amount with Checkbook Balance Inquiry.
Here is reconcile bank statement

Here are the checkbook balance inquiry and selected bank transactions

please tell me what went wrong or what table should we checked and fixed.
Thanks a lot for your attention
thanks