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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Current Checkbook Balance Incorrect

(0) ShareShare
ReportReport
Posted on by

During a payroll posting last month we had an interruption. The fix resulted in us having to deleted erroneous check numbers and the corresponding UPC entry that was created. Everything looked fine, but now when we go to do our bank rec for the month the Current Checkbook Balance is incorrect. We even ran the checkbook balance for months that had already been reconciled and the balance is off by the erroneous checks that we deleted.  Its almost like the system is recognizing the checks that we had to deleted. Not sure how the system figures out the Current Checkbook Balance. Any help would be greatly appreciated. 

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    26,225 on at
    RE: Current Checkbook Balance Incorrect

    The checkbook current balance you are seeing is stored in the Checkbook Master table (CM00100). The cash account balance comes from the actual GL account associated with the checkbook. Assuming you are referring to the current balance, you could run a simple query on the CM00100 to update it, or you could use standard reconciliation procedures to enter it as an adjustment.

  • Community Member Profile Picture
    on at
    RE: Current Checkbook Balance Incorrect

    Hi Mariano,

    Thanks for the suggestion. Would that correct the balance going back as well?

  • Community Member Profile Picture
    on at
    RE: Current Checkbook Balance Incorrect

    Just tested this and it does not correct the balance going back.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans