Error adding certificate to Web Services for Microsoft Dynamics GP

Microsoft Dynamics GPWith the current situation a lot of clients now have people working from home using a number of approaches. One of them is to use the Workflow module for document approvals and the integration with Web Services for approval via email. When approvals are done by email on devices outside the domain, the web services need to be securely configured with an SSL certificate.

I was recently working on a Workflow project for a client, but ran into an error when adding the SSL certificate to the web services. When I ran the netsh http add sslcert, I received this error:

Error adding certificate to web services

SSL Certificate add failed, Error: 1312

A specified logon session does not exist. It may already have been terminated.

I’ve not seen this error before, so some investigation was in order. As part of the project, I had provided pre-requisites to the client who had forwarded them into their IT partner to sort out. I discovered that when they added the SSL certificate they had, perhaps not unreasonably, added it to the WebHosting certificate store, but it needed to be in the Personal store.

Once the certificate had been moved, I was able to add the certificate to web services and continue with the configuration.

One item I did flag to the client, is that people wanting to do an approval on a mobile (cell) phone, is that it will not work on Android Chrome as this has retired TLS 1.0 and all of the main browsers will be following suite very soon. While I expect Microsoft to provide a fix for this, an upgrade of Microsoft Dynamics GP will most likely be required.

The client is keeping this under review and may opt to purchase the PurchaseHQ GP Elementz Portal from ISC Software which allows for secure access via an Azurehosted portal with full Microsoft Dynamics GP Workflow integration for document approvals of all Purchasing series workflows.

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.

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