Skip to main content

Microsoft Dynamics NAV 2017 - Email From NAV Part 2.

Hi Readers,

Continuing Email From NAV Part 1.

Today I would like to discuss a simple feature that Microsoft introduced in standard NAV for developing word Layout for a Report.

We will use this article in next part.

The Pattern in Developed and Enhanced from Microsoft starting NAV 2015. In today's article, we will discuss how to develop a simple word layout for Report - 208 Sales Shipment Report.

Your comments are awaited for future articles.

1. Open Custom Report Layout.

Navigate to Departments/Administration/IT Administration/Reports.
Click New, and Enter Details as - Report ID - 208 and Set Insert Word Layout To True.


Edit List and Rename the New Record Created as "Shipment Word Layout"

2. Edit Word Layout.

Select the Newly created Record in Custom Report Layout and select Edit Layout from the action Ribbon.



Action will open Microsoft Word. If you don't have developer tab then refer here.

In Developer Tab Select XML Mapping Pane, and select Custom XML Part which ends with report id 208, as shown below.



3. Develop Word Layout for Report(As per your requirement)- 

Right Hand Panel will allow us to choose from fields that are part of Report Dataset in NAV. We will try to use most commonly used the component in word Layout. 

Added Static Text for the Shipment Email.


Added Mix of Static Text with Fields from NAV.



Insert a Table for Line Details. 
Insert a table with 3 column and 2 rows. Select Second Row and from XML Mapping selects the body component Node and add the Repeating component with Sales Shipment Line. 


Now add fields as required. Format table as you wish.


Add Footer with Image.
I would like to add company address and company information image from the dataset and then the fixed text.
Once you finalized the design of word layout, close the word file. The system will ask to import changes as shown below. Select Yes and Word Layout is developed for Report. 


You can create multiple word layout for any records. Prepare multiple reports layout and we will see in next post how we can use it.

What is the best of part of using word layout -
  1. You can create multiple word layout for a report.
  2. No more object licensing. 
  3. Developer license is not required to develop a word layout.
  4. Customers can create word layout without the involvement of NAV Partners. 

Your comments are awaited.
You can download the word layout created in this article from OneDrive.
File Name- Microsoft Dynamics NAV 2017  - #SauravNAV_Shipment_Word_Layout.docx
You can download the template and upload in the custom report layout.
Let me know your views.

Regards,
Saurav Dhyani

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.