Bad Building Blocks – Error generating report in Management Reporter

Ian Grieve2 minute read4 Comments

Microsoft Dynamics GPAs 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.Management Reporter – Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.

Continue reading “Bad Building Blocks – Error generating report in Management Reporter”

PrintFriendlyLinkedin

Access Database Engine Redistributable Command Line Install

Ian Grieve2 minute read1 Comment

Microsoft Dynamics GPIn the last post I discussed installing the correct version of the Access Database Engine Redistributable. One further point to remember is that the x64 distributable cannot be installed in the normal way if the x86 version of Microsoft Office is installed.

However, it can be installed using the command line. This is not a post I can take credit for (I’m posting to help me remember for future reference) as it was first covered by the Dynamics GP Blogster (AKA Mariano Gomez) over twelve months ago.

To installed the x64 Access Database Engine Redistributable via the command line, open a command prompt and navigate to the location of the installer and type the following:

AccessDatabaseEngine_x64.exe /quiet

If you’re installing the x86 by the command line, just omit the _x64.

PrintFriendlyLinkedin

Access Database Engine Redistributable for FRx Migration Wizard

Ian Grieve2 minute read2 Comments

Microsoft Dynamics GPIf you intend to use the FRx Migration Wizard when upgrading a client to Management Reporter then you need to have the Access Database Engine Redistributable installed on the same machine as the Migration Wizard.

And more than just having it installed, you need to have the correct version installed because in either case you will receive the following error:

Management Reporter - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.Management Reporter – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

The important item to remember is that there are two versions of the redistributable; x86 and x64. The version required is the one which matches the operating system. So for example, an x64 OS with x86 Office, needs the x64 version installed.

PrintFriendlyLinkedin

Microsoft Dynamics GP Utilities – Install Of Database Failed

Ian Grieve3 minute read2 Comments

Microsoft Dynamics GPI 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 downMicrosoft 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.

PrintFriendlyLinkedin

“Standing on the shoulders of giants” or “A new MVP is awarded”

Ian Grieve3 minute read3 Comments

Microsoft MVPMany events happen to me around the last two weeks of September and first two weeks of October.

This year is no different. I moved house on the 19th September and today, 1st October I have received an email from the Microsoft Community Engagement team informing me that I have been awarded the 2013 Microsoft® MVP Award.

Woohoo! Go me 🙂

However, by no means does this award mean I can relax; in fact I have a bit of a backlog of posts to get through and a couple of other ideas I’m trying to develop which will hopefully help the community on top of my current activities. I also want to get back to contributing on the Community forum again which has dipped a little due to workload and moving house (lots of boxes to unpack and furniture to assemble/position). So a busy time ahead over the coming months.

Finally, there is no way that I would have won this award without the outstanding contributions made to the online Dynamics GP community by the MVPs and other contributors. So thanks to all who contribute back to the community.

If I have seen further it is by standing on the shoulders of giants.

PrintFriendlyLinkedin

Management Reporter Link To Financial Dimension Range Problem

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPManagement 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:

Dimensions

Continue reading “Management Reporter Link To Financial Dimension Range Problem”

PrintFriendlyLinkedin

How To Configure SharePoint 2010

Ian Grieve2 minute read0 comment

SharePointIn the last couple of posts I have taken a look at installing the SharePoint prerequisites and SharePoint itself and in this one I’ll be taking a look at configuring the new SharePoint installation.

I do need to give the warning I gave in the last post; I am not a SharePoint consultant, so please do not follow these posts to install SharePoint as a live system. I was installing it just to see if I could install it, if it would work and, ultimately, so I could install Business Portal for a demo.

This post picks up where the previous ended with the Configuration Wizard being launched. To proceed, click through the Configuration Wizard, click Next:

Welcome to SharePoint Products

Continue reading “How To Configure SharePoint 2010”

PrintFriendlyLinkedin

Microsoft Dynamics GP 2013 Financial Management Has Been Published

Ian Grieve2 minute read1 Comment

Microsoft Dynamics GPMy second book, Microsoft Dynamics GP 2013 Financial Management has been published and is available now from Packt Publishing.

This is my second book, the first being the Microsoft Dynamics GP 2013 Cookbook, and is the third piece of my work Packt Publishing have released this year (the first being the Microsoft Dynamics GP Techniques Online Leaning Course);

Microsoft Dynamics GP 2013 Financial Management by Ian Grieve

With this book you will:

  • Discover how to improve financial management in Microsoft Dynamics GP 2013
  • Learn the key financial management modules in Microsoft Dynamics GP 2013
  • Improve your abilities with Microsoft Dynamics GP 2013 to gain a better understanding and control of your business

The modules covered in Microsoft Dynamics GP 2013 Financial Management are:

  • Analytical Accounting
  • Cash Flow Management
  • Budgets
  • PO Commitments
  • Encumbrance Management

You can buy Microsoft Dynamics GP 2013 Financial Management from here.

PrintFriendlyLinkedin

How to Install SharePoint 2010

Ian Grieve1 minute read0 comment

SharePointIn the last post I took a look at installing the SharePoint prerequisites so in this one I’ll be taking a look at installing SharePoint itself.

I do need to give the warning I gave in the last post; I am not a SharePoint consultant, so please do not follow these posts to install SharePoint as a live system. I was installing it just to see if I could install it and see if it would work.

To install SharePoint, start the installer and select Install SharePoint Server:

SharePoint Server 2010

Continue reading “How to Install SharePoint 2010”

PrintFriendlyLinkedin

How to Install SharePoint 2010 – The Prerequisites

Ian Grieve2 minute read2 Comments

SharePointI was having a fiddle around a while ago, after I built my new home server, with SharePoint and thought I’d post a short series of posts up to remind myself of how to do the install again.

I don’t typically work with SharePoint as that is in the purview of other consultants at work, but I do need to interact with it for items such as Business Portal. Which is why I decided to have a go at installing it. Before anyone says, I know there is a new version of SharePoint now, but this is the version I had available to me when I did the install and I’m about to move house so don’t have everything setup at home to do a SharePoint 2013 install.

If you do follow these posts and install SharePoint, please don’t do so on a live system. Only use the resulting SharePoint for GP/other demos.

First step, is to install the prerequisites (very easy if you have an Internet connection):

Microsoft SharePoint Server 2010

Continue reading “How to Install SharePoint 2010 – The Prerequisites”

PrintFriendlyLinkedin