We were hearing about Dynamics NAV 2017 since long time that it will be releasing by the end of 2016 which will be coming up with further integration of office 365 and few many more interesting features (called project Madeira).Yes, now Microsoft has released the beta version of NAV 2017. Here is the brief description about the road Map of NAV 2017 release                          Fig 1. Shows roadmap of Microsoft Dynamics NAV...

We are all learning new things about RDLC report design and we know that still there are lot of things to learn about, here are the things I’m sharing which I learned.       1.  How to make page Header and Footer as dynamic.       2.  How to print page Footer on last page only.       3.  How to remove empty/blank rows in grouping.       4.  How to print TransHeader and TransFooter in RDLC re...

 In this post we will move to next step, and there we will go through two more data item grouping.For example: Here we will list Customer Ledger entries by Customer, then Customers by Salespersons. So we will get all customers for each salesperson and ledger entries for each customer that is done by using Salesperson, Customer, and Customer Ledger Entries data items.In my previous blog I briefly explained how to add a parent and child group and how it has displayed list of customers by sale...

You may want to add custom code to the RDLC report to do more actions than what's already provided with the report functions. So it gives you a base for extending your report functionalities which can’t programmed in NAV report design environment. You may want to add custom code to implement simple string manipulation task or sophisticated data access manipulation. So you can add custom functions to RDLC report and add references to functions in report controls. When the report is comp...

Explains how to build online help pages in bulk for 2013 R2 version of NAV using merge tool. It includes detail of creating content from an excel sheet to building online (HTML) pages in bulk using Merge tool.The following are the steps which will be followed to build online help pages.1. Firstly we need to write contents in an excel sheet with table number and name, field number and content (or description) of the online help. Once the excel file is ready, we need to prepare the contents writte...

What is RDLC Report?The Report Definition Language (RDL) Data is a report component that is used by Microsoft Dynamics NAV to display the report in the Role Tailored client. Microsoft Visual Studio Report Designer is an external designer that is used to design the visual element (the RDL data) of a report. It is accessed from the Report Dataset Designer.With the help of RDLC reports we can easily export the report result into Excel, PDF and Word formats. We can have interactive sorting, add link...

Online help page is a web page which displays information in a web browser when user presses the key F1 for the selected field or page in MS Dynamics NAV 2013 R2.In this blog I will try to document the process of creating online help page for Microsoft Dynamics NAV 2013 R2 version, from creating online help topic to building the complied (html) help page and also how to integrate the help page into your project.Prerequisites:   ·    Microsoft Dynamics NAV 2013 R2 with ...

Query is a new object in Microsoft Dynamics NAV 2013 that a programmer can use to define a set of data from the Microsoft Dynamics NAV database. Users can query the database to retrieve field’s information stored in the database from a single table or multiple tables using table relation. You can specify how to join tables in the query where you can define filter criteria to get the desired results. You can specify totalling methods on fields, such as sums and averages.Query helps us to im...