Microsoft Dynamics GP 2013 R2 Out of Mainstream Support

Microsoft Dynamics GPMicrosoft Dynamics GP 2013 came out of mainstream support and into extended support as of 1oth April 2018; end of mainstream support means you will no longer get statutory updates such as the addition of the Invoice Receipt Date in the January 2017 hotfix which applied to the UK or year-end tax updates for the US and Canada.

I always recommend to client to look to upgrade every two to three years; the last few years have seen many improvements and additional new functionality added to Microsoft Dynamics GP (2013, 2013 R2, 2015, 2015 R2, 2016, 2016 R2 and 2018) as well as bug fixes.

By not upgrading regularly, you not only miss out on all of these fixes and new functionality, but you also make your eventual upgrade longer and more complex due to the number of versions which need to be upgraded through.

You can review the product lifecycle on the Microsoft Lifecycle Policy – Microsoft Dynamics GP page.

Fixing Reports Not Implemented Error After Upgrade

Microsoft Dynamics GPWe’ve been doing a number of upgrades recently and I encountered an old error when trying to deploy the SQL Server Reporting Services (SSRS) and Excel Reports through the Reporting Tools Setup window (Administration >> Setup >> System >> Reporting Tools).

This particular client is being upgraded from Microsoft Dynamics GP 2013 SP2 to 2016 R2.

The problem is that some of the companies are showing as Not implemented. The companies showing this way are the oldest; TEST2016… is actually the main company renamed for testing.

Reporting Tools Setup

Continue reading “Fixing Reports Not Implemented Error After Upgrade”

List View Action Pane Error During Upgrade

Microsoft Dynamics GPWe have been doing a number of upgrades for clients recently, the majority of which went fine. However, we did have one, being done by one of my team, where there was an error produced on the table List View Action Pane when upgrading to Microsoft Dynamics GP 2015 R2:

Company Detail

Continue reading “List View Action Pane Error During Upgrade”

Microsoft Dynamics GP Upgrade Conversion Process Error

Microsoft Dynamics GPWe’ve recently started work with a client to upgrade their Microsoft Dynamics GP 2010 R2 system to Microsoft Dynamics GP 2015. When running GP Utilities the following error, which caused the upgrade to fail, was produced:

Table Error Detail

The conversion process encountered an error and the temporary table did not get removed.

As a first step, we restored the system database and restarted GP Utilities and got the same error again. I did a little exploring of the Company Master table and found that there were entries for companies which did not exist.

After restoring the DYNAMICS database again and running the Clear Companies.sql script from Microsoft, we were able to run GP Utilities without further errors and complete the upgrade.

Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 1 – Database Principal

Microsoft Dynamics GPI’ve had some right good fun with Management Reporter recently, actually not so much fun, but the bane of my life (in the course of pretty much one day). And over the new few posts I’m going to share the trials and tribulations I have undergone.

A recent upgrade of Management Reporter resulted in a fairly generic error message being displayed while trying to configure the legacy connector (the connector type is not important for this error):

Management Reporter 2012: An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Management Reporter 2012

An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

Continue reading “Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 1 – Database Principal”

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.

Click to show/hide the Upgrading Management Reporter 2012 Series Index

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 Clients”

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: Upgrading the Database”

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: Upgrade the Server Components”

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:

Click to show/hide the Upgrading Management Reporter 2012 Series Index