28 October 2016

Microsoft Dynamics NAV 2017 - Home Page

Hi Everyone,

I will be posting blog posts about the newly realeased Microsoft Dynamics NAV 2017. This page will be the home page for those blog posts. If you need to know anything specific please post them on the commnet section of the blog post. I will be able to look into those and provide you my view or solution.

Index :
  1. Few more weeks to go : Microsoft Dynamics NAV 2017 & Roadmap
  2. Microsoft Dynamics NAV 2017 - Limited Beta Version Available for Download
  3. What is New in Microsoft Dynamics NAV 2017?
  4. What's New in Microsoft Dynamics NAV 2017​ [Published]
  5. Microsoft Dynamics NAV 2017 - Release Date and new Announcement | Part 01
  6. Microsoft Dynamics NAV 2017 - New Announcement | Part 02
  7. New Release Date : Microsoft Dynamics NAV 2017
  8. Download Microsoft Dynamics NAV 2017
  9. Workflow Wizard with Microsoft Dynamics NAV 2017
  10. New look on List Pages - Microsoft Dynamics NAV 2017
  11. Item Attributes - Microsoft Dynamics NAV 2017 [Comming Soon]
Stay tuned for more information....

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

27 October 2016

New look on List Pages - Microsoft Dynamics NAV 2017

Microsoft Dynamics NAV 2017 Web Client offers a complete new look for the list pages. 

Webclient comes with sevaral options to change the UI of the list pages. This is something many of client's requested since it will be easy for them to use tile version UI with touch screens. Following are few sample screens from the Microsoft Dynamics NAV 2017 Web Client. 

Item List :

Customer List : 

There are sevaral option of changing the view of the user interface. If you do not like the smaller icons, then how about this :

Or you want to have the old look :

All these are possible with just a click of a button. Just click on the below options form the webclient menu. 

Stay tuned for more information....

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Workflow Wizard with Microsoft Dynamics NAV 2017

In previous version on Dynamics NAV, we had the option of creating workflows, which was one of the exsiting functionalities. For previoud blog post on Workflows click here

In latest Dynamics NAV 2017 product, Microsoft has taken a extra step to ease the life of partners and users. In new product you can create a workflow using a wizard! Exsiting!! 

If you go to Item Card, you can find this new featuer. 

Click on the "Create Approval Workflow" 

 It will open a Wizard to take you through the workflow setup

You can assign a approver in this window and set up the condition. Once the condifion is set click on next.

In this window will define when the approval workflow will trigger. Check all the condtions are in order and click on next. 

Summary of the created workflow. If you happy with it click on finish and Microsoft Dynamics NAV will activate the workflow for you. 

As per my workflow it should trigger when I change the unit price of the item. Lets give a try! 

When I exit from the item master page after changing the unit price, system trigger the workflow. It works! Item unit price will not change until the new price is approved. 

Stay tuned for more information....

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Download Microsoft Dynamics NAV 2017

Now you can download Microsoft Dynamics NAV 2017!! Use below link to access the download page: Link

PS: Thanks Freddy for the hot news. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

26 October 2016

New Release Date : Microsoft Dynamics NAV 2017

Microsoft has announced that they will not be realsing the new Microsoft Dynamics NAV 2017 version till end of this week. To be excat new realses date will be 

28th October 2016. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

19 October 2016

Date Shortcuts in Microsoft Dynamics NAV

I have seen many users are using T when they want to get the Today in the Dynamics NAV, however they do not know thre are few more shortcut keys they can use to ease their life when working with Microsoft Dynamics NAV. 
Following are some of other options available in Microsoft Dynamics NAV related to dates. (In order to below keys to work, field should be a Date Field or Date Filter Field)
  • T - It will return system date (Today)
  • W - It will return the Working Date (Setup in the Dynamics NAV)
Do you want to get the "Days of the Week" ? It also posible with few keyboard key ins. 
  •  M - Monday
  • Tu _Tuesday
  • We - Wednesday 
  • Th - Thursday 
  • F - Friday
If you are working on the weekends, then sorry. You might have to type the dates manually into Dynamics NAV.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Report color code to identify blank rows


If you have been developing RDLC reports for Dynamics NAV, most probably you might have come across the situations where some blank lines are printing in the body of the report and just a glance you cannot identify from where these lines are coming from. 

Very recently one of my colleague asked me to help him with a report. In the report there were couple of blank lines printing and he required a quick help. 

What I normally do is, I use different colors to fill the rows and run the report. It easily help me to find the row which print the blank line. Then rest is simple.. 

Following is an example report which I apply my small trick.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

16 October 2016

My two cents on Dynamics NAV Extensions

Today morning I was reading few blog posts from Microsoft Dynamics NAV MVPs on Dynamics NAV future. In most of blog posts they have focused on the extensions and freezing Dynamics NAV code. Some of them have talked positive about it and some of them have talked against it. 

Even though I do not attend any of the Dynamics NAV conferences due to the unavailability of budget, I always tried to follow them closely. 

This year most of the Dynamics NAV conferences end up with a mix feeling because of the topic Extensions

Extension :
If a person ask from me that "what is the best 5 things you like about Microsoft Dynamics NAV", I am pretty sure open source code will be in that top 5 list. Most probably it will top the top 5 list. So the freezing of the source code is bit of disturbing news for me as it is one of the most loved things about Dynamics NAV. 

Even though it is not good to do here and there modifications into the system core, I am sure most of us were doing it during our job to fix issues or to achieve customer requirement. In near future it will be a day that we will no longer be able to do a small fix to the existing code. 

