Year: 2022

When I do an upgrade of the Web Services For Microsoft Dynamics GP, my usual approach is to ru a two Microsoft supplied scripts which remove all web services objects from the system and company databases; I generally do this as we had problems with the upgrade process within the Configuration Wizard. On a recent upgrade I thought I would give the standard upgrade process aother try, as it is a few years since I last tried it.

When the Configuration Wizard was in progress, it stopped with the below error message:

The user account being used was the user account the Web Services had been running under since the last upgrade. I reverted back to running the scripts to remove the web services and then doing a fresh deployment of them. It looks like I will be sticking with this approach going forward.

A client reported a problem with some VBA customisations in Microsoft Dynamics GP where the code was stopping as if at a debug point in two places even thought there were no debug points present. Once a user hit F5 to continue the code past a “debug” point, they would not see the problem again until the next time they logged in.

I did a lot of investigation and fiddling around, but could not work out what the issue was.

Eventually, I used Customisation Maintenance to export the two problematic packages and then imported them again. When we tested, the problem had gone away.

I do not know what caused the problem, but it looks like even though there were no visible debug points there was something in the two files making Dynamics GP appear as if there was.

I’d be interested in hearing from anyone who has encountered this issue before and might be able to explain what was happening.

We have a project on the go to replace the VBA modifications, which are quite complex, so for this client the should only be a short term possibly of it reoccurring.

I worked on a Microsoft Dynamics GP upgrade project recently for a client who uses the old Adobe statement process. I am not all that familiar with this as most clients are now using the On Blank Paper statement and the standard emailing functionality. Once the upgrade was complete and we were doing some basic testing we encountered an error when trying to email the statements:

I did some digging around and found there is a path stored in the Dex.ini file for the e-mail status report:

EmailStatusPath=\\fileserver\Dynamics Central\EmailStatus\

This can be set through the client, but with a number of clients to update it was quicker to do by adding the line to the Dex.ini file.

I received an urgent call from a client early one morning a short time ago. All users logging into Microsoft Dynamics GP were receiving multiple errors across the system rendering it unusable.

The first reported error was displayed on login and encountered by all users:

Continue reading “Multiple Errors in Microsoft Dynamics GP”

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