Category: GP (Great Plains)

I recently helped a client secure the connection for the Web Services for Microsoft Dynamics GP. I sent over the prerequisites for ports, certificates and so on in advance.

When I came to binding the certificate I received an error (which I have seen before):

In the previous post, the issue was that the certificate had been installed in the WebHosting store instead of the Personal one, so I checked this first. The certificate was in the correct store so it was not the same issue.

I did some investigation and eventually found that when I tried to export the certificate, I didn’t have an option to export the private key:

The certificate can be exported with the private key if the private key was imported originally, and the private key needs to be present for the certificate to be bound. The solution was to delete the certificate and reimport with the private key.

In the last post, I posted a script to find which Microsoft Dynamics GP company databases had web services enabled. Todays script is a related one; it can be used to change the web services server location in all companies.

This script was created so once a live system was copied to a standalone test system, the web services server can easily be updated to the test server.

The highlighted section is the new server location which should be set:

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = STUFF((
					SELECT
						CHAR(13)
							+ 'UPDATE
								WF
							SET
								Web_Service_Server = ''test.example.co.uk''
							FROM
								' + INTERID + '.dbo.WF00100 AS WF'
					FROM
						DYNAMICS.dbo.SY01500
					FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')

EXEC sys.sp_executesql @SQL

I was doing an upgrade for a client the other day and ran some scripts to remove the web services SQL objects as part of the upgrade (I always find that an upgrade of the Web Services for Microsoft Dynamics GP doesn’t work very well, so it’s a quicker and better option to remove and reinstall.

As part of the reinstall I needed to deploy them to the companies to which they had previously been deployed; I wasn’t sure which companies this was, but I did know that the client had web services for workflow actions enabled in all of them. The script below was my way of finding which databases had the email actions enabled.

The script will is run against the system database and will select from all company databases returning the INTERID and web services server field.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = STUFF((
					SELECT
						CHAR(13)
							+ 'SELECT ''' + INTERID + ''' AS INTERID, Web_Service_Server
							FROM
								' + INTERID + '.dbo.WF00100 AS WF
							WHERE
								EnableWFNotifService = 1'
					FROM
						DYNAMICS.dbo.SY01500
					FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')

EXEC sys.sp_executesql @SQL

In our most recent webinar, we took a look at SmartList Tips And Tricks. In this webinar, we took a look at how you can get the most out of the Microsoft Dynamics GP SmartList reporting tool. If you want to catch up on this, or any other, webinar, you can do so here.

1. Introduction
2. Roadmap
   • Dynamics GP Ideas
3. Upgrade Process
4. New functionality
   • System Enhancements
   • Financial Enhancements
   • Distribution Enhancements
   • Project Enhancements
5. Conclusion

Continue reading “Recent ISC Software Webinar: What’s New in Microsoft Dynamics GP Fall 2021 Release​”