Hands On With Microsoft Dynamics GP 2016 R2: Desktop Client First Run

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I deployed the system database; now we can deploy the sample companuy.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Desktop Client First Run

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

in the previous post, the first client was installed; the next step it to deploy the System database.

Do this by launching GP Utilities from the Windows start menu. Log in using the sa account (this is one of the few times when the sa account must be used; at this time there are no other users which can be used).

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

List View Action Pane Error During Upgrade

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPIn the last couple of posts in this series, we have deployed the system database and Fabrikam sample database. In this post, I’m going to create a new company using GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

wfDeployClrAssemblies Error When Deploying The System Database

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis post is a slight diversion from my Hands On With Microsoft Dynamics GP 2016 R1 series, but I am posting it as it came up while I was deploying the system database.

Towards the end of the deployment an error occurred while the wfDeployClrAssemblies was being executed (actually there were three error messages produced):

Microsoft Dynamics GP Utilities: The following SQL Statement produced an error: EXEC wfDeployClrAssemblies

Microsoft Dynamics GP Utilities

The following SQL Statement produced an error:
EXEC wfDeployClrAssemblies

Continue reading → wfDeployClrAssemblies Error When Deploying The System Database

● Categories: Uncategorized ● Tags: , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Ian Grieve ●  ● 11 Comments   ● 

Microsoft Dynamics GPNow that we have the first client installed, we can deploy the system database. By default the system database is called DYNAMCIS, but i have chosen to use one called D16R1. To deploy the system database, hit the Windows start button, search for and launch GP Utilities.

While I do try to minimise the use of the sa account as it is the SQL Server system administrator account, the initial implementation of Dynamics GP does require its use. So, on the Welcome to Microsoft Dynamics GP Utilities window enter sa in the User ID field and enter the relevant password.

Once done, click OK:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Upgrade Conversion Process Error

● Ian Grieve ●  ● 4 Comments   ● 

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.

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 R2: Create A New Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

In this fourth post, I’m going to cover the creation of a new company; in this case I am going to create a company for Perfect Image Ltd. To create a new company, launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Create A New Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 R2: Deploy The Sample Company

● Ian Grieve ●  ● 2 Comments   ● 

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

The third post, covers the deployment of the Fabrikam, Inc. sample company. Launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Deploy The Sample Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●