MDGP 2015 Feature of the Day: Management Reporter Data Integration

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty third Feature of the Day is Management Reporter Data Integration. In Microsoft Dynamics GP 2015, the user can determine the data that is available to the Microsoft Dynamics Management Reporter DataMart, improving the performance and giving the user control over the data selected.

The user can choose per company (including sample company) if they want the General Ledger data available for reporting.

The user also has the ability to include or exclude Analytical Accounting data for each company:

Company Setup Options

I am slightly puzzled by this feature of the day as you can simply not import a company into Management Reporter if you don;t want to report on it. While I steer clients away from AA where possible, I am not entirely opposed to it, but I do wonder who would want to report on AA without also wanting to be able to report on the GL.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty sixth Feature of the Day is Management Reporter in Business Analyzer.This features enables users to add Management Reporter content to the Microsoft Dynamics Business Analyzer app:

Companion Application Services Configurator

Continue reading

MDGP 2015 Feature of the Day: Management Reporter Integration Setup

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty fifth Feature of the Day is Management Reporter Integration Setup. This feature created a new navigation list for accessing Management Reporter reports from within the Financial and Administration Navigation buttons.

The Management Reporter navigation list becomes enabled once the location of the Management Reporter service is defined in the Reporting Tools Setup window:

Reporting Tools Setup

The location of the Report Designer Application is an optional field and when defined, will enable users to launch the designer from the Management Reporter navigation list if they have permissions to application.

The navigation list displays a list of reports the current user has security access to and enables them to view the reports in the Management Reporter Viewer with just a click of a button.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Management Reporter Integration

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty fourth Feature of the Day is Management Reporter Integration. This feature created a new navigation list for accessing Management Reporter reports from within the Financial and Administration Navigation Lists.

The Management Reporter navigation list becomes enabled once the location of the Management Reporter service is defined in the Reporting Tools Setup window.

The navigation list displays a list of reports the current user has security access to and enables them to view the reports in the Management Reporter Viewer with just a click of a button:

Management Reporter Reports

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

Upgrading Management Reporter 2012: Post Upgrade Connection Problem

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

Over the last three posts I covered the upgrade of the Management Reporter server and client components. If the components and database has been upgraded as covered in the posts then you should not see the error message shown below:

Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?

This error is one seen at a client who had done the upgrade on the server and the majority of clients. But one user who had been on holiday that day hadn’t had their PC updated and wasn’t aware it had been done. So when they tried logging into Management Reporter they logged the issue.

A short client upgrade later and they were up and running without further problems.

Upgrading Management Reporter 2012
Upgrade the Server Components
Upgrading the Database
Upgrading the Clients
Post Upgrade Connection Problem

Upgrading Management Reporter 2012: Upgrading the Clients

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

With the server fully upgraded we now need to upgrade all of the clients. To do this start the same setup.exe as used to upgrade the server components and select Management Reporter Client:

Management Reporter Setup

Continue reading

Upgrading Management Reporter 2012: Upgrading the Database

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

In the previous post I covered the upgrade of the server components; in this one I’m going to finish the upgrade of the server which requires that the database also be upgraded.

To do this run the Configuration Console from the Windows Start screen; you’ll see a Task List in the bottom right corner of the window showing thre items:

Management Reporter 2012 Configuration Console

Continue reading

Upgrading Management Reporter 2012: Upgrade the Server Components

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

The first step in upgrading Management Reporter is to update the server components. To do this download the latest Rollup from either PartnerSource or CustomerSource. Run the downloaded MSI and specify a path to extract the files into (by default the files will be extracted into the same folder as the MSI, so I typically create myself a folder called MR and extract the files into that:

Choose Directory For Extracted Files

Continue reading

Upgrading Management Reporter 2012: Series Index

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup.

The post will serve as the series index:

Upgrading Management Reporter 2012
Upgrade the Server Components
Upgrading the Database
Upgrading the Clients
Post Upgrade Connection Problem

Management Reporter Error Opening Column Definition

Microsoft Dynamics GPDuring a recent upgrade of a client from Microsoft Dynamics GP 2010 to Microsoft Dynamics GP 2013 we also did a migration of FRx to Management Reporter.

After doing the test upgrade and migration I tested Management Reporter and everything was working fine. However, a month later when I was back on site for the live upgrade and some additional training, I found that Management Reporter was no longer working correctly.

When I tried to open a column definition I received an error:

Management Reporter: The operation could not be completed due to a problem in the data provider framework.Management Reporter: The operation could not be completed due to a problem in the data provider framework.

Continue reading