Sales invoice

This walkthrough provides an overview of how to send a notification to your business partner regarding an itemized statement of goods or services.

A sales invoice is an itemized statement of goods or services provided to a business partner, indicating the quantity and price of each product delivered.

Prerequisites

Story

This connection uses the following pipeline elements:

• The Record Change Event triggers on Insert and links to the internal document NM_SALESINV.TRIGG, which contains only one field: the No. field from the Sales Invoice Header table. When a new record inserts in the Sales Invoice Header table, the Record Change Event detects it.

• The XML Generator activity creates an XML file based on an internal document.

• The Splitter activity creates one message for each posted sales invoice.

• The XML Minifier activity cleans the message of empty nodes and blocks that are not mandatory.

• The message passes through the XMLSchemaValidator, which verifies that the XML message respects the internal document structure.

• The Header Mapper activity adds the headers to the message body, filling in the recipients and email subject.

• The XML to HTML Translator activity creates an HTML email message based on your branding templates. You can also configure an HTML body manually.

• The Attachment Generator activity adds attachments to the email message based on standard Microsoft Microsoft Dynamics 365 Business Central report functionality.

• The Email Writer endpoint sends the email.

• The internal document NM_SALESINV contains all the information needed to configure the XML Generator activity, the Splitter activity, the Header Mapper activity, and the XML to HTML Translator activity. Adding other fields to this document lets you define a personalized email message.

Setup

1. Import the NM_SALES.INVOICE.zip configuration package, or use the Business Integration Solutions template if available.

   

2. Add a new email account in Email Accounts, then select SMTP Account to send notifications via the Papercut SMTP server.

   

3. On the notification page, edit the EMAILWRITER and add the Account ID created in the previous step. Run the configuration once.

   

Process

1. Create a sales invoice with some details and post it.

2. Open notification NM_SALES.INVOICE and observe that the posted sales invoice header is captured by the Record Change Event activity.

3. Process the notification.

Result

The mail sends to all recipients. Using Papercut, the mail is captured in the demo environment, showing a preview of the HTML mail body and a PDF attachment of the Sales - Invoice report.

Note

For a brief guide, see Papercut SMTP setup.