A 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:
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 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).
*/
UPDATE
SY01500
SET
WORKFLOWENABLED = 0
WHERE
WORKFLOWENABLED = 1
GO