Notifications
Announcements
No record found.
We have an issue when we run Reconcile Bank Statement in financial module, the select bank transaction screen is empty, it shows no transaction.
I followed this article https://support.microsoft.com/en-in/help/860314/no-transactions-show-when-you-open-the-select-bank-transaction-window
But the issue still exist.
Can anyone help me?
Hello,
In your first screenprint for the Reconcile Bank Statements window, click the DELETE Button. The Delete button will reset it. Then make sure the CM00002 table is empty for this checkbook ID. Then go back into the 'reconcile bank statements' window and try again. Does it load this time?
If not, you may want to open a Support case with Dynamics GP support so we can take a look at the data.
Thanks
Cheryl W
Microsoft Support
Thanks Cheryl
I did as you said and the issue still exist, also table CM00002 is empty.
For other some checkbooks it works fine and for others it is not working.
In the mentioned article KB 860314 there is something about SQL Collation and the statement returns this value >>>
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=706, Collation=SQL_Latin1_General_CP1256_CI_AS, SQLSortOrder=146, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics.
>>>
Is it ok ?
SQL sort order 50and 52 is supported. I see you have 146. If your other checkbooks are on the same SQL instance, I would expect all the checkbooks to work the same.
Look at some of the transactions that you would expect to load the window in the CM20200 table and make sure the RECOND and RECONUM fields are blank. If they are filled in, they will not load the window again.
I would encourage you to open a case, as your last reconciliation may not have completed properly.
Cheryl
The transaction I'd expect has values of 0 in Recond and 0.00000 in RECONUM.
Thanks for your help.
looks like I'll open a case.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
