Category: Uncategorized

Microsoft Dynamics NAV 2015 is now allowed users to schedule the reports. With the use of report scheduling in NAS, user can achieve following, Schedule resource intensive reports at the time of less usage of the server Run reports on the NAV server (NAS), instead of the client (Client machine should not equipped with high end resources) Save…

This Cumulative Update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features that were released in previous Cumulative Updates.Cumulative Update Microsoft provides upgrade toolkit for NAV 2009 R2, NAV 2009 SP1 to NAV 2015You can download the cumulative update from KB 3013215  – Cumulative Update 1 for…

In this video I have demonstrate how to setup background posting using Job Queue for Sales in Microsoft Dynamics NAV 2013.  It is pretty simple, just follow the video..  Thank you and Regards,Tharanga Chandrasekara 

What is background posting : Very simply, you are passing your completed document to NAS server to do the posting for you.  What is the advantage of this : Since posting will happen in the background you will not have to face any screen freezing or will not have to tolerate the message of “Table is locked by another…

Following is the priority and the logic of how the “Match Automatically” function works in Bank Account Reconciliations in Dynamics NAV 2013 Priority Bank Statement Bank Account Ledger Comment 1 Statement Amount Remaining Amount Will match if the amounts are identical 2 Description Description,External Document No, Document No Will match if the description text is identical or almost…

If you have so many debugger breakpoints where you can’t go to each and disable then use this following TSQL code.  USE [NAVDatabase]; delete from dbo.[Debugger Breakpoint]; delete from dbo.[Session Event]; Thank you and Regards, Tharanga Chandrasekara 

Have you ever wondered how to extend Dynamics NAV RTC to a different level and how to add extra functionality to Dynamics NAV within its own framework ?? Take a look at below images. (Taken from MSDN) You can do this with the use of Control Add-in. Control Add-in allow you to extend RoleTailored client with custom functionality.…

On 24th September 2014 at Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a gathering for Microsoft Dynamics NAV users. During the discussion we introduces Dynamics NAV 2013 R2 and new features comparing with Dynamics NAV 2009. Existing clients were really excited about the new look of the NAV 2013 R2 and new features. They were really excited about the assembly management and new dashboards of Dynamics NAV 2013…

On 25th September 2014 at 8 Degrees North, Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a cocktail evening for new prospects. During the gathering we introduces Dynamics NAV 2013 R2 to invitees and had a wonderful Q&A session with them. It was a great evening with lot of new chit chat about the product and everyone of them were…

ZILLIONe Business Solution Sri Lanka achieves another milestone by becoming the 1st ever Sri Lankan Microsoft Silver competency partner for ERP Proud to be a part of the journey! Thank you and Regards,Tharanga Chandrasekara

Even though client license says it is for 10 users there are some chances more than 10 users can access the system at the same time. I have faced this situation many times and we didn’t had a option to control No. of user loggins. To achieve and control the number of user loggins I have written a small…

I was reading Vjeko.com and I found this article about Length of the G/L account. May be you already know this and may be not. Therefore I thought to share it with you all again. In earlier versions of Dynamics NAV (before NAV 2013) default length of the G/L Account Name in the G/L Account table was…

If you want to kill a session by force then use following method. There are few other methods available to achieve the same output, but this is one of the easiest methods. 1. First open the Microsoft Dynamics NAV Development environment. 2. Open Object designer (Shift + F12)3. Go to Page 9506 (Session List)4. Create a new action and name…

Is there a way to shutdown SQL server without interrupting to existing users? Yes you can. I am sure you have opened Window Services or SQL Server configuration manager many times before. Have you ever notice that when you right click on the SQL Server it gives you 5 options. One of this options does the trick for…

Today one of our client complained that he can’t unapply a payment, at first we thought he was doing it wrong. So we remotely logged to their system and asked him to unapply the entry. Here comes the error.. To find the problem and a solution I started to surf. I found 2 fine articles and I have…

