Tags: D365FO, Free Edition, Placeholders, Print destinations 
No matter if you are using Docentric AX Free Edition or the full product version, you can use Standard and Custom placeholders in your print destination settings such as Email body, Email attachment name, Email subject, File output name, Azure blob storage container name, etc.
Let’s say that you want to use Sales ID and Customer Name in your Email body when emailing the Sales order confirmation report.
You can achieve this by using “dynamic” Standard placeholders including @FIELD_XXX@ and @METHOD_XXX@. There is also @PARAMETER_XXX@ that can be bound to a report parameter (e.g. @PARAMETER_DocumentTitle).
These are fields and display methods from the context execution record of an executing report, which is a record from the CustConfirmJour table in case of the Sales order confirmation report.
There is one limitation with this approach though. If you run the report from the Sales order confirmation form (the journal form), then everything works fine. But if you run the report from the Confirm sales order form (the posting form), this will not work, because the corresponding journal record is not created yet.
To overcome this problem, we will introduce Custom placeholders for this report. In order to do so, we need to register this report in Docentric report setup, to create a custom Docentric DSP (Data source provider) class for this report, and assign it to the report in Docentric report setup.
In Visual Studio create a new class with the following implementation:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
class DocSalesConfirmDSP_CustomPlaceholders extends DocDataSourceProviderSrsReporting { SalesTable salesTable; public ClassDescription description() { return 'Sales Confirm DSP for Placeholders'; } protected void onSelectedRdpTableRecord(Common _rdpTableRecord, TableName _rdpTableName) { super(_rdpTableRecord, _rdpTableName); if (_rdpTableName == tableStr(SalesConfirmHeaderTmp)) { SalesConfirmHeaderTmp header = _rdpTableRecord; salesTable = SalesTable::find(header.SalesId); } } [DocPlaceholderAttribute('SalesId', 'SO - Sales ID'), DocPlaceholderAttribute('CustAccount', 'SO - Customer Account ID'), DocPlaceholderAttribute('CustName', 'SO - Customer Name'), DocPlaceholderAttribute('CustContactName', 'SO - Customer Contact Name')] public DocPlaceholderManager overrideReportRunSettings(DocReportRunContext _reportRunContext, boolean _replaceStandardPlaceholders = true) { // List of defined custom placeholders for the report: #define.SalesId('SalesId') #define.CustAccount('CustAccount') #define.CustName('CustName') #define.CustContactName('CustContactName') DocPlaceholderManager placeholderMng = super(_reportRunContext, _replaceStandardPlaceholders); // -- Placeholder @SalesId@ placeholderMng.replacePlaceholderInCurrentPrintDest(#SalesId, salesTable.SalesId); // -- Placeholder @CustAccount@ placeholderMng.replacePlaceholderInCurrentPrintDest(#CustAccount, salesTable.CustAccount); // -- Placeholder @CustName@ str customerName = salesTable.customerName(); placeholderMng.replacePlaceholderInCurrentPrintDest(#CustName, customerName); // -- Placeholder @CustContactName@ str custContactPersonName = salesTable.contactPersonName(); if (!custContactPersonName) { custContactPersonName = 'Dear Mr./Mrs.'; } placeholderMng.replacePlaceholderInCurrentPrintDest(#CustContactName, custContactPersonName); return placeholderMng; } } |
Notice that this way we have defined four custom placeholders:
- SalesId
- CustAccount
- CustName
- CustContactName
Build your class and start D365FO. Navigate to Organization administration -> Docentric AX -> Reports and open the Docentric report setup form. Register Sales order confirmation (i.e. the corresponding SalesConfirm.Report SSRS report design) as Docentric report. Turn on the Use only print destinations flag.
In the Data source provider class tab in Docentric report setup select the created DocSalesConfirmDSP_CustomPlaceholders class.
Navigate to Accounts receivable -> Setup -> Forms -> Form setup and open Print management setup. For the Sales order confirmation report set up the Email print destination settings as following.
When you click the Use print management button on the Sales order confirmations form, the email is sent to those customer's contacts of type Email, which has the Business purpose assigned.
See also
Read more about Email's Purposes >>
Learn more about Custom placeholders >>
Learn more about Standard placeholders >>