Friday, January 20, 2017

Import a File and Export it as a ZIP file in NAV 2017

Hi guys,

I did some R&D on the File Management codeunit (419) which is available in NAV and found out that it has pretty much all the functions related to files available in it.

For example: For zipping a file, we no longer need third party software to do the job for us in NAV.

Like this, there are many more functions available in this codeunit which we can use to our advantage and play with 'em. I have used some of the functions in an example which I will demonstrate below,

Before starting, I want you to know that this post is not limited to just importing and zipping a file. I want to show you the ability of codeunit 419 and the functions available in it. I have used a couple of them in my code.

Thursday, January 19, 2017

Set filter in report using Text variable in NAV - Tips, Tricks & Facts #10

Hello everyone, It's been a month since I have written any post. Well, sometimes the work is just as much to occupy all your time that you barely get time to do other stuff.

The complete title of this post must be "Set filter in report using Text variable in which the user can use .. (aka range) and | (aka separator) in NAV" but never mind. 😉

I encountered this situation where I wanted to set filter on the report's dataitem using a text variable. So, I asked this question in some forums and got the answer which helped me resolve my problem and I want to share it with you guys too!

Tuesday, December 20, 2016

MS has announced the Preview of Development Tools for Dynamics NAV

Hey guys, the preview of Development tools is here. Check the full post by Microsoft here.

Another cool post by Mohana which has detailed steps on how to get started.

I am following these links and getting myself started on this preview.

Also check this MSDN link for more help!

Please share the knowledge you gather about this preview in comments!

Thank youuu!

Monday, December 19, 2016

More about Developer Preview for NAV

Hi guys, Merry Christmas 😊 and wish you all a very Happy New Year 2017in advance. I really feel that this blog has connected me to a lot of individuals and I want to thank each and every one of you for all the support you have shown and  for the kind words of whoever has expressed their thoughts with comments.

So, Dynamics NAV Team Blog has recently blogged about what should we know about the new things coming our way!
  • Soon Microsoft will make an Azure Gallery image available that contains the product and tools to start learning about what we call Extensions 2.0.
  • Extensions 2.0 is the name Microsoft will use for the new versions of extensions – ones that aren’t based on the DELTA file design.
  • Making extensions with the new tools is much easier than the current tools suite you may be familiar with.
  •  We’ll be using Table Extension and Page Extension objects to describe new fields and UI elements.

My major take-away from this post of Microsoft :

Sunday, December 18, 2016

Difference between RESET and CLEAR - Tips, Tricks & Facts #9

Hi guys,

As it is pretty clear from the heading, I am going to compare rec.RESET and CLEAR(rec) in this post.

We are aware of the fact that CLEAR function is used to clear variables of all types. I am going to stick to how does CLEAR work with record type variables for this post.

Friday, December 09, 2016

Cumulative Update 1 for Microsoft Dynamics NAV 2017 (Build 14199)

Cumulative Update 01 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:
  •   AU – Australia
  •   AT – Austria
  •   BE – Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE – Germany
  •   DK – Denmark
  •   ES – Spain
  •   FI  – Finland
  •   FR – France
  •   IS – Iceland
  •   IT – Italy
  •   NA – North America
  •   NL – Netherlands
  •   NO – Norway
  •   NZ – New Zealand
  •   RU – Russia
  •   SE – Sweden
  •   UK – United Kingdom


Where to find Cumulative Update 01

You can download the cumulative update from KB 3209071 – Cumulative Update 01 for Microsoft Dynamics NAV 2017 (Build 14199).
Or you can download the cumulative update from the Microsoft Download Center.


Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2017 Cumulative Update.

Post Source: Microsoft

Download & Install the update & Keep Learning! :) 

Sunday, December 04, 2016

Common mistakes we make in C/AL - Vol. 3 - Tips, Tricks & Facts #8

In this post I will talk about Significance of Using CALCSUMS in C/AL coding. 

Before writing about this topic I would mention here that, if a tool (or function) is available then we must use it to our system's benefit. Tools or functions are available in AL (or any other development envo.) to reduce the time taken by transactions and faster output generation.

You can find the detailed definition of CALCSUMS on MSDN. This function must be used to calculate sums of a Decimal field. However, the scope of CALCSUMS has been widened to Integer, BigInteger and Duration type fields along with Decimal type fields from NAV 2016 and up.

Sunday, November 13, 2016

Common mistakes we make in C/AL - Vol. 1 - Tips, Tricks & Facts #6

Hi peeps, starting a new series of posts on what are the common mistakes made by developers like us which have bad, sometimes worse, impacts on database transactions. And what the kind of coding styles we must avoid to keep the code neat and clean. And what are the DO's and DON'T's for writing C/AL code.

We gotta remember that we are not the last developers who will write a particular code somewhere in the NAV objects. There will be more developers after us who will be carrying the torch and some of them might run into some code which was written by us.

Therefore, your code must better be understandable and optimized!

Friday, November 04, 2016

Code changes - NAV 2016 to NAV 2017 - Tips, Tricks & Facts #5

Hi guys, I am gonna talk about the code changes that I liked in NAV 2017 and you must know about them too.

Coding in NAV 2017 is better, as expected.

Just to give an overview. I will cover some examples as follows,

1. Codeunit 80 - OnRun Trigger - This trigger used to be a home of like more than a thousand lines of code. Well now, it has been decreased to a hundred lines of code, give or take. Check the image below,

Wednesday, November 02, 2016

Dynamics NAV 2017: Changes in the Core Application and Platform

Enhancements in sales order processes
Dynamics NAV 2016 introduced Dynamics CRM Integration that enables an optimal and seamless experience for our customers in the lead-to-cash process when they are utilizing Dynamics CRM for customer engagement and Dynamics NAV for order processing and financials.
In Dynamics NAV 2017, you can now synchronize assembly items and bill-of-material items (BOMs) to Dynamics CRM as CRM products without price.
The sales person in Dynamics CRM can now use the price lists from Dynamics NAV while creating a sales order. When they add the item to the sales order line in Dynamics CRM, they are also able to see the inventory level (availablity) of the item from Dynamics NAV. A new wizard “Dynamics CRM Connection Setup”, will publish Item Availablity Webservice as a part of the Assisted Setup that enables this scenario.