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) / OPENING CHECKBOOK BALANCE
Microsoft Dynamics GP (Archived)

OPENING CHECKBOOK BALANCE

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

CB-INQUIRY-REPORT.JPG

my check book balance enquiry report is showing me a starting balance with a difference of 187.090 with the actual opening balance.

the difference between the highlighted figures would be my opening balance which is wrong. 

how it has taken this extra amount of 187.090. the report is showing that this amount was already available in the CBM opening balance.

The actual opening balance amount should be 11.240, which i have made the IAJ0000000022 (to reflect the opening in the bank reconcialition only the GL posting update was disabled while making this adjustment) as the GL was already updated in the Trial balance GL posting.

Please advise.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: OPENING CHECKBOOK BALANCE

    Hi Harry, i was having the same solution to implement & see, but before i could do that you suggested it too. I have done & my problem has been solved.

    Thanks alott all over here for suggested possible solutions.

    Thanks

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: OPENING CHECKBOOK BALANCE

    Rabia,

    I have seen similar scenarios to the one you have here, when someone has adjusted the CURRBLNC field in the CM00100 table.  This is a not uncommon scenario, when General Ledger transaction history for cash accounts was imported into the General Ledger and not Bank Transaction Entry.

    Your post indicates you entered an 11.240 Increase Adjustment into Bank Transaction Entry, and deleted the General Ledger Distributions, instead of Posting, which should have had the desired effect.  You should have been rewarded with a beginning balance of 11.240.  

    Since there aren't any other transactions in your Inquiry screen shot, the transaction, which changed your balance either occurred in a different period or was a SQL update to the CM00100 table. The good news is the answer is the same, in either case.

    I would suggest entering a Decrease Adjustment for 187.090 in much the same way you entered the 11.240 Increase Adjustment, with Bank Transaction Entry posting configured to post to, not through, the General Ledger, in Setup > Posting > Posting.  Based on your description of the problem you need to remove the 187.090 without having it update the General Ledger.

    If I have misinterpreted your post, and both the Checkbook Balance and the General Ledger need to be updated, then post the General Ledger Entry created by the Decrease Adjustment.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: OPENING CHECKBOOK BALANCE

    Hi Rabia,

    Its looks like some transaction was made before jan 2014. Please change the date all and check if any transaction available before Jan 2014.

    Note: you can also check the bank transactions from smartlist before jan2014.

    Hope this helps!!!

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: OPENING CHECKBOOK BALANCE

    Hi Rabia,

    Please click here to see Microsoft KB to fix the balance of checkbook.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans