Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

Posted on by Microsoft Employee

Dear Professionals, The ending balance of the book is 5.485, after reconciling please see in the screen shot the details. The difference comes from where i am not able to understand.

petty-cash-ending-balance.JPG

 

I have done all the entries for the year 2014, now in the last step i.e. bank reconciliation i am facing this issue. i have checked the checkbook report & general ledger report i found no difference in both. The CBM showing a below

 PETTY-CASH-BOOK-ERROR.JPG

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Hi Team,

    I am working with one of Implementation and working on Bank reconciliation. I found that one of client has some excess deposits credited into Bank and Client doesn't know what this Deposit is. Previously client was doing Bank reconciliation manually and now we have implemented GP 2015R2. I am not aware how I should show this excess Receipt transactions which credited in bank account and not a part of business transaction. Please advise how it can be adjusted.

    Regards,

    Sanjay 

  • Mohamed El-Tohamy Profile Picture
    Mohamed El-Tohamy 305 on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Dear Rabia,

    I've updated the snapshot here and sent the document to your email, so please feedback and don't hesitate to contact for any kind of support.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Dear Soma, i dont have access to the sql, i have reported this to the IT dept. Once i get a solution on this i will surely update it here,

    Thanks

  • soma Profile Picture
    soma 24,406 on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Have you checked the query(select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750')?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Please find my email : rabia@iws-e.net

  • soma Profile Picture
    soma 24,406 on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Run the below query in SQL server and attach the result. And also verify the first two columns (RECOND & VOIDED), it should be zero.

    select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750'

    Hope this helps!!!

  • Mohamed El-Tohamy Profile Picture
    Mohamed El-Tohamy 305 on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    First no need for sir, second send me your email to send you a document that have all the snapshot and description.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    sir i cannot view the snapshots

  • Suggested answer
    Mohamed El-Tohamy Profile Picture
    Mohamed El-Tohamy 305 on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Dear Rabia,
    You have 2 options to handle your case

    Option 1:

    As I noticed that you already have one journal with 75.750 if your sure that journal is wrong do the following:

    1. Open SQL management studio.

    2. Right click on CM20100 table then select "Edit top 200 Rows" and add checkbook in the filter for that field "CHEKBKID" and the transaction number in that field "CMTrxNum" as per the snapshot

    CM20200.png

    3. Then right click on CM20200 table then select "Edit top 200 Rows" and add checkbook in the filter for that field "CHEKBKID" and the transaction number in that field "CMTrxNum" maybe you will find more than 1 line as per the below

    CM20200.png

    4. To know which transaction should be deleted you can search by your amount in that field "TRXAMNT"

    5. Know which "CMRECNUM" to differentiate between the other transactions.

    6. Highlight the lines that contains "75.750" then delete from both tables using where "CMRECNUM" are the same in the both tables.

    Option 2:
    Open "Checkbook Balance" following this path Inquiry>>Financial>>Checkbook Balance then select checkbook and select in the from "Date" the first date you used the system or that module or you can make it 00/00/0000  if do you find difference in the opening balance do the following:
    1. Open SQL management studio.
    2. Right click on CM00100 table then select "Edit top 200 Rows" and add your checkbook in the filter for that field "CHEKBKID"    your check book ID as per the snapshot

    CM00100.png

    3. You will find in the highlight field the wrong balance so you need to adjust it manually and write the correct balance, then run the inquiry and you will find it solved.

    Wish that this will solve your issues, I noticed that your using BHD so your a neighbor, so you can contact for any kind of support we are so near.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CHECKBOOK BALANCE & CASH ACCOUNT BALANCE

    Dear All, Appreciated your fast response. kindly please i am posting here my update to the progress. i have manually checked both the reports i.e.. the cash account GL report & the check book report. Please find below the shots & i appreciate if someone can provide appropriate solutions to the issue. Please note that the correct balance is 5.585. 

    1- Trial balance amount is correct i.e. 5.585

    CHECKBOOK-REPORT.JPG

    2- CBM BALANCE (the difference here 81.335-5.585=75.750)

    CBM.JPG

    3- GL report balance = 5.585

    GL-REPORT.JPG

    4- checkbook report balance = 5.585

    CHECKBOOK-REPORT.JPG

    5- there is a trx exactly with the same amount as of the difference amount 75.750, but it is appearing in both the reports i manually checked in excel. Is this something to do for that.

    DIFFERENCE-AMOUNT-TRX.JPG

    Your support is highly appreciated.

    Thanks

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans