Tag Archives: GP Utilities

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Deploying The Fabrikam Sample Company

The Fabrikam sample company is deployed via GP Utilities. Log into it using the sa account and progress through to the Additional Tasks. In the drop down list select Add sample company data and click :

Additional Tasks

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft, Web Client | Tagged , , , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Installing The Server

Now we have a client installed, we can use this to install the server. To do this run GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft, Web Client | Tagged , , , , , , , , | Leave a comment

Microsoft Dynamics GP Utilities – Install Of Database Failed

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 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.

Posted in Dynamics, GP, GP Utilities, Microsoft | Tagged , , , , , , | Leave a comment

How To Install Microsoft Dynamics GP 2013 – How To Create A Company

The Microsoft Dynamics GP sample company, which I showed how to install in the last post, is good for doing a demo or for testing, but in the real world most sites will never deploy the sample company. Instead their efforts will be focused on creating a company to host their own data, which is what we’re going to take a look at in this post.

New companies are created using GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP 2013 >> GP Utilities) and login using the sa password;

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft | Tagged , , , , , , , | 1 Comment

How To Deploy The Demo Company In Microsoft Dynamics GP 2010

In the last couple of posts, I showed how to configure the server of Microsoft Dynamics GP by creating the System database and how to create a new company. In this post I’m going to run through deploying the Fabrikam, Inc. demo company.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Posted in Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports | Tagged , , , , , , , , , , | 3 Comments

How To Create A Company In Microsoft Dynamics GP 2010

In the last post, I showed how to configure the server of Microsoft Dynamics GP by creating the System database. In this post I’m going to run through the company creation process.

To create the company, open GP Utilities (Windows Start menu >> All Programs >> Microsoft Dynamics >> GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading

Posted in Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports | Tagged , , , , , , , , , , | 2 Comments

Unknown Error Creating Demo Company

This is another mea culpa post; I’ve been doing enough of them I’m thinking of giving them their own tag.

I was created a virtual machine with the Fabrikam, Inc. demo company in it. When GP Utilities was processing I got this error pop up;

Microsoft Dynamics GP Utilities - An unknown error occurred when initialising tyhe conversion.

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft | Tagged , , , , , , , | Leave a comment

Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

I did a bit of searching and couldn’t find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible. Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | 2 Comments

Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

Microsoft Dynamics GPIt’s always the small things which catch you out.

The recent test upgrade for a client I did between Microsoft Dynamics GP 10 SP5 and Microsoft Dynamics GP 2010 R2 hit a minor snag during the GP Utilities section of the upgrade which resulted in this error message;

Microsoft Dynamics GP 10 Utilities

Continue reading

Posted in Dynamics, GP, Microsoft, SQL Server, SQL Server 2000, SQL Server 2008 | Tagged , , , , | 1 Comment

Microsoft Dynamics GP 2010 Utilities: BCP Utility Error

Microsoft DynamicsI have just returned from customer site where I did an upgrade of Microsoft Dynamics GP 10 to Microsoft Dynamics GP 2010 (I wish they’d called it GP 11 as the current nomenclature confuses customers) and got the error I often get when upgrading or installing GP on Windows 7 or Windows Server 2008 systems and have forgotten to do one of two very simple things. The explanation of the two things later, but first, the error message;

An error occurred while using the BCP utility--data was not correctly copied to the server. Please verify your ODBC settings and that BCP has been correctly installed. Microsoft Dynamics Utilities will now exit.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , | 2 Comments