194
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?
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.
Hello,
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
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 ?
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
