Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamics GP 2018 Workflow Error - Workflow Email fields displayed blank

Posted on by 270

Hi All,

In Dynamics GP 2018 environment, I have one company that I activate Workflow module on it. Using purchasing reacquisition approval, I can submit requisition without any issue and user can receiving email but without populating fields values as below:

Mail_5F00_Email.jpg Mail_5F00_Template.jpg

After investigation, I found that stored procedure, wfSubmit, that create submitting processing raises an error number 300.

Can anyone identify what this error number refer to?

Or provide any list for Workflow errors meaning?

Appreciate any help.

Yasser Mahmoud

Categories:
  • YasserMahmoud Profile Picture
    YasserMahmoud 270 on at
    RE: Dynamics GP 2018 Workflow Error - Workflow Email fields displayed blank

    Hi Justin,

    Thank you for your reply.

    The error raised from stored procedure as path wfSubmit \ wfCreateHistoryRecord \ Dynamics.dbo.SendWorkflowCompletionEmail. I run wfSubmit from SQL Management and error number appear as a result of variable, @Workflow_Error.

    Workflow History window has only the comments that entered when user submit or resubmit purchase requisition.

    I test submitting process with standard email message template and new message template that has only one field, Requisition Number, and same issue continues.

    I take your advice and create new message with only the actions, same error raised again.

    All our users use Outlook as default application for emails even in mobile devices. In testing environment, I use Outlook 2016 version for receiving emails. Email links work fine and I can approve or reject without any issue.

    I have another company in same environment and working fine without any issue or error. I can submit approval, receive email with populating fields values, and approve or reject PO requisition.

    Thanks!

    Yasser Mahmoud

  • Suggested answer
    RE: Dynamics GP 2018 Workflow Error - Workflow Email fields displayed blank

    Hello Yasser,

    Where are you seeing this error number?

    The wfSubmit proc doesn't have any error numbers within itself, it only gets errors from sub procs. There are tons of these sub procs, but I wasn't able to find this specific error from them.

    The first place to check would be to review the Workflow History window for one of these runs and see if any comments show. These are entered by the wfSubmit proc in response to errors.

    Second, sometimes we see where the messages get damaged if you move fields around in the messages. This may be the issue here, so what happens if you use the default message? What if you create a new message with only the actions?

    Past that, make sure you are using Outlook to open these emails. All other email programs can (and will) remove the links.

    community.dynamics.com/.../microsoft-dynamics-gp-workflow-2-0-email-links-being-removed-from-email-notifications-sent-to-approvers

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans