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.
*This post is locked for comments
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;
#1
André Arnaud de Cal...
291,419
Super User 2024 Season 2
#2
Martin Dráb
230,492
Most Valuable Professional
#3
nmaenpaa
101,156
