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.
I want to insert Item no, Qty and Amount in Email Workflow Template.
Please Help me Out that Issue.
Thanks in Advance.
Thanks for Reply. It works fine. it shows Like
I have written code for above like
Share
Report
All responses (
Answers (
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
where am I going to Put the code for this?
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;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148