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 “FRx Migration Wizard Failure”

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 Error Opening Column Definition”

FRx – Such A Small Typo, Such A Big Effect

Microsoft Dynamics GPSometimes it is difficult to see the cause of a problem. We’re in the process of upgrading a heavily customised installation of Microsoft Dynamics GP for a client and are installing the new version on a new environment.

When it came to installing FRx I had a bit of a problem. I had installed and configured it on the SQL Server without any problem, but when I installed it on a Terminal Server I ran into the following error;

FRx Professional - FRx32.OSFIMain.CheckOFSIConnection - 8900: Frx is unable to open a connection to the general ledger database because the specified ODBC data source is not value. Verify that the data source exists on the computerFRx Professional – FRx32.OSFIMain.CheckOFSIConnection – 8900: Frx is unable to open a connection to the general ledger database because the specified ODBC data source is not value. Veryify that the data source exists on the computer

Continue reading “FRx – Such A Small Typo, Such A Big Effect”

Microsoft Dynamics GP and Schrödinger’s Cat

One of the points I make (repeatedly until I see a confirmation they’ve done so) to clients when implementing Microsoft Dynamics GP is that they need to make sure that a maintenance backup of the SQL databases and other resources are being made.

In some cases the maintenance backup is a once a night job, other clients have had one done every twelve hours with log backups made every hour. As long as a regular backup is being made I’m happy and stop nagging them.

Continue reading “Microsoft Dynamics GP and Schrödinger’s Cat”

Changing FRx Menu Option To Open Management Reporter

Microsoft Dynamics GPIn this post I discussed renaming the FRx menu option in Microsoft Dynamics GP to show the name Management Reporter. One thing I didn’t cover, and which Susan Conrod reminded me of in the comments, is how to change the menu option so that it does actually open Management Reporter.

If you have not previously used the FRx mneu option on a client, then clicking the, FRx, or Management Reporter as it will be after you have renamed it, menu option in Microsoft Dynamics GP (Reports ¯ Financial ¯ Management Reporter (or FRx)) you will be presented with this window where you can select the application to be started;

FRx Setup

Continue reading “Changing FRx Menu Option To Open Management Reporter”

Replicate FRx To Management Reporter Command Customisation To Other Users

Microsoft Dynamics GPIn the last post I showed how the FRx menu can be renamed to show Management Reporter instead.

However, it is also a per user setting so would need to be done for each user created in Microsoft Dynamics GP who had access to Management Reporter.

To make the job a lot less onerous, I thought it might be useful to follow up with a SQL script to copy the FRx command customisations from one user to all others Continue reading “Replicate FRx To Management Reporter Command Customisation To Other Users”

Renaming Microsoft Dynamics GP FRx Menu Option To Management Reporter

Microsoft Dynamics GPThe FRx Reporter tool is being retired very soon. It’s replacement, Management Reporter, has been available to all customers for a while and is the only option for new ones implementing Microsoft Dynamics GP.

FRx has an entry on the Reports menu (Reports ¯ Financial ¯ FRx) in Microsoft Dynamics GP which can be replaced with Management Reporter. Unfortunately, this is a per user setting but does change the menu in all companies for each user who makes the change.

To change the name of the FRx menu, right click on the toolbar and then click Customise…;

Microsoft Dynamics GP

Continue reading “Renaming Microsoft Dynamics GP FRx Menu Option To Management Reporter”

Transferring GP To A New Server Without Resetting All Passwords

[One of the annoyances when migrating a client’s installation of Microsoft Dynamics GP to a new server is that, unless the new server has the same name as the old one, the password of every user needs to be reset as the server name is encrypted in with the password.

The is another alternative though and that is to create a DNS CNAME Alias and use this as the server name in the SQL Server ODBC instead of the servers actual name. When GP is migrated to a new box you only need to amend the DNS CNAME Alias and users can continue logging in with the same password. Continue reading “Transferring GP To A New Server Without Resetting All Passwords”

Missing Font Causes Crash In Management Reporter

I’ve recently been doing some work for a client where we’ve upgraded them from Microsoft Dynamics GP 10 to 2010 R2. Alongside this, we also migrated them from FRx to Management Reporter.

All looked fine after the upgrade until I opened one of the rows for editing and got the following warning message;

Management Reporter - Font 'Gill Sans' cannot be found.

Continue reading “Missing Font Causes Crash In Management Reporter”