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.

“The vendor has an existing purchase order…” error message when using Integration Manager

Microsoft Dynamics GPI’ve recently been working with a client to implement Microsoft Dynamics GP and have been using Integration Manager to import the opening data. While importing payables transactions I encountered the following error:

The vendor has an existing purchase order error

The vendor has an existing purchase order. Choose Continue to post or save. Choose Go To to view a purchasing navigation list. Choose Cancel to return to the window...

Continue reading ““The vendor has an existing purchase order…” error message when using Integration Manager”

Making Tax Digital Now Available in Dynamics GP 2016 and 2018

Microsoft Dynamics GPMicrosoft’s Jodi Christiansen has, on the Inside Microsoft Dynamics GP blog, announced the release of the January hotfix which includes the Making Tax Digital (MTD) updates required for VAT submissions to HMRC from April.

The Microsoft Docs site has been updated with setup instructions; I need to get it downloaded and installed to confirm the functionality, as all of the setup is around the VAT 100 and not VAT Daybook. Clients with more complex VAT often need VAT Daybook which allows them to define which tax codes appear in which boxes on the VAT Return. We’ve previously been assured by Microsoft that the MTD update would include both VAT 100 and VAT Daybook so I need to check that this is in fact the case.

The hotfix can be downloaded from CustomerSource (login required):

  1. Microsoft Dynamics GP 2016 lock
  2. Microsoft Dynamics GP 2018 lock

The MTD changes are only available for Microsoft Dynamics GP 2016 and 2018; applying the hotfix will update you to the latest version of the R2 release of these versions. If you’re on a prior version you will need to either upgrade to 2016 or 2018 or source an alternative way of submitting to MTD, such as ISC Software’s Making Tax Digital add-in.