Item Attributes-NAV 2017

In NAV 2017 you can organize and classify your products by using attributes and you can display the information you need. These attributes can be displayed on Fact box and Item card

One can define own type of attributes including text,integer and decimal. The option and values can be translated to support multilingual requirements. If attributes not required then you can block those attributes.

and Many more……

Original post from Microsoft


Table Type In NAV 2016

Nice features in NAV 2016 Table i.e One can specify the Table type

Earlier version we are using property called ‘LinkedObject’ to link the external table/view.

In New version we have property Table type which contains three different type as follows called ExternalSql’  wherein one can specify table/view from sql server that is not in MS Dynamics NAV DB

  • Normal :- Specified the table as normal table . This is default value whenever you create table in NAV
  • CRM:- Integration table for integrating NAV with Microsoft dynamics CRM
  • ExternalSQL:- Specify the table/view in sql server which is not in NAV database.

When one select ‘ExternalSQL’ two other properties will enable automatically

1) ExternalName :- specify the name of external table from database

2) External Schema :- Specify the database schema.


You can look at How to register External Tables



Send Document

In NAV 2016 on Posted Sales Invoice screen option is provided to send documents to multiple source like

  • Send to Printer ,
  • Send document by email to customer,
  • Save it to disk
  • Send document to exchange service.

One can find the option on Posted Sales Invoices as follows

In this option user can send document to directly to printer or send document via email or save the document to disk  in PDF format. This will basically reduce the work the save the file in PDF and then attach it to email  and send to customer.

In the above option when user click on option where one can select to Use ‘Yes (Use Default Settings)’ or ‘Yes (Prompt for Settings)’.

1) Yes (Use Default Settings):- This will use default settings  of system for printer,email etc.

2) Yes (Prompt for Settings) :- By selecting this option user can configure

For example if user selected email option for prompt for settings then screen will look like

In this screen user can add details required options and send email .If you selected ‘Edit in Outlook’ so email will open in default outlook client and you can edit the message Big Smile



NAV Client Development

Recently I was exploring Web Client of NAV 2016  (One of nice client of NAV) and found that lot of things got disturbed when view the custom pages on web client (I was under impression that everything will show correct on web pages automatically).Of  course I read the limitations of NAV but I was not aware that it will hamper so much on custom pages where we are  switching controls  based on the condition/process i.e show/hide the controls.

But now what to do this is not working as per windows client  Sad

Am I need to do fresh development for web pages ??? Oh this will kill the time and more on investment.

By searching I come across some new functions defined by NAV and I was like Big SmileBig Smile

They come up with something like DEFAULTCLIENTTYPE,CURRENTCLIENTTYPE functions

Using these function one can write the different code for different client like Windows,Web,Tablet,Mobile

How Do I use:

Defaulclienttype :- This functions always return the value ‘Windows’ even after viewing on other client of NAV

CURRENTCLIENTTYPE :- This functions return the NAV client type that is running in current session. As well as one can use this function to GetURL of the current client

One can written the different program for web client and windows client.

You can write something like

    <Your program goes here>

To Get URL
You can write


Using this functions could manage some of functionalities to view on the web client but still some resistance (due to limitations of web client) is there.

If the page contains any actions button switch off/on based on some process and one has return program using visibility property of page  then it will not refresh automatically one Need to press ‘F5’ whenever the page need to refresh. Surprise

Hope in coming future Microsoft will come up with some features which will enable everybody to use web client just like windows client (RTC)

Looking forward for NAV 2017 Web Client.


Notifications in UI -NAV 2017

This is really interesting feature introduced in NAV 2017 as Notifications in UI.

NAV 2017 comes up smarter way to send notifications to the UI in Web Client .This will provide notifications to the user about what is happening in transactions.

This will helpful during

1) Shortage on Inventory

2) Customer Balance is negative

3) Customer credit limit exceeded

and many more…….

In the development environment, you create notifications in C/AL by using the newNotification and NotificationScope data types and the following functions.
MESSAGE specifies the content of the notification that appears in the UI

  1. SCOPE specifies the scope in which the notification appears, which can be LocalScope or GlobalScope.
  2. SEND sends the notification to be displayed by the client.
  3. ADDACTION adds an action on the notification.
  4. SETDATA and GETDATA set and retrieve a data property value for the notification, which is typically needed when actions are invoked.

All the notifications will fire after the validations errors.


All about Microsoft Dynamics NAV