web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Adjusted book balance did not tally with checkbook balance

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at

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

    Leslie

  • Community Member Profile Picture
    on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans