web
You’re offline. This is a read only version of the page.
close
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) / Adjusted Checkbook Bal...
Microsoft Dynamics GP (Archived)

Adjusted Checkbook Balance issue

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

We have a Manual Check import that was imported twice on March 31 in error with an April 2 date.  I removed the second set of imported data in SQL (CM20200), then ran checklinks which removed the distributions for those transactions (CM20400).  Then we made the correcting entry in GL (on April 2) to reverse the posting of that second group of checks.  I thought perfect, we should have hit everything.  However, going to reconcile the checkbook FOR MARCH 31, we now have an Adjusted Book Balance that is less than the Adjusted Bank Balance, by the amount of those checks. Any thoughts as to what I have missed?

Any thoughts are appreciated...

Craig

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jeff Rowles Profile Picture
    Jeff Rowles 500 on at 
    update cm00100
set currblnc= 10525.00+753.09 --the $10,525 is current bal, the $753.09 is tot amt of                           --checkrun removed from details
WHERE CHEKBKID='WELLSPR'  --enter checkbook ID


    HI Craig,

    The checkbook master table (CM00100) doesn't hold any transaction history, rather just the current balance for each checkbook.  Whenever I have to do any SQL removal work from the CM20200, I also have to add the total amount of the checkrun removed back to this table.  After doing so, bank rec should come back in balance.  Here is  an example:

  • Community Member Profile Picture
    Community Member on at

    Hi Jeff,

    That was the ticket...thank you so much, your help is greatly appreciated. Will need to put that note in a very safe place.

    Best regards,

    Craig

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans