Top Categories:
Dynamics GP
ClassicPress

Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service

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.

The OData service allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. This post is going to focus on installing the OData service, but at the bottom of this post I’ve included details of a book, co-written by Mark Polino and I, in which Mark covered configuring OData for use with PowerBI.

To install the OData Service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under the Additional Products heading:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service”

Hands On with Microsoft Dynamics GP October 2019 Release: Install GP PowerShell

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.

The GP PowerShell module can be used to execute commands against Microsoft Dynamics GP such as creating a new company. The installation is a straightforward one which only needs to be done on a machine on which it nwill be used; there also needs to be a Dynamics GP client present.

To install GP PowerShell, launch the setup utility and, under the Additional Products header click GP PowerShell:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install GP PowerShell”

Hands On with Microsoft Dynamics GP October 2019 Release: Verify Web Services

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.

With Web Services not installed, the final step is to verify that everything is working correctly; the steps to verify are the same as those for Dynamics GP 2018 R2 so you can follow the instructions in that post.

If the Windows Service does not start, then you may have installed the Web Services from the October Release download which does not work; make sure you have the fixed version downloaded.

If you need to install the fixed version, I’d recommend a full uninstall and reinstall using the fixed version.

Hands On with Microsoft Dynamics GP October 2019 Release: Configure Web Services

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 last couple of posts, I’ve downloaded the fixed version of the Web Services and run through the installation.

The next step in installing the web services, is to run the Web Services for Microsoft Dynamics GP Configuration Wizard from the Windows Start menu. When it starts, click Next on the welcome screen:

Web Services for Microsoft Dynamics GP Configuration Wizard -

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Configure Web Services”

Hands On with Microsoft Dynamics GP October 2019 Release: Install Web Services

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.

With the fixed version of the Web Services for Microsoft Dynamics GP downloaded, run the setup utility from the downloaded Gp 2018 R2 file. Accept the terms of the License Agreement:

Web Services for Microsoft Dynamics GP - License Agreement

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install Web Services”

Hands On with Microsoft Dynamics GP October 2019 Release: Download Web Services

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, there is a bug with the version of the Web Servcies shipped in the Microsoft Dynamics GP October 2019 release; to successfully install the Web Services as described in the following posts, you will need to download the Web Services for Microsoft Dynamics GP 2018 – R2 Full Install and ​Web Services for Microsoft Dynamics GP October 2019 Release x64 and x86 Environments – patch only 18.2.1013 from CustomerSource lock.

Hands On with Microsoft Dynamics GP October 2019 Release: Error Configuring Web Services

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.

When I installed the web services, I encountered a problem where they would not work. The installation looked like it had worked fine and they also configured fine, but I found that nothing was working.

When I did some further digging, I found that the Microsoft Dynamics GP Service Host service would not start. I spoke to Microsoft and after some investigation, we found that this was a bug which had just been found and fixed in a hotfix.

The short version of this is that the version of the Web Services included on the installation media, does not and cannot work. Instead you need to download the hotfix and use that instead of the version on the media.

In order to get a working installation of the Web Services, I downloaded both the Web Services for Microsoft Dynamics GP 2018 – R2 Full Install and ​Web Services for Microsoft Dynamics GP October 2019 Release x64 and x86 Environments – patch only 18.2.1013 from CustomerSource lock.

Hands On with Microsoft Dynamics GP October 2019 Release: Web Service prerequisites

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. The next few posts are going to cover the installation of the Web Services for Microsoft Dynamics GP.

Before we start the installation itself, there are some prerequisites to make sure are sorted out. The majority of them will be installed by the setup utility,b ut there are others to consider.

Firstly, the Web Services should not be installed on either the SQL Server or an end-user accessible machine. If you’re going to make the Web Services externally accessible, they should be installed on a web server or similar machine.

Secondly, a Domain account is required for the Web Services service to run under. During installation, this service should have local administrator permissions.

Thirdly, all companies which will have the Web Services deployed, needs to have a Functional Currency set. This is needed even if you are not using Multicurrency; in this case, you will need to configure it for use anyway.. When you do so, if you have a lot of hsitorical transactions, plan ahead and allow a lot of time to run Check Links.

Hands On with Microsoft Dynamics GP October 2019 Release: Install Web Resource Cache

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.

With the web client working correctly, the final element required for installation is to install the GP Web Resource Cache on the session host machine(s); this can help to improve performance.

Do this by launching the Microsoft Dynamics GP setup utility and, under Additional Products select GP Web Resource Cache:

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install Web Resource Cache”

Hands On with Microsoft Dynamics GP October 2019 Release: Web Client first run

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 last few posts, I’ve installed the Microsoft Dynamics GP web client and it is now time to test it to ensure it is working correctly. To do this, open your web browser and navigate to the fully qualified URL you set during the installation.

In my example, as I am using a selg-signed SSL certificate, this is the fully qualified domain name of the server on which the session central service is installed:

Web client logon

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Web Client first run”