Dynamics GP workflow email message troubleshooting

Posted by Shannon Mullins

Have you ever had an issue with an email workflow setup in Dynamics GP?

​If so, keep reading.

I ran into an issue recently where the tests emails for workflow were generating just fine. However, once workflow was turned on and activated, no emails were being sent to the approvers or submitters. I ran through the usual suspects - enabling workflow emails in the workflow set-up, making sure managers were assigned to each step, ensuring each active directory account had an email associated with it - but still I had no luck.
​
After a brief session with Microsoft support, it was determined that with the most recent version of GP 2015 R2, workflow email status in DYNAMICS table SY04901 were set to default the email message type to a 1, meaning no emails were to be generated. The steps below fixed this issue and emails began to flow!

Steps to enable workflow messages

1. Make sure to have a backup of the company database
2. Run the following SQL script against the company first:
   Updated SY04901 set Email_Message_Type=2
3. Then run the following script second:
   Update SY04901 set Email_Message_Type=3 where EmailMessageID='WF ACTION COMPLETED*'
4. Submit your test workflow requests and see if messages are being sent
5. Enjoy your success

​

Interested in Hands-On Training?