Finance | Project Operations, Human Resources, ...

Reconcile Bank Statement, Select bank Transaction Is Empty

(0) Share

Report

Posted on by Mahmoud Seddik

202

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?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Cheryl Waswick Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mahmoud Seddik 202 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Cheryl Waswick Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mahmoud Seddik 202 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No