Configure Workflows to Include PDF Attachments in Microsoft Dynamics AX 2012
Date: 01 May 2015
UXC Eclipse Chief Technology Officer, Ivan Cole, explains how to configure PDF Attachments in Email messages in Microsoft Dynamics AX 2012.
Date: 01 May 2015
UXC Eclipse Chief Technology Officer, Ivan Cole, explains how to configure PDF Attachments in Email messages in Microsoft Dynamics AX 2012.
In my previous blog explaining in detail how to configure eMail approvals via workflow messages we referenced a parameter to include email attachments in workflow email messages.
Using this feature you can configure your workflows to include PDF attachments from SSRS reports that exist in Dynamics AX. This blog entry will walk through the steps to configure PDF attachments to workflow messages.
Using this feature you can configure your workflows to include PDF attachments from SSRS reports that exist in Dynamics AX. This blog entry will walk through the steps to configure PDF attachments to workflow messages.
The good news is that once you have email approvals configured and working there are only a few additional things you need to configure in order to set what reports get attached to your workflow messages. The challenge however is making sure a report is available to print PRIOR to the document approval. The best example is the Purchase Order workflow.
When change tracking is turned on, purchase order documents cannot be printed until approved and confirmed. The report actually prints from the confirmation detail tables. This is a control mechanism to prevent sending a printed PO to a vendor prior to appropriate approvals. This means that in order for a PDF attachment report to be included in a workflow email a custom AX SSRS report must be developed first that is not restricted by workflow status.
In this type of document example you would need to create a custom PO Workflow SSRS report so that details can be included in the attachments that are not available directly within the workflow message. Following are the steps to configure attachments in workflow email messages.
In our first example we will use the Expense Report SSRS Report. This example works out of the box since the Expense report can be printed from In-Review documents.
Workflow Parameters
In our previous blog we identified all of the steps to configure workflow emails for approvals using the Azure Service bus. Although they are not directly related if you want the ability to include embedded Approve/Reject hyperlinks within the emails enter the Service bus base URL that will relay the Approval or Rejection from the workflow message.
The message should be in the following format:
[Your Service Bus Name].servicebus.windows.net/[eMail Relay Name]
From the System Administration, Setup, workflow, Workflow parameters menu enter the service bus URL and check the box to Add Attachments.
Once the workflow parameters are setup there is only one more step in order to include the PDF report attachment. You can find the setup under System Administration, Windows Store, Windows Application Store Setup.
The windows application store setup window currently has only one menu on the left side windows pane for Approvals. To associate the workflow find the applicable table in the list. In our example we are navigating to and select the TrvDocumentApproval which is the Expense Report full document approval.
Next select the report association tab. This will allow the selection of an existing SSRS report available against that main table. Click the drop down list to select the TrvExpense report.
Once the report is selected we are ready to test the expense report workflow. We are using the standard workflow in the demo data setup, however we updated our Placeholders to include the Approve and Reject hyperlinks.
Batch Job Setup
In order to initiate the workflow, attach the related PDF if configured and send the email notification we need to setup three batch jobs. The first one is for workflow. For the purpose of this test we will simulate this using the Tutorial_WorkflowProcessor demo form. On the demo image you can navigate to Tools, Options, and Workflow Processor. Click start to begin the process.
Next you need to run the eMail Attachments batch job. This job searches for workflow that have attachments required and runs the report and links it to the workflow table pending the send. You must also run the eMail processing batch job so that the emails are sent from the workflows and alerts that are configured and ready to be processed.
Make sure to map your batch job to the email template that is configured for your workflow.
Once the Workflow Processor is running as well as the two batch jobs for eMail attachments and mail notifications are running we can submit an expense report to test this configuration.
Expense Report Submit and Test
You create and submit expense reports from Enterprise Portal Employee Services.
Create a new timesheet with a few lines for our test.
You will start to see notifications as the batch jobs pick up new workflow items to send.
You will then receive the email notification with the PDF Report as an attachment.
This is a standard email message and can be opened across multiple devices including iPhone, Android and Windows phones. And of course any email client.
Having the attachment available on the mobile device gives the reviewer more visibility into the details of the transaction without the need to login to the Dynamics AX rich client
Purchase Order Attachment Example
As mentioned in the beginning of this article in order to attach a PDF report to a Purchase Order workflow email a custom report must be developed. This is because the PO report cannot be printed until the PO is approved and confirmed, not before. There are specific customizations that must be made for a PO draft report to work. First we had to allow a PO draft report to print, independent of the workflow status.
Also, by default, the AX PDF workflow attachment feature only allows you to include a standard SSRS report based on a query. The purchase order printed form has a lot of advanced functionality such as charges and totals that are best calculated on the fly which makes using a query as the source impossible or highly impractical. To make this work a custom data provider was developed. We also needed to make a change to the system class the called the report attachment that would support launching the report using a custom data provider rather than a standard report based on a query.
The technical details behind how to make these modifications are not in scope for this article. However, anyone interested in this type of functionality should email us atinfo@uxceclipse.com.
To make using the report for testing simple we added a menu and button on the Purchase Orders list page for the draft report. You can see from this example it can print even though there is a Draft approval status.
The actual Purchase Order Print functions are grayed out since the PO is not yet approved and confirmed.
Once we submit the Purchase Order for approval, the same batch jobs are run to attach the Purchase Order to the email.
Conclusion
Implementing eMail approvals for workflow in Dynamics AX is now a native feature that is available to implement in an easy and low cost way without the need for third party additional add-on products. Understanding the functionality and installation steps will help make the implementation of this feature painless with the maximum benefit to AX users. Having up-front knowledge about the scenarios that require customized reports will empower Dynamics AX 2012 users with a broader scope of practical usage that greatly improves the Dynamics AX workflow user experience.