OPENING CHECKBOOK BALANCE

(1) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Rabia,

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

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (1)

Report

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!!!

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No