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

FRx Migration Wizard Failure

Microsoft Dynamics GPI have a number of clients who have been using Microsoft Dynamics GP for a number of years and who we are now upgrading again. A few of them continued using FRx when they upgraded to Microsoft Dynamics GP 2010, but now they are upgrading to Microsoft Dynamics GP 2013 they also need to switch to Management Reporter 2012 as FRx is not supported with the latest versions of Microsoft Dynamics GP.

Most of these migrations proceed without a problem, but I did have one client where the Migration Wizard ran through and returned a successfully completed message. However, when I logged into the Report Designer to check the migrated building blocks, I found that there was nothing there.

As a double-check, I re-ran the Migration Wizard to the same effects so I started to do some investigation. I eventually took a look in the FRx database and found a number of corrupt rows in the Catalog table like the one below:

FRx Database - Catalog Table

Continue reading

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

Management Reporter 2012 CU8 Now Available

The Dynamics Financial Reporting blog today announced the release of Management reporter 2012 CU8.

Full details can be found at the link above, but here’s a quick summary of some of the new features:

  • Dynamic calculated column headers…no more hard coding of Months within the column definition
  • Currency translation for Dynamics GP 2013 using DDM Data Mart provider
  • Ability to create a side by side balance sheet by using a section break option in row definition
  • Option to include line numbers on generated reports
  • Ability to set all columns in definition to Autofit by default
  • Collection of Excel formatting improvements

Management Reporter 2012 CU8 can be downloaded from here for the US and all other countries here (CustomerSource or ParnerSource login required).

Microsoft Dynamics GP 2013 Reporting – Second Edition eBook Giveaway

I am pleased to announce that I have teamed up with Packt Publishing and are organizing a give away especially for you. All you need to do is submit a comment below the post and win a free e-copy of Microsoft Dynamics GP 2013 Reporting – Second Edition by David Duncan and Christopher J Liley. Five lucky winners stand a chance to win an e-copy of the book.

Keep reading to find out how you can be one of the Lucky Ones.

Continue reading

Management Reporter Period 13 Is Not Valid For Company

This is an issue I came across a few months ago and misplaced my screenshots. Having just stumbled across them on my test Hyper-V server I decided it is still worth posting about.

I was doing some testing on a system with multiple companies created and was looking at a report consolidating figures from all of them into one report. When the report was generated it failed and gave the error message below for several of the companies in the Report Queue Status window:

Period 13 for fiscal year 2013 is not valid for company <company name>. No data will be returned for this company.
Period 13 for fiscal year 2013 is not valid for company <company name>. No data will be returned for this company.

I checked the Fiscal Period Setup in Microsoft Dynamics GP for all reported companies and all of them had the same period 13 defined. Management Reporter, as well as reporting errors in the Report Queue Status window, logs errors in the Windows Event Viewer.

Continue reading