Below are the “How DO I” video links available on MSDN for  Microsoft Dynamics NAV 2013 R2 How Do I: Create a Web Service that is based on Account Schedule KPIs in Microsoft Dynamics NAV 2013 R2 How Do I: Import and Reconcile a Bank Statement in Microsoft Dynamics NAV 2013 R2 How Do I:…

There is a very easy method to check which objects are in our license range and which are not. Many will what normal do is, go to each object and then click design button. If design window gets open that means you have access to that particulate object and if it throws the below error message, that means your…

What is Cue and what is so special about them?During NAV 2009 if we ask the questions of what is a cue? Many of the people’s answer would be like ” Clickable colorless stacks of documents” If we ask the same question in 2013 R2 user their answer would like “Clickable blue tiles” Microsoft Dynamics NAV…

Yesterday I was going through various Dynamics NAV blogs and found a very interesting article about error handling. Over past few weeks I was planing to write a article about error handling and however it always got delayed due other topics came up with Microsoft Dynamics NAV 2015. After reading the article of VJEKO, I thought to write another article based on his findings.  Been…

If you are very new to Microsoft Dynamics NAV development this blog post will be a useful one. License file is required in order to do any activity in Microsoft Dynamics NAV. In this post I am going to discuss about how to change and upload a license file into a Database. You need to have a development license to do development…

Today been a Saturday and stuck at home due to heavy rain, I was reading various Dynamics NAV related blogs and published papers. Then I found this article of how to jump to a function and thought to share it. For the past few years I have never used this functionality during my programming. However it…

As from the day one of been a programmer it is advised to indent your code so that it is easy to read and easy to understand. In Microsoft Dynamics NAV Development Environment this feature is available and some of new developers does not know how to use this functionality. If you do not indent your code then it will look like below…

Microsoft Dynamics NAV 2015 comes as a collection of lot of small small modifications ( Advance features also there). One of the small features available in Dynamics NAV is commend and uncomment section of code. In previous versions what we used to do use is {} or // to  comment a section or line. With the use of {} we can comment…

Many of us including me, was wondering which object properties carry default values and which are not. Sometimes it is a huge pain for the developers and I have seen this with my team and how they really get annoyed with this.Every time may of us wished Microsoft will come up with a tool to compare…

If you want to check and use new Microsoft Dynamics NAV 2015 image library please go to below link and download image finder. It will allow you to view all the available Dynamics NAV 2015 images.  Thank you AJK (Arend-Jan Kauffmann)  for this awesome application. For more info please click here Link : http://www.mibuso.com/dlinfo.asp?FileID=1548Thank you and Regards,Tharanga Chandrasekara.

Today I was working with Microsoft Dynamics NAV 2015. I was developing a sub module and my plan was to create a codeunit and then call its function from a page I created. So I created a new codeunit and then created several functions. I didn’t change any default settings of functions.  Then I went…

This article describes the steps to download a Microsoft Dynamics NAV license file from CustomerSource.Overview To download a Microsoft Dynamics NAV license file from CustomerSource, follow these steps: Log in to CustomerSource. Click My Account Click Product & Service Summary Click Registration Keys Select the desired version in the Request and Display License KeysFor Version field. Click Display License Keys. On the Request License…

​This article describes how you can generate and download a partner development license for Microsoft Dynamics NAV.​Demo/Dev License Overview Demo/Dev user licenses are provided to Microsoft Dynamics SPA and Sales Affiliate partners. Microsoft does not charge for Demo/Dev user licenses; these licenses are provided free of charge under the Not for Resale Licensing Program (NFR).…

​This article describes how to download a customer’s Microsoft Dynamics NAV license file and permission report from PartnerSource Business Center To download a customer’s Microsoft Dynamics NAV license file from PartnerSource Business Center, follow these steps: Log on to PartnerSource Business Center.  Click Specific Customer Information. Enter search information in the Customer Lookup form to search for the customer, and then click Search. Click the Company…

