Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / In Checkbook Balance I...
Microsoft Dynamics GP (Archived)

In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

(0) ShareShare
ReportReport
Posted on by Karen Kaiser 280

When I open the Checkbook Balance Inquiry, my Current Checkbook Balance is correct, it ties to my bank statement.  The Current Cash Account Balance does not equal the Current Checkbook Balance, so I did a GL inquiry, and per the GL, the Cash Account Balance DOES equal the Current Checkbook Balance.

Can anyone give me insight on where the Current Cash Account Balance number in Checkbook Balance Inquiry pulls from, and what could be causing this to happen?  I can't find any consistency in the variances (I have approximately 85 checkbooks, I stopped looking in detail after 5 of 5 had variances).  I have the same numbers reporting in the Checkbook Maintenance screen as well.

The upshot is, my GL balance IS correct, it ties to my bank statment, but whatever is populating the Cash Balance field in Checkbook Balance Inquiry is incorrect.

*This post is locked for comments

  • Suggested answer
    K_G Profile Picture
    K_G 130 on at
    RE: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    I have just fixed this for a client. I ran a DEX SQL log in GP and saw that GP checks the GL10110 table which SHOULD contain period balances for all OPEN years. I noticed that although the current financial year is 2017, the user had a journal with a posting date of 2020, and as this was still an OPEN year (as you can imagine), this was being picked up in the Cash Account Balance calculation.

    The script that GP executes is as follows:

    SELECT 0, 0, 0, 0, ISNULL(SUM(PERDBLNC),0), '', '', '', '', '', '', '', '', '', '', 0, ISNULL(SUM(DEBITAMT),0), ISNULL(SUM(CRDTAMNT),0), 0 FROM .dbo.GL10110 WHERE (  (ACTINDX = 72) and (Ledger_ID in (1)) ) 

    where 72 is my account index for the cash account. The fifth column is the value you see in the GP window.

  • Suggested answer
    Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    Try running a check links for the CM setup and CM transactions...if you are sure that there is not transactions or deposits for the concerned checkbook is left orphaned

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 604 on at
    RE: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    I came across this for the first time ever -- and I've worked with GP since 1.0 beta -- and didn't believe it until I dug into it.

    The problem was the client had a bad GL year-end close.  I needed to manually remove prior year entries from GL10110.  (The table should only have open year entries.  I previously had to clean up GL20000 and GL30000 and reconcile the financial years, but reconcile wasn't "fixing" the prior year entries that were still in the open summary table.)

    The clue was the entry was off by the amount of the current year Beginning Balance.

    Now the Checkbook's GL Cash Balance matches the GL Summary Inquiry.

  • michelle brayton Profile Picture
    michelle brayton 95 on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    I am not sure if this applies but the cash balance listed in the checkbook inquiry is the balance in the general ledger as of the moment of inquiry.  Even when the checkbook is filtered to an earlier point in time, the general ledger balance in the checkbook inquiry window is as of right now and not the filtered date. Additionally, the gl balance is irrespective of whether the fiscal year has been closed. In other words it does include the beginning balance of the previous year.

    If in fact you are viewing that balance in the inquiry window and comparing "apples to apples" (meaning you have no other transactions in your GL after you reconcile) then my next question is are all 85 checkbooks in the same company database?  If so, it is possible that their is an error in the SQL stored procedure used to populate the view for this.  

  • Patricia Bennett Profile Picture
    Patricia Bennett 115 on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    Karen I have the exact situation with one of my customers. I run check links and reconcile and it did not fix the problem. If you have a solution please let me know otherwise if  I figure it out I will post the solution.

  • Community Member Profile Picture
    Community Member on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    Take a backup of the databases and Try running check links for CM Setup

    Rubal,

    http://dynamicsgphelp.com/

  • Karen Kaiser Profile Picture
    Karen Kaiser 280 on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    When I run a GL inquiry, the cash balance is the same as the checkbook balance.  It's just in the Checkbook Inquiry that the Cash balance is DIFFERENT from the Cash balance per the GL.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    Hi Karen,

    Are there any pending bank deposits? In case of deposits, GL account is updated when you posted the transaction (say cash receipt) but checkbook balance is not updated unit deposit is posted. Check Bank Deposit Entry window (Transactions >> Financial >> Bank Deposits),

    Rubal,

    http://dynamicsgphelp.com/

  • Karen Kaiser Profile Picture
    Karen Kaiser 280 on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    Right, so it's not that.  My GL is correct.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: In Checkbook Balance Inquiry, Current Cash Account Balance does not equal GL

    If the transactions are not posted, it is not reflected in the GL balance.  The GL only reflects posted balances.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans