Hands on with the Microsoft Dynamics GP Fall 2020 Release: Securing the Web Services for external access

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.

When using the Web Services for Microsoft Dynamics GP with external access for Workflow approvals, it is important that the webs services be secured to minimise possible attack vectors. Everything covered in this series is required to install and configure the web services for internal use only

I covered the process for enable a secure connection for the web services a year or so ago which include a few extra steps:

Enabling Secure Connection for Web Services
Before You Begin
Update Certificate Binding
Update Bindings
Update Legacy Endpoint
Update Native Endpoint
Update GP Workflow Service
Final Service Configuration
Configure Workflow Setup

Click to show/hide the Hands on with the Microsoft Dynamics GP Fall 2020 Release Series Index

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Verify Web Services

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.

The final step with the Web Services, now that they have been configured, is to verify that they are working correctly.

There are three checks which I recommend when verifying the web services:

  1. Is the service running?
  2. Have the security objects been deployed?
  3. Are the endpoints working?

To check that the service account is running, open the Services applet from Computer Management (or hit Win+R and typeServices.msc) and make sure the Microsoft Dynamics GP Service Host is set to a Startup Type of Automatic and that the service is Running.

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Verify Web Services”

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Configure Web Services

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 Web Services installed, the next step is to configure them for use. If you marked the checkbox on the final step of the installation the Configuration Wizard will start automatically otherwise it can be started from the Windows Start menu. Click NExt to start the configuration:

Welcome to the Web Services for Microsoft Dynamics GP Configuration Wizard

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Configure Web Services”

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Install Web Services

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 Web Services for Microsoft Dynamics GP prerequisites ready, we can now install the web services. Launch the setup utility and, under the Additional Products heading, select Web Services Runtime:

Setup Utility

Continue reading “Hands on with the Microsoft Dynamics GP Fall 2020 Release: Install Web Services”

Hands on with the Microsoft Dynamics GP Fall 2020 Release: Web Service prerequisites

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.

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, but 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 the installation, this service should have local administrator permissions.

Thirdly, all companies which will have the Web Services deployed, needs to have a Functional Currency defined (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 the Microsoft Dynamics GP Fall 2020 Release Series Index

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”