Microsoft Dynamics GP 2016 R2 Financial Dashboard Error

Microsoft Dynamics GPWhen reviewing some dashboards with a client a while ago we encountered an error launching the Financial Dashboard:

Microsoft Excel - We found a problem with some content in 'T16R2 Financial Dashboard.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Microsoft Excel

We found a problem with some content in 'T16R2 Financial Dashboard.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Clicking Yes results in the Repairs window launching and showing the removed parts:

Repairs to 'T16R2 Financial Dashboard.xlsx'

Clicking close, then resulted in another error being displayed:

Microsoft Excel - Incorrect syntax near '@TimeUnit'

Microsoft Excel

Incorrect syntax near '@TimeUnit'

Clicking OK results in another error:

Microsoft Excel - The following data range failed to refresh: TWO BankTransactions Top 5 Checkbook Balances_1 Continue to refresh all?

Microsoft Excel

The following data range failed to refresh: TWO BankTransactions Top 5 Checkbook Balances_1

Continue to refresh all?

Clicking OK produced another error, this time a SQL Server login rather than an Excel one like the previous:

Microsoft SQL Server Login - Connection failed.

Clicking OK opens the SQL Server Login dialog:

After playing around with a few settings, we concluded that the issue was not able to be resolved and logged with Microsoft. This was confirmed as a quality issue (91076) by Microsoft and that it is with the development team for investigation.

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name

Your Email

Subject

Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

3 thoughts on “Microsoft Dynamics GP 2016 R2 Financial Dashboard Error

  1. Pingback: Comment
  2. Comment says:

    Any solution for this issue? we are almost May of 2019 and I have the same issue.

    1. Comment says:

      No, I’ve not seen a fix for this problem.

Leave a Reply

Your email address will not be published. Required fields are marked *