tracking code
LBMC Technology Solutions
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • Sage Intacct
    • Document Management (ECM)
    • Network Engineering and IT Solutions >
      • IT Security
      • Managed IT
      • Business Phone Systems
  • Events
    • All Upcoming Events
    • Training / CPE
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • On-Demand Webinars
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Partner with Us
    • Community
    • Contact Us

Dynamics GP workflow email message troubleshooting

12/28/2015

 
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?

Comments are closed.


    Blog

    ​Your one stop shop for technology.

    Categories

    All
    Business Central
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM
​Sage Intacct
​
Network Engineering

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
User Conferences
Training / CPE
Vision
Webinars & Workshops
​

Resources
Blog
Forum
Referral Program
​​YouTube Channel

Company
About Us
Careers
Contact Us
​
Locations
Charlotte
Knoxville
Nashville
Picture
Picture
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

LBMC Technology Solutions