Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to Customise Workflow Email Template In NAV 2018

(0) ShareShare
ReportReport
Posted on by 240

Hi, All

I create Customize workflow for Req. Worksheet Page. But I have an issue of "Workflow Request on Email" it showing the "Line no of the table "Requisition Line (246)". I didn't find out how he gets the line of the workflow email template.

7115.5.png

I want to insert Item no, Qty and Amount in Email Workflow Template. 

Please Help me Out that Issue.

Thanks in Advance.

*This post is locked for comments

  • NeoMatrix Profile Picture
    NeoMatrix 240 on at
    RE: How to Customise Workflow Email Template In NAV 2018

    Thanks for Reply. It works fine. it shows Like

    2844.1.PNG

    I have written code for above like

      DATABASE::"Requisition Line":
        BEGIN
         DocumentType := RecRef.CAPTION;
          FieldRef  := RecRef.FIELD(50003);
          DocumentNo  := FORMAT(FieldRef.VALUE);
          FieldRef  := RecRef.FIELD(6);
          DocumentNo +=','+' Item :'+FORMAT(FieldRef.VALUE);
          FieldRef  := RecRef.FIELD(10);
          DocumentNo +=',Cost :'+FORMAT(FieldRef.VALUE);
         END;

    But I want to Print like That as standard shown as below image

    2844.1.PNG

    where am I going to Put the code for this?

  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,594 on at
    RE: How to Customise Workflow Email Template In NAV 2018

    You need to custom for this. Inside codeunit 1510 "Notification Management" inside function "GetDocumentTypeAndNumber" , add following code inside the switch statement :

      DATABASE::"Requisition Line":
        BEGIN
          DocumentType := RecRef.CAPTION;
          FieldRef := RecRef.FIELD(5); //ItemNo Field Id
          DocumentNo := FORMAT(FieldRef.VALUE);
          FieldRef := RecRef.FIELD(10); //Direct Unit Cost Field Id
          DocumentNo += ',' + FORMAT(FieldRef.VALUE);
        END;


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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans