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

[New Feature] Financial Consolidation Template in Microsoft Dynamics 365 Finance and Operations

🚀 New Feature Online Consolidation Template! 🚀 This feature streamlines the financial consolidation process and enhances the user experience...

1 day ago

[New Feature] Bank Account Lifecycle Management in Microsoft Dynamics 365 Finance and Operations

🚀 New Feature: Workflow approvals for Bank master! 🚀 Microsoft has recently added a new preview feature in Microsoft Dynamics 365 Finance an...

1 day ago

Business Performance Analytics in Microsoft Dynamics 365 Finance and Operations: Part-2

📢 Now Time to Business Performance Analytics in Microsoft Dynamics 365! Let’s dive into the various reports available in Business Perfo...

1 day ago

Business Performance Analytics in Microsoft Dynamics 365 Finance and Operations: Part-1

📢 Now Time to Business Performance Analytics in Microsoft Dynamics 365! While we focus on new developments around Copilot and AI, let’s...

1 day ago

Dual Currency Valuation/Reporting using Global Inventory Accounting in Microsoft Dynamics 365 Finance and Operations: Part-12

📢 Part-3: Now Time to Explore Global Inventory Accounting in Microsoft Dynamics 365! 🌍 Welcome to the next part of Global inventory accounti...

1 day ago

Sherif Fayed

Learn more

D365 FO - Send Email with attachments by X++

Related posts

[New Feature] Financial Consolidation Template in Microsoft Dynamics 365 Finance and Operations

[New Feature] Bank Account Lifecycle Management in Microsoft Dynamics 365 Finance and Operations

Business Performance Analytics in Microsoft Dynamics 365 Finance and Operations: Part-2

Business Performance Analytics in Microsoft Dynamics 365 Finance and Operations: Part-1

Dual Currency Valuation/Reporting using Global Inventory Accounting in Microsoft Dynamics 365 Finance and Operations: Part-12

Configure Reporting for Global Inventory Accounting in Microsoft Dynamics 365 Finance and Operations: Part-11

Global Inventory Accounting in Microsoft Dynamics 365 Finance and Operations: Part-10

How to Convert Transaction Currency Amount to Company Ledger Currency in D365FO

Beginners: D365 F&O and Power Apps Integration (2/5)