Hands on with the Microsoft Dynamics GP Fall 2020 Release: Create new company

Microsoft Dynamics GPThis post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release.

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

Welcome to Microsoft Dyna 	GP Utilities - login

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Create new company”

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Add sample company

Microsoft Dynamics GPThis post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release.

To add the sample company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Add sample company”

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands on with the Microsoft Dynamics GP Fall 2020 Release series where I am hands on with the newly released Microsoft Dynamics GP Fall 2020 Release.

With the client installed, the next step is to deploy the system database. Do this by launching GP Utilities from the Windows Start menu and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Deploy system database”

Error deploying Microsoft Dynamics GP sample company

Microsoft Dynamics GPI was creating a new Microsoft Dynamics GP test environment the day when I encountered a problem at the point of deploying the Fabrikam sample company.

I did a quick search and found a blog I wrote over six years ago where I got this message and tracked it down to a corrupt installation of the GP 9 server components. Well, server components no longer exist as a separate thing, but it was possible something had happened to the install.

However, after uninstalling and reinstalling the problem still occurred:

Error message

Microsoft Dynamics GP Utilities

Install of database SMTWO failed! Microsoft Dynamics GP Utilities will now shut down.

This environment is using a shared SQL Server, so I’m using SMTWO as the database name for Fabrikam rather than the standard TWO, but I have used alternative names many times without issue.

I am aware that you can’t use reserved words for database names; this is not a Dynamics GP restriction, but rather a SQL one itself. I also tried SOTWO and got the same error and neither of these appear to be reserved names.

When I tried TWOSM, the install went through and worked without any problem, so there is obviously some sort of problem related to the two names I tried.

Hands On with Microsoft Dynamics GP October 2019 Release: Create new company

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. In this post, I am going to take a look at creating a new company in Microsoft Dynamics GP.

To create a new company, launch GP Utilities and log in as sa:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Create new company”

Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. Over the series so far, I have downloaded and installed the prerequisites and client and then deployed the system database. In this post, I am going to add the sample company.

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

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company”

Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. As mentioned in the last post, the client installation these days includes the server installation. With one client now installed, the next step is to deploy the system database.

Do this by launching GP Utilities from the Windows Start menu and log in using the SQL Server sa account:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database”

Workflow in progress have been found in GP. These need to be processed before upgrading.

Microsoft Dynamics GPA colleague was recently performing an upgrade for a client to Microsoft Dynamics GP 2018 R2; this client had previously been a user of the old Dynamics Workflow module (now replaced with Workflow 2.0). They hadn’t used it for a while, but it had never been switched off resulted in the following message being displayed:

Upgrade error

Microsoft Dynamics GP Utilities

Workflows in progress have been found in GP. These need to be processed before upgrading. Please process these workflows before updating. A list of these workflows can be found in GPWorkflows.log

Workflows can be switched off from the front end, but with SQL Server Management studio already open, it was simple to run a SQL update statement against Company Master (SY01500):

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
UPDATE SY01500
SET WORKFLOWENABLED = 0
WHERE WORKFLOWENABLED = 1
GO

Hands On with Microsoft Dynamics GP 2018 R2: Create A Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

As I work with many clients with more than one company in Microsoft Dynamics GP, I always create at least one additiona company, in addition to ,a href=’https://www.azurecurve.co.uk/2018/10/hands-on-with-microsoft-dynamics-gp-2018-r2-add-sample-company/’>deploying 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 2018 R2: Create A Company”

Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

In the last post, I deployed the system database; I’m continuing this post from the Additional Tasks step.

Ensure the drop-down list shows Add sample company data and click Process:

Additional Tasks

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company”