Question is how we going to do such a change in Dynamics NAV. Answer is using extensions. 

What is the big deal then? 
Extension code also freeze and you cannot see the inside of it. That means if a one partner do a critical extension for a customer and then customer will be locked (most probably) into that partner forever as other partners will not be able to modify or provide support on the extension. 

It is like a black box and no one, except the original partner knows what is going on inside. 

You put the coin into vending machine and press the coca cola button, but you may get a sprite, but the nearest technician will not be able to help you and you might have to stay entire time till the original technician comes to fix the issue. If the original technician is no longer available, then you will be end up with a sprite. 

Earlier it was not like that, even though add-on source code is protected, other partners had the chances of looking into the code and figure-out what is going on inside. But with the new extensions things will be totally different. 

Question from a customer: 
During my previous employment, I used to attend to many of the pre-sale meetings which allows me interact with many of the future direct users of Dynamics NAV. During the time most of these companies were using custom build applications from a local vendor. After doing all the chit chat, presentations on the new product, functionalities, showing fancy PowerBI dashboards, RTC and all; they all ask a one question. 
"What will happen to our new ERP if your company was no longer there or if you stop selling Dynamics NAV"
We had a very small answer for that all the time and from that answer they all got satisfied and was happy to offer the implementation to us. Answer was :
"Microsoft Dynamics NAV Code is 100% open and any modification we do to the code is well documented and agreed prior. So anytime you feel like we are not doing a good job you can always change the partner and go with a different one."
Even some of the customers who was comparing custom build application (with 100% required functionalities as the customer dreamed of) with Dynamics NAV deiced to go ahead with Dynamics NAV (even without some of the key functionalities they required) because application was partner independent. 

Above is a one small example I took and there are many questions customers will ask with the new code freeze and extensions and as partners most will have to find new answers. 

Option : 
What I think is "everyone should have a option"

If you take Microsoft Dynamics NAV 2009 version, people had the option of using classic client or RTC or both during their business activities. 

When people say classic client UI is not looking fancy and look like SQL, we show them RTC (which was not stable at that time - my opinion). When people complain RTC is slow we showed them the classic client. Everyone had a option at the initial stage. 

During that time some of the partners were only doing the modifications to the forms and they did not touch the pages, unless it is required by a web services. 

Eventually Microsoft push everyone to the RTC and then introduced the web client  (again not stable at the initial stage - my opinion). Again we had options

While looking back at the past I have a feeling (once again my view) that Microsoft will stop the RTC pretty soon (as soon as Web Client has all the features) and left us with the web client. Wait a minuite, isn't that the Dynamics 365!! 

Coming back to the topic, I feel it will be good to have options, If a partner want to go build a extensions and sell it to a client, and client is willing to pay and get the extension then it should be allowed. Same way if a customer want to go ahead with the current process of open code then is should be allowed as that what makes Dynamics NAV great (My idea). So we have option. Currently we have this option and hopefully Microsoft will keep it like that in the future as well. Hopefully!!!! 

Final Thought :
Saying all these, my final thought is we should not rush to grab a seat on the sides of extensions. Let's wait, because all these years Microsoft gave some exciting things with Dynamics NAV and most of the time it payed off! Hope extensions will too! 

May be one day, there will not be sides on Extensions and will only be a one side (Hopefully on the positive side of extensions)

PS : I love the new development environment on VS because VS is the tool I used for programming for around 7 years and it is back with VS Code extension.

I said a penny for your thoughts, but I got two pennies' worth (Hope not)

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

08 October 2016

October 2016 Cumulative Updates for Microsoft Dynamics NAV

Microsoft has published new Cumulative Updates for October 2016: Please refer below links for more information It is always good to update your environment to latest Cumulative Update because it will help you to not to make any mistakes.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Now use Microsoft SQL Server 2016 with Microsoft Dynamics NAV

SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location:https://www.microsoft.com/en-us/cloud-platform/sql-server

Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce that
  • Microsoft Dynamics NAV 2016,
  • Microsoft Dynamics NAV 2015,
  • Microsoft Dynamics NAV 2013 R2
  • Microsoft Dynamics NAV 2013
are compatible with the SQL Server 2016 database engine. This applies to the following editions of SQL Server:
  • Express Edition
  • Standard Edition
  • Enterprise Edition
Microsoft Dynamics NAV 2017 will be compatible with SQL Server 2016 at launch.

Note: For reports, please do not install the SQL Server 2016 SSRS components, as these currently will not work with Dynamics NAV RDLC reports. For more information, see the system requirements for reports in Dynamics NAV 2016.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

04 October 2016

Microsoft Dynamics 365 first look

“Get your first look at the next generation of intelligent business applications”

Join us Tuesday, October 11, at 2:30 PM EST for a first look at the next generation of intelligent business applications.

You can be one of the first to hear Executive Vice President Scott Guthrie share Microsoft strategy for digital transformation and unveil Microsoft Dynamics 365. This will be an informative discussion on the next generation of intelligent business applications designed to enable organizations to grow, evolve, and transform.

Experience Dynamics 365 through live demos

Come experience Dynamics 365 in action—with live demos. “You’ll learn how these applications unify CRM and ERP capabilities into purpose-built applications that help manage specific business functions seamlessly.”

Unique industry perspectives

This event will also include perspectives on digital transformation from business leaders and industry experts. Come hear insights on how they engage customers more effectively, optimize operations, and are proactive and competitive in the market.

Get a first look at Microsoft Dynamics 365

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »