Disable Workflow SharePoint in Dynamics GP

We recently ran into an issue with Dynamics GP that took us some time to figure out the solution for. But we did, so now we’re sharing it with our lucky blog readers in case you run into this problem as well!

Problem

The client is currently using Workflow 2.0 but had Workflow for SharePoint previously setup. Out of the blue, the SharePoint Workflow started acting up. The workflow messages were showing up on windows they didn’t have setup in Workflow 2.0, but the messages were appearing on the vendor maintenance card and payables batch entry.  This caused a work stoppage because they couldn’t save or post anything, due to the workflow message.

Solution

You can disable it in the Workflow for SharePoint setup window. Tools > Setup > Workflow for SharePoint by simply unchecking the Activate checkbox. If you can’t disable it there, then run the following script in SQL to disable it. Change TWO to the name of your company database you want to disable it in:

UPDATE DYNAMICS..SY01500 SET WORKFLOWENABLED = 0 WHERE INTERID = ‘TWO’

Prior to running the script, have everyone log out of GP, then log back in.  Be sure you have a SQL database backup before trying this!

If you have any questions about Microsoft Dynamics GP, please contact us and we’d be happy to help you!

Webinar - Dynamics GP Coffee Break | Maintenance of SOP Tables

Find out what happens in SOP to cause orphan records, and why we care. Learn about removing these transactions and how that affects inventory allocations.

December 12
9:00 am – 9:25 am PST

Register Here

Webinar - Maintenance of SOP Tables in GP

Dec. 12
9:00 am – 9:25 am PST

Register