Hands On With MDGP 2018 RTM: Create A Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

As well as deploying the sample company, I always deploy a second company into which I will restore a copy of Fabrikam; this allows Intercompany to be configured and demonstrated when necessary.

To create a new company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP

Continue reading “Hands On With MDGP 2018 RTM: Create A Company”

Hands On With MDGP 2018 RTM: Deploy System Database

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the client now installed, I am able to progress to using GP Utilities to deploy the system database, the name of which was defined on the SQL Server step of the client install.

To deploy the system database launch GP Utilities and log in using the SQL Server system administrator (sa) account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With MDGP 2018 RTM: Deploy System Database”

Error Creating A New Company: Cannot Insert Duplicate Key In Object ‘dbo.SY60100’

Microsoft Dynamics GPOne of our clients was creating a new company recently when GP Utilities produced an error:

Microsoft Dynamics GP: Cannot insert duplicate key in object 'dbo.SY60100'

Microsoft Dynamics GP

[Microsoft][SQL Server Native Client 11.0]p[SQL Server]Violation of PRIMARY KEY constraint 'PKSY60100'. Cannot insert duplicate key in object 'dbo.SY60100'. The duplicate key value is (sa, 114).

The client clicked the OK button and GP Utilities ran through to completion. However, when the user logged into Microsoft Dynamics GP using the sa account, the company was not available for selection.

This is when they called us asking for help.

When we connected in we found that the company did have a record in Company Master (SY01500), but did not have an entry in User-Company Access (SY60100).

The company was listed in the Delete Company window (Administration >> Utilities >> Delete Company). However when the company was deleted, the database remained behind.

I’ve had problems deleting databases this way before, so when I was called over, I directed my colleague to delete the database directly in SQL Server Management Studio and run the Clear Companies script available in Microsoft KB 855361.

A quick search for the error message, revealed a Microsoft Knowledge Base article covering this exact issue.

At some point, the system database’s owner had been changed away from DYNSA. Running the following script set the owner back to DYNSA, allowing the company to be created:

sp_changedbowner 'DYNSA'

Hands On With Microsoft Dynamics GP 2016 R2: Manage Web Client SQL Server Login

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.

The final step before we can log into the web client, is to configure the client with a proxy user which is used to connect to SQL Server. If you did this while installing the Microsoft Dynamics GP desktop client, you do not need to do this step now (provided of course that the username and password you set while installing the web client match what you set when installing the desktop client.

To configure (or manage) the Web Client SQL Sever Login, launch GP Utilities and log in using the sa or other user account with security admin permissions:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Manage Web Client SQL Server Login”

Hands On With Microsoft Dynamics GP 2016 R2: Create A Company

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 this post, I’m going to cover the creating of new companies in Microsoft Dynamics GP 2016 R2; to create a company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Create A Company”

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

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

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”

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

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”

List View Action Pane Error During Upgrade

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”

Hands On With Microsoft Dynamics GP 2016 R1: Create Company

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”

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

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”