Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Adjusted book balance did not tally with checkbook balance

Posted on by Microsoft Employee

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

10_2D00_17_2D00_2017-11_2D00_31_2D00_57-AM.jpg

Here are the checkbook balance inquiry and selected bank transactions

10_2D00_17_2D00_2017-11_2D00_30_2D00_35-AM.jpg

please tell me what went wrong or what table should we checked and fixed.

Thanks a lot for your attention 

thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adjusted book balance did not tally with checkbook balance

    Hi Leslie,

    Thanks for your feedback.

    No we did not try Reconcile to GL.

    because their account balance and checkbook is fine.

    they only have problems in reconcile bank statement.

    in my knowledge there are possibility that they void in different period.

    when I do a simulation in local, adjust book balance did not tally with checkbook balance

    but reconcile bank successful with no difference.

    Thanks

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Adjusted book balance did not tally with checkbook balance

    Have you tried running the Reconcile to GL routine in Financials?

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans