Some links about NAV 2016 “Extensions”

Some links about NAV 2016 “Extensions”

extensions nav

from MSDN Online NAV Section

Extending Microsoft Dynamics NAV Using Extension Packages

Extension Packages Capability Support Matrix

Extensions “How-to” links
How to: Develop an Extension

How to: Create an Extension Package

How to: Publish and Install an Extension

Extensions Cmdlets
Development Cmdlets for Microsoft Dynamics NAV Extensions

Administration Cmdlets for Microsoft Dynamics NAV Extensions

NAV Team Blog

Introducing extensions in NAV 2016

Introducing Extensions in Microsoft Dynamics NAV 2016


Introduction to Eventing and Extensions in Dynamics NAV 2016

Microsoft Dynamics NAV 2016 Extensions Explained

How Do I: Create an Extension Package in Microsoft Dynamics NAV 2016

How Do I: Deploy and Manage Extensions in Microsoft Dynamics NAV 2016

…also some links about “Events”
Introducing Events

Best Practices with Microsoft Dynamics NAV Events

Walkthrough: Publishing, Raising, and Subcribing to an Event in Microsoft Dynamics NAV

Walkthrough: Implementing New Workflow Events and Responses

Integration Events in Microsoft Dynamics NAV 2016

Integration Events in Microsoft Dynamics NAV 2016

Introduction to Eventing and Extensions in Dynamics NAV 2016


SCM (Source Control Management) with NAV

SCM (Source Control Management) with NAV

do you need to use NAV with SCM (Source control Management) integration ?

…you can use two applications to reach this goal.

– Visual Studio Online (and team foundation server) (free for 5 users)

– GIT (free and open source)

You can find a script on codeplex for using GIT and NAV (integration with TFS and GIT) …. and Others nice free scripts at links below (always on codeplex repository)

1) NAV Powershell scripts and TFS Build Template

2) TFS Build Template for GIT repository

Some parts of the scripts are based on work (Waldo) see

Some parts are based on PowerShell scripts from module “Microsoft.Dynamics.Nav.Ide” made by Microsoft people.


Power BI Integration – Microsoft Dynamics NAV 2016 Content Package

power ni.png

“Connect your Microsoft Dynamics NAV data with Power BI” to visualize your company’s key data and discover actionable insights.

Source: Power BI Integration – Microsoft Dynamics NAV | Microsoft Power BI

Power BI Content package for NAV 2016 Download


NAV Team Blog Source Post:


  1. Sign in to
  2. Select the content package for Microsoft Dynamics NAV.
  3. Connect a Microsoft Dynamics NAV instance to the content package.

1) From My WorkSpace select “Content Package (Dynamics NAV)”

Contenta Pack1

2) look at “Web Services” in Web Services List (exiting in Cronus Demo)

packet 2

3) Connect to NAV Server Instance  (Ddata)

connect 5

Wait and … Bingo !  




If you have some issues with NAV single user (ex; can’t login, permissions lost, errors on pages etc.), you can delete ALL user configuration and after recreate a new user.

Follow procedure below.

use DB


1) FIRST: SELECT [User Security ID] from USERNAME

retrieve User Security ID (User ID by uniqueidentifier)

select [User Security ID] from [dbo].[User] where [User Name] = ‘DOMAINUSER1’

–> example: User Security ID output: 49089BA8-91C5-4BD2-A322-7797760736B2 (User ID by uniqueidentifier)

2) SECOND: DELETE users configuration using [User Security ID] extracted from user name

delete [dbo].[Access Control] where [User Security ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[Page Data Personalization] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Metadata] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Property] where [User Security ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Personalization] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Default Style Sheet] where [User ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′



STOP NAV SERVER Service (you can’t delete users from SQL with NAV server active- “USER” table is locked)

3) LAST: delete user (and after recreate form NAV User Page)

delete [dbo].[User] where [User Name] = ‘DOMAINUSER1’


** If you have NAV pending services, use KIll service script below:


Kill Service Script

sc queryex MicrosoftDynamicsNavServer$ITA

result –> Service Name

Process ID : PID 10484

taskkill /PID 10484 /F

result –> process killed

Have a nice day !

“Top Reasons” to Upgrade to Microsoft Dynamics NAV 2016

time to upgrade NAV 2016

“Top Reasons” to Upgrade to Microsoft Dynamics NAV 2016

.. and NAV 2015/2016 best Features …nice Microsoft official document about “NAV 2016 Upgrade Top Reasons” below.



..another good link bout moving to NAV 2016 top reasons here:

5 Top Reasons to Move to Dynamics NAV 2016


“With the launch of Dynamics NAV 2016, Microsoft has made it more compelling for NAV users to make the move to NAV 2016.”

1. Native integration with CRM Online

It is looking bright for the management of customer engagements as NAV 2016 will be natively integrated with CRM. This means less work on integration work using clunky or third-party tools and just getting that long-awaited seamless integration between these two systems. Manage leads and opportunities in CRM, process orders in NAV and access customer data from either.