With the Simplified UX of Microsoft Dynamics NAV 2015, Users can convert Sales Quote to a Sales Invoice with a click of a button. This means user does not have to go through sales order management features. This functionality is available for the Small Business Role Centers. ( If you want to add this to other…

Already there are enough number of blog posts available for this topic, however today I came across a similar scenario and though to write a blog post about it.  If you have opened NAV DB using SQL server, you might have noticed few special characters used in NAV database has been replaced in SQL side.  Let’s see which…

By Default Help Server get installed to server machine if you install the complete server installation of Microsoft Dynamics NAV 2013 or Microsoft Dynamics NAV 2013 R2, However in some cases during the help server installation, setup find that “Microsoft Search Service” is not available in the server and this result a error in the…

Today I was configuring a Windows Server 2012 R2 virtual machine to install Microsoft Dynamics NAV Server. Initial configuration setup went as planned and when I start the installation process of SQL Server 2012, following error pop up (after completing around 25%)  and it halt the Microsoft SQL Server installation process.  What is the reason…

Many users are very familiar with Microsoft Excel and do most of their reporting and calculations using Microsoft Excel. Even some of the users create dashboards using Microsoft Excel. What if we can provide Microsoft Dynamics NAV data as a data source for those reporting ?? Can this be achieved without using any advance features ? Yes! Did you knew that Microsoft Excel add-on…

Following are main guidelines in designing a report in Dynamics NAV 2013. By following a these guidelines following goals can be achieved. Simple and clean Easy to scan and read Professional and consistent There are three types of report templates in Microsoft Dynamics NAV Document Report – Formal outgoing reports. (Sales Invoice, Order confirmations) List…

Sometimes users complain that Microsoft Dynamics NAV user interface is not much user friendly and it does not support the user tasks. However with the previous release (Dynamics NAV 2013, Dynamics NAV 2013 R2) Microsoft has focused lot about their UI design. In order to provide more user friendliness, Microsoft has introduce 4 new features…

Microsoft Dynamics NAV 2015 now working with iPad, Android, which allows users in small and midsize business to get access to the data they need from the device they prefer.   With the fresh and modern interface, it provide the familiar RoleTailored experience so that users can get real work done at home, at work…

New feature will  enable user to send a attachment by email from Dynamics NAV. Out of the box this functionality is added to 15+ pages and action is promoted. Option is enabled to Sales Invoice, Sales Credit Memo, Sales Orders, Sales Quotes and also for posted documents. This uses report selection to look-up and generate the…

Can a user design the report layout as he/she wants?? NO!. Now you can.. With the new Microsoft Dynamics NAV 2015 release, Microsoft has enabled the functionality. In previous versions of Microsoft Dynamics NAV, you can only design the report layout by using Visual Studio Report Designer or MS SQL Server Report Builder. But with the…

Waiting is over.. Finally Microsoft has enable the download. Please follow the below link to download Microsoft Dynamics NAV 2015Download AU-Australia Download AT-Austria Download BE-Belgium Download CA-Canada Download DK-Denmark Download FI-Finland Download FR-France Download DE-Germany Download IS – Iceland Download IT-Italy Download MX-Mexico Download NL-Netherlands Download NZ-New Zealand Download NO-Norway Download ES-Spain Download SE-Sweden Download CH-Switzerland…

Microsoft has introduced the bulk insert functionality which will allow the developers to write high performance code. What is Bulk Insert : Microsoft Dynamics NAV automatically keep all the records in a buffer and then send them to Microsoft SQL server at a one time. Before this modification, insert happen in the order of the C/AL code running and…

With the introduction of Microsoft Dynamics NAV 2013, Microsoft had changed the Quick filter functionality and this blog post is a summarize version of the article published in the blogs.msdn and to read the complete blog post please refer the original article by Mictosoft NAV team ( to link please scroll to the bottom of the post).The following table illustrates more Quick Filter search…