D365 FO - Send Email with attachments by X++

Go to System administration >> Setup >> Email >> System email templates

Create New template

[ExtensionOf(classStr(PurchConfirmationJournalPost))]

final class PurchConfirmationJournalPost_TraxSCM_Extension

{

public str CCEmail, Esender;

public void Sendmail()

{

try

{

str vendname = purchTable::find(this.vendPurchOrderJour.purchid).vendorName();

str Purchid = this.vendPurchOrderJour.purchid;

str sUserId;

sUserId = curUserId();

//Getting Email id from User Options --> Account --> Email Provider --> Email id

str userEmail = SysUserInfo::find(sUserId, false).Email;

var builder = new SysMailerMessageBuilder();

builder.setBody(this.Email_Body());

builder.setFrom(userEmail,Esender);

builder.addcc(ccEmail);

builder.addTo("[email protected]");

builder.setSubject("subject string");

//************

System.IO.Stream stream = this.generateReportStream(); // todo insert record reference

if(stream)

builder.addAttachment(stream,vendname +" - "+Purchid+".pdf");

var message = builder.getMessage();

SysMailerFactory::getNonInteractiveMailer().sendNonInteractive(message);

}

catch (Exception::Error)

{

throw error("@SYS33567");

}

public str Email_Body()

{

str vendname = purchTable::find(this.vendPurchOrderJour.purchid).vendorName();

str Purchid = this.vendPurchOrderJour.purchid;

str sub,tmp,Sender,frm,cc;

[sub,tmp,Sender,frm,cc] = this.getEmailTemplate('POConfirm','en-us');

Esender = sender;

tmp = strReplace(tmp,'%vend%','%1');

tmp = strReplace(tmp,'%purchid%','%2');

str ret = strFmt(tmp,vendname,Purchid);

return ret;

}

public System.IO.MemoryStream generateReportStream()

{

DocuRef addedRecord;

VendPurchOrderJour VendPurchOrderJour = this.vendPurchOrderJour;

Filename fileName = "Report.pdf";

PurchPurchaseOrderController controller = new PurchPurchaseOrderController();

PurchPurchaseOrderContract contract = new PurchPurchaseOrderContract();

SRSPrintDestinationSettings settings;

Array arrayFiles;

System.Byte[] reportBytes = new System.Byte[0]();

SRSProxy srsProxy;

SRSReportRunService srsReportRunService = new SrsReportRunService();

Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;

Map reportParametersMap;

SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();

System.IO.MemoryStream stream;

Args args = new Args(); ;

args.record(VendPurchOrderJour);

contract.parmRecordId(VendPurchOrderJour.RecId);

controller.parmArgs(args);

controller.parmReportName(ssrsReportStr(PurchPurchaseOrder, Report));

controller.parmShowDialog(false);

controller.parmReportContract().parmRdpContract(contract);

settings = controller.parmReportContract().parmPrintSettings();

settings.printMediumType(SRSPrintMediumType::File);

settings.fileName(fileName);

settings.fileFormat(SRSReportFileFormat::PDF);

controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());

controller.parmReportContract().parmReportExecutionInfo(executionInfo);

srsReportRunService.getReportDataContract(controller.parmreportcontract().parmReportName());

srsReportRunService.preRunReport(controller.parmreportcontract());

reportParametersMap = srsReportRunService.createParamMapFromContract(controller.parmReportContract());

parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);

srsProxy = SRSProxy::constructWithConfiguration(controller.parmReportContract().parmReportServerConfig());

reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),

parameterValueArray,

settings.fileFormat(),

settings.deviceinfo());

if (reportBytes)

{

stream = new System.IO.MemoryStream(reportBytes);

}

return stream;

}

Published on: November 30, 2023

Learn more

Sherif Fayed

Part-10: Create your Custom Agent for D365 F&O[Chart of Account Agent]

Enough talk. Let’s see Copilot Studio in action. Over the weekend, I built something powerful – a custom AI agent for Microsoft Dynamics 365 F...

15 hours ago

New Approved Customer List mapping for Items in Dynamics 365 Finance and operations

Take control of your sales process with the latest feature in Microsoft Dynamics 365 Finance – the Approved Customer List! This powerful new f...

16 days ago

Part-9: Connect and Query Dynamics 365 Finance and operations data with Copilot studio

In this video, we kick off an exciting new series focused on extending Copilot Studio capabilities by connecting it to real enterprise data! �...

16 days ago

Adding Custom Fields to Dynamics 365 Finance & Operations Forms

29 days ago

How to Create Deep Links to D365 F&O Records with Dataverse Virtual Tables

It is a common requirement for SaaS platform that exposes form over data to be able to share a secure link (a.k.a. Deep Link) to access a give...

3 months ago

Simplifying License Management for Dynamics 365 Finance and Operations: Improved User License Validation

Starting April 30th, Dynamics 365 administrators will gain access to new license usage reporting tools, centralizing user license management. ...

3 months ago

D365FO Integration: Import Sales Orders from an External Web Application

Learn how to implement robust and efficient process to import complex documents into Dynamics 365 Finance and Operations from external Web ser...

4 months ago

Practical Hints for Technical Management of D365FO Go-Live

In this post, I share practical insights from my experience managing the technical side of Go-Live for D365FO projects, focusing on key activi...

9 months ago

Blog image

Sherif Fayed

Learn more

D365 FO - Send Email with attachments by X++

Related posts