Workflow in progress have been found in GP. These need to be processed before upgrading.

Microsoft Dynamics GPA colleague was recently performing an upgrade for a client to Microsoft Dynamics GP 2018 R2; this client had previously been a user of the old Dynamics Workflow module (now replaced with Workflow 2.0). They hadn’t used it for a while, but it had never been switched off resulted in the following message being displayed:

Upgrade error

Microsoft Dynamics GP Utilities

Workflows in progress have been found in GP. These need to be processed before upgrading. Please process these workflows before updating. A list of these workflows can be found in GPWorkflows.log

Workflows can be switched off from the front end, but with SQL Server Management studio already open, it was simple to run a SQL update statement against Company Master (SY01500):

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (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). */
UPDATE SY01500 SET WORKFLOWENABLED = 0 WHERE WORKFLOWENABLED = 1 GO