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.
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.
Posted in Dynamics, GP, Management Reporter, Microsoft
Tagged Consolidated Reporting, Error, Errors, Financial Periods, Financial Reporting, Fiscal Periods, GP, Management Reporter, Management Reporter 2012, Microsoft, Microsoft Dynamics, Period 13, Reporting
As you may have noticed I have been doing a fair bit of work recently with Management Reporter and this has involved a number of upgrades from FRx which has meant I have used the Migration Wizard a number of times.
When I used it a few weeks ago (screenshots taken at the time but I haven’t had time to post it until now) everything went well. I was able to view the report definitions and check that everything looked okay. However, I ran into a problem when it came to generating a report. Any report. I received the following message:
Management Reporter – Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.
I was asked to create a new company for a client recently, who is still running Microsoft Dynamics GP 9, which should have been an easy task. However, when I tried to run GP Utilities to create the company I received an error:
Microsoft Dynamics GP Utilities – Install of database GPTV failed! Microsoft Dynamics GP Utilities will now shut down
I did a bit of exploring and testing of the system, but couldn’t identify the problem. I then tried to search online and did come across a Microsoft Knowledge Base article but it was of no help. I finally decided that the problem might be the client installation I was using.
As mentioned, this particular client is still using Microsoft Dynamics GP 9 which had a separate server components install (they are in the middle of an upgrade project to bring them to the latest version) which complicated things a little as I couldn’t just use any other client.
Instead, I made a did a backup of their DYNAMICS system database and loaded it onto a VM with SQL 2000 and GP 9 SP3 already installed. I was able to use the GP Utilities in the VM to successfully create the company.
That done, I backed up the system and company database and restored them to the clients live SQL Server before anyone started work in the morning. This approach is a little roundabout, but it was a little easier than reinstalling the client on the server and meant I didn’t risk disrupting anything.
Management Reporter again, folks, after a short delay; I finally completed on a house purchase, in rural Northumberland, two years after I started work at Perfect Image.
I received another call that data on a report was not coming out correctly a short time ago (I’ve had the screenshots stored for a while until I had time to write this post); the numbers didn’t match those in Microsoft Dynamics GP or those on the old FRx report (which did match the numbers in GP.
I started by checking the Row Definition and the Link to Financial Dimension column to see what information was being brought through. The setup with ranges for the excludes struck me as a little odd with the ranges of 1:1, 10:10 and 100:100:
A client logged a problem which I needed to look at through the GP 2010 client, so I logged onto their server and ran up GP.
Or at least I attempted to. After double clicking the Desktop shortcut I received the following error message;
Dexterity Runtime – Unknown dictionary error
Sometimes I find Integration Manager to be very trying. It can be a very useful tool but it can also be incredibly frustrating.
A client we have taken over support for logged a call about an integration they couldn’t run and hadn’t been able to run for a couple of months after their upgrade to Microsoft Dynamics GP 2010. The error message they were receiving was this;
Integration Manager – Object reference not set to an instance of an object
Posted in Dynamics, GP, Integration Manager, Microsoft
Tagged Error, Errors, GP, Integration Manager, Integration Manager 11, Microsoft, Microsoft Dynamics, Microsoft Dynamics GP 2010, Permissions
A client who upgraded to Microsoft Dynamics GP 2013 a few weeks ago began encountering a problem when switching between modules. In particular when they loaded the Purchasing area page they received the following message;
Value cannot be null. Parameter name: contentValue
Fortunately, there are two solutions to this problem outlined in the Microsoft Support KB Article 2843273. The first is to upgrade to Microsoft Dynamics GP 2013 which at very short notice isn’t really an option, or to use the script in the KB article to both remove the corrupt entry in SY07140 and add a trigger to the table to prevent another corrupt entry being created.
As we needed the client up and running without the error quickly, we opted for the second approach and will look to schedule in the upgrade from 2013 RTM to SP1.
While importing a customised Form with VBA I encountered a problem and received a Component write exception;
Component Write Exception
The form itself had imported but the VBA element had not.
Not having seen this error before I hit up Bing and soon found a blog post from Dex Master David Musgrave where he discusses this exact issue on GP9 (I was loading a customisation from GP9 to GP 2010 to upgrade).
The answer was not quite what I wanted. I was hoping for something nice and simple, but instead I needed to export all the customisations, delete the forms.dic, reports.dic and dynamics.vba files and then reimport all of the customisations.
After I did this the import worked fine.
Posted in Dynamics, GP, Microsoft, Report Writer
Tagged Customisations, Errors, GP, Microsoft, Microsoft Dynamics, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 9, VBA
I was trying to install Management Reporter 2012 the other day and received an error message I’ve not seen before;
Windows Installer – The Windows Installter does not permit installation from a Remote Desktop Connection
While I was working on the series of posts for how to install the Web Services for Microsoft Dynamics GP, I encountered a couple of problems which I thought it might be worth covering; in the last post I looked at resolving a problem with the eConnect Integration Service not running. The second error I encountered was after I installed the Management Tools on a client machine and tried to start it;
Could not access service: Could not access the SecurityService service. The request failed with HTTP status 404: Not Found
Posted in Dynamics, GP, Microsoft, Web Services
Tagged Configuration, Error, Errors, GP, Installation, Installation & Configuration, Microsoft, Microsoft Dynamics, Microsoft Dynamics GP 2013, Web Servixces