Install Dynamics GP Web Services from the command line

Microsoft Dynamics GPI was giving a colleague a hand with a Microsoft Dynamics GP 2018 R2 upgrade recently (the client didn’t want to upgrade to the very latest version) and we encountered a problem with the installation of the Web Services:

Clr method invocation failed

Setup.exe .NET Framework Error

Clr method invocation failed

Continue reading “Install Dynamics GP Web Services from the command line”

TLS causing a Microsoft Dynamics GP Workflow approval error

Microsoft Dynamics GPI have recently been doing some work with a client to enable the Web Services for Microsoft Dynamics GP for external approval. This requires a steps to configure them for secure external access; when it was configured we tested on afew devices including Android smart phones and iPhones.

We found that everything worked fine, except for the Android devices which returned the following error:

Approval error on Android

ERR_HTTP2_INADEQUATE_TRANSPORT_SECURITY

When I investigated the issue I recalled that I had seen references to this issue previously, but hadn’t realised the meaning. The problem is that the web services use an older version of TLS which has started to be deprecated and actually retired; this looks like it will be a much bigger problem starting very soon as the major browsers also remove support.

Continue reading “TLS causing a Microsoft Dynamics GP Workflow approval error”

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.

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

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.

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

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.

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

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.

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

Hands On with Microsoft Dynamics GP 2018 R2: Web Services on Media Broken

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.

I was going to step through the installation of the Web Services for Microsoft Dynamics GP 2018 R2, but have found that the installer on the media doesn’t work. Selecting Web Services Runtime from the setup utility results in this error:

Error launching Web Services installerClr method invocation failed

I’ve tried this on four different computers and received the same error on all of them.

I’ve reported this to Microsoft for them to look into; in the meantime, I’ve been informed that there were no changes in R2, so the installer of the RTM can be used; I blogged about installing the Web Services for Dynamics GP 2018 RTM back in December 2017:

Install Dynamics GP Web Services 2018 RTM
Install Web Services Runtime
Configure Web Services
Verify Web Services

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Enabling Secure Connection for Web Services: Configure Workflow Setup

Microsoft Dynamics GPThis post is part of the Enabling Secure Connection for Web Services series.

With Web Services now configured for secure connections, the final step in the configuration is to amend the Workflow setup. This is done via the Workflow Setup window (Administration area page » Setup » System » Workflow Setup); despite this being on the System part of the menu, it is actually a Company window so any changes made will need to be repeated in all companies using Workflow.

There are two settings which need to be changed; both of them in the Enable E-Mail Actions section.

Change the Server Name to the externally accessible DNS hostname, change the Port to the relevant port and mark the This server requires a secure connection (SSL):

Workflow Setup

Continue reading “Enabling Secure Connection for Web Services: Configure Workflow Setup”