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.
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
*This post is locked for comments
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
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.
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
Have you checked the query(select RECOND,VOIDED, * from cm20200 WHERE TRXAMNT = '75.750')?
Please find my email : rabia@iws-e.net
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!!!
First no need for sir, second send me your email to send you a document that have all the snapshot and description.
sir i cannot view the snapshots
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
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
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
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
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
2- CBM BALANCE (the difference here 81.335-5.585=75.750)
3- GL report balance = 5.585
4- checkbook report balance = 5.585
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.
Your support is highly appreciated.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156