2. Work natively with Azure

Now you can just configure NAV 2016 with Azure SQL. You get all the advantages of Azure including high availability, built-in redundancy, security, and value.

3. Access from all your devices

Apart from your desktop and tablet, you will also be able to access NAV 2016 from your smartphone with native apps and support for Windows, IOS, and Android. Browser enhancements also bring improvements to performance and user productivity. Access NAV 2016 from any device from anywhere you are connected.

4. Business Workflows

Using workflows you can automate routings for approvals of business documents such as Purchase Orders that are over a defined threshold or Sales orders that have gone beyond a customer’s credit limit. Using workflows you can now define notifications that are triggered by business events that keep you on top of your business. Processes can also be automated to trigger things as basic as doing a calculation or executing an action.

5. e-Everything

From electronic invoicing to OCR, you now get powerful tools for document management.

..another good site about “Last NAV releases 2015/2016” best features below:

What’s New in MS Dynamics NAV 2015 & 2016 (Best Features)


MS Dynamics NAV is an ERP system intended to help small and medium enterprises with manufacturing, finance, supply chain and customer relationship management, ecommerce and analytics. Its latest version NAV 2015 provides significant capabilities but Microsoft is planning to offer much more in NAV 2016.

But in this article, I will primarily summarize enhancements in NAV 2015 and 2016 that introduce considerable advantages to performance and usability. Also, an emphasis will be placed on the main improvements that have been done and will be done.


It is widely known that, in old versions of Dynamics NAV, performance deteriorated while the database increased in size. Now, some performance bottlenecks are unblocked due to newly implemented three-tier architecture. So, let’s take a closer look at some of the most noticeable advantages of the 2015 and 2016 upgrades:

· In NAV 2015, improved Server and Service Tiers help to decrease the amount of traffic among SQL Server, Dynamics NAV Server and client. This enables better network performance – business logic runs only on the NAV Server tier now.

· Starting from NAV 2013 R2, WEB client has already provided better performance because most of the processes are executed by the Dynamics NAV WEB server.

· New Dynamics NAV versions have improved SQL Server performance:

  1. Changed cache usage: Now, Dynamics NAV Server is responsible for caching the requested data for all users; in old versions, every connection required its own cache every time.
  2. MARS (multiple active results sets) implemented: Functions Find(‘-’), Find(‘+’), Next work faster.

  3. Filtering on FlowFields mainly processed with a single SQL statement: Previously, filtering on FlowFields was called as an SQL statement for each filtered FlowField and for each record in the table in order to calculate the filtered FlowFields.

  4. Added a new Object – NAV Query: It allows building queries in a single SQL command and getting read-only results which work faster than table-based data.

Usability & Other Features

The following global improvements were added:

· NAV 2015 client is available on Tablets and NAV 2016 client will be also available on mobile devices.

· Both Nav 2015 & 2016 provide excellent integration with native Business Intelligence and Office 365.

· Excel capabilities and Power BI allow you to analyze and visualize data.

· Word Templates help you create your own templates for any kind of document reports and import them to NAV.

· In NAV 2016, it will be possible to integrate with Online Dynamics CRM to extend enterprise possibilities.

· Starting from NAV 2015, you can easily schedule reports in the Report Inbox section of Role Center. For printed reports it is also possible to choose the output format of the Layout – Word, Excel or PDF.

· In NAV 2015, the Mandatory Field property was added. Now, it is easier to manage the user interface without adding a new checking code to triggers and functions. Also, it becomes user-friendly interpretation of such fields.

· In NAV 2015, Bank Data Conversion Service on Microsoft Azure enables automatic processes for electronic payments. There were prepared some template functions for the biggest banks to make Dynamics NAV flexible for export/import payments and receipts.

· In NAV 2016, workflow enhancements are expected to improve customized automation around billing, HR and Payroll, financial and other critical functions.

· And the last quite useful and important feature of NAV 2015 is the possibility to simplify the user interface in the UI Removal feature. You can delete unused fields and/or actions on the pages. And that makes pages easier to observe and navigate.



… and the winners are (best 5 most voted):

  • Eventing in C/AL
  • Workflow

  • Extensions

  • Universal APP

  • Best in “Others Features”: Intellisense for C/AL

  • NAV 2016 Le Novità (What’s New)

    You are welcome!

    Proactive Monitoring with Task Scheduler | Dynamics NAV Team Blog

    “Proactive Monitoring with Task Scheduler”, very nice post by NAV Team.

    Here in Part V of  the “Monitoring and Admin” coffee breaks, we will schedule a Windows PowerShell script with these two purposes:

    • Check for heartbeat (check if Dynamics NAV is still running), and
    • Check for a threshold value, for example MEM or CPU exceeding a max value

    Source and read all @ Coffee Break: Proactive Monitoring with Task Scheduler | Dynamics NAV Team Blog