August 2014 archive

Bulk Inserts – Dynamics NAV

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 …

Continue reading

Using the Quick Filter in Microsoft Dynamics NAV

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 …

Continue reading

Advantages of using Microsoft Dynamics NAV development environment in creating a Database

In this blog post I will not be discussing about the process of creating a NAV DB. In here I will be discussing about the advantages of using Microsoft Dynamics NAV Development Environment in creating a DB. Microsoft has provided main 2 ways of creating a Dynamics NAV database in SQL server.  1. Create the DB using …

Continue reading

Reset NAV 2013 or 2013 R2 security and settings

If it is required to delete users, user properties, debugger breakpoints or session event related info; then use following TSQL code. It simply delete the data from the tables directly and allow you to use the NAV as a fresh settings.  USE [YourNAVDatabase]; delete FROM [dbo].[Access Control]; delete FROM [dbo].[User]; delete FROM [dbo].[User Property]; delete …

Continue reading

HTML Tags and Microsoft Dynamics NAV 2013 Reports

It is annoying to change the report layouts according to customer requirements, because every time developer needs to open the design view and then go to layout in the Visual Studio.  What about giving the option to the customer to change the report presentation and the layout of the report. Does NAV directly allow that? No.  but …

Continue reading

Cumulative Update 17 for Microsoft Dynamics NAV 2013 and Cumulative Update 10 for Microsoft Dynamics NAV 2013 R2 has been released.

Please use the following link to download and read about the new release of Microsoft Dynamics NAV 2013. NAV 2013Please use the following link to download and read about the new release of Microsoft Dynamics NAV 2013 R2. NAV 2013 R2Thank you and Regards,Tharanga Chandrasekara. 

Elimination of Certification – MPN Silver/Gold Competency requirements – Dynamics NAV

Effective from August 13, 2014, all the certifications and assessments for the Dynamics NAV will no longer required to obtain  MPN Silver/Gold Competency. This includes pre-sales and sales assessment as well as the other implementation and technical certifications.  Following are the competency requirements, Minimum revenue requirements for SPA Minimum revenue and BREP Revenue Recapture Rates for MPN ERP Gold …

Continue reading

Compatibility of SQL Server 2014 with NAV2013 and NAV2013R2

SQL Server 2014 is released earlier this year with many new and very interesting capabilities. I will get back to you all about that with a separate article and for now lets just focus on comparability of NAV and SQL.After testing the Microsoft Dynamics NAV with Microsoft SQL Server 2014, NAV team has finally confirmed …

Continue reading

CRETE – Microsoft Dynamics NAV 2015

CRETE According to the “waldo” Microsoft is going to launch Dynamics NAV 2015 also known as CRETE.  During the Convergence 2014 presentation in March, Microsoft committed to shipping yearly releases for NAV, beginning with NAV 2015. Following is the roadmap that Microsoft has presented According to the waldo this is a one major release and we …

Continue reading

How to setup default company for NAS ( NAV 2013 R2 )

In Microsoft Dynamics NAV 2013 Service Configuration Panel we can set the NAS Default company under the NAS Service tab. But with the new version this input box was missing and this is how it look like in the NAS Service tab. Default Company Text box is missing in 2013 R2 Configuration Panel!!  NAV 2013 R2 Service Configuration …

Continue reading