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 ●

Hands On With Microsoft Dynamics GP 2015 R2: Install System Database

● Ian Grieve ●  ● 1 Comment  ● 

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 second post in this series, covers the installation of the System database. This is the database which holds the deployed companies and security configuration amongst oither items. To install the System database, run GP Utilities from the Start screen.

Despite what seems to be a regular argument I seem to have with Infrastructure people, you must log into GP Utilities using the sa account in order to be able to install the System database (no “ifs”, no “buts”; it must be sa):

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Install System Database

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

Hands On With Microsoft Dynamics GP 2015 RTM: Sample Company Deployment

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts o how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here. I am assuming you already have your server built with Windows and SQL Server for this series.

In the last post I deployed the system database; in this one I’m going to take a look at deploying the sample company. While this isn’t something generally done with a new system, I am in the process of building a new demo/test environment.

We’ll pick up where the previous post left off on the Additional Tasks step of GP Utilities. If you had closed GP Utilities log back in and progress through to this step and in the combo box, in the middle of the screen, make sure it is set to Add sample company data and click Process:

Additional Tasks

Continue reading → Hands On With Microsoft Dynamics GP 2015 RTM: Sample Company Deployment

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

Change SQL Server From Windows Authentication To Mixed Mode

● Ian Grieve ●  ● 2 Comments  ● 

Microsoft Dynamics GPA while ago I was setting up SQL Server for a test system, I obviously wasn’t paying enough attention because when I tried to launch Microsoft Dynamics GP Utilities I received the below error:

Microsoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administratorMicrosoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administrator

Continue reading → Change SQL Server From Windows Authentication To Mixed Mode

● Categories: Microsoft, SQL Server, SQL Server 2012 ● Tags: , , , ,  ● Permalink ● Shortlink ●