Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi All, Whenever there is a Release for Microsoft Dynamics NAV, the partners worry about changes in RDLC Layout. If you remember there were changes in usage of Set-data and Get-data from NAV 2009 to NAV 2013 which in some cases causes issues when we use the standard Microsoft Upgrade report Action. For Already Published Article about   NAV 2016 Click Here . In this article we will try to identify the answer of a common Query. "If My Customer is Already Upgrade to Microsoft Dynamics NAV 2015, Do I Need to Upgrade Report Again?"

Hi All, As promised I am back with New Features in NAV 2016.  This time its related to Enhancements related to Finance, based on a request or order from a blog reader which says - "Why you keep posting New Technical features, Are there no functional improvements?" For Already Published Article about  NAV 2016 Click Here. In this article I will list down changes Related to Finance.

Hi All, I agree there are so many articles floating for NAV 2016, but that is what happened when we get a New Version. Everyone in Navision World is so excited about new release and always try to get hold on any new details that there on web. Below are some recent happenings in Microsoft Team Blog -

Hi All, Just Getting Updated From Directions EMEA using Twitter (#DirectionsEMEA). As most of us spent so much time during documentation for our customers for the Changes that we did for the Customer In Standard Microsoft Dynamics NAV Product. It Involves Multiple Task - Take Screen Shot. Paste it in Word. Write the Description about the Screen Shot what it does. Formatting the Document. It takes quite a huge amount of time in doing all this for every project, and the story remain same for every another project. In Directions EMEA, ClickLearn introduce a High End Training Documentation for ISV Partner. Support Multiple Language. User Interactive Recording. Video recording. Written Instructions. Hands on Lab. Virtual Assistance. Read More ClickLearn. Regards, Saurav Dhyani saurav-nav.blogspot.com

Hi All, Today's article is to list down some New Features which I came across as of now. So Let's Start with basic features - 1. New Icons Yeah I know that's not a feature but it looks a bit cool to me having new Icons for Navision Clients as shown below.

Hi All, So Now its finally official and Microsoft Dynamics NAV 2016 (a.k.a Corfu) is now available to download on Microsoft Partner Source. It Happened Last Late Night (I.S.T), so a bit delay in the article, but I hope everyone is excited to get Hands on the product and Explore What's new that we were hearing from Quite a some time.  As of Now NAV 2016 available for 21 Localized Versions and W1 i.e Total of 22 Product Version have been Released. AU-Austr​alia​ FI-Finland NL-Netherlands CH-Switzerland AT-Austria FR-France ​NZ-New Zealand UK-​United Kingdom BE-Belgium DE-Germany NO-Norway US-United States CA-Canada IS-Iceland ES-Spain RU-Russia CZ-Czech Republic IT-Italy SE-Sweden W1 DK-Denmark MX-Mexico

Hi all, If you remember my old article where we discussed how we can achieve Table Information Page for Role Tailored Client in NAV 2013 R2. Old Article From NAV 2013 R2, with introduction of Multitenancy the table Information feature was removed from Developer Environment. But still the table Table Information still exist in the database. In this article we will discuss a requirement from one of my Blog Reader  +Bhushan Teredesai . At the same time I will share the objects for Table Information in NAV 2013 R2 and NAV 2015.

Hi All, MVP Again!,  1st October has a very special meaning to me, this day starts with full of expectations and fast heartbeats which lasts until the moment of receiving email from Microsoft. Once again Microsoft awarded me with the MVP (Most Valuable Professional) award for the 2nd time in a row in the Microsoft Dynamics NAV category. I'm honoured to be the part of Microsoft MVP Program, this is one of the most prestigious award to me.The award recognises the things that people like myself have gotten up to over the previous year as it relates to community contributions and of course, doing really useful stuff with Microsoft things. Here is the body of the mail that I received:

Hi All, As Promised in earlier article, I am back with some more stuff related to Power (*) tools. In This article we will list down where all Power Components can be found and Downloaded.  All these components are easy to install, so we will not go in details of installation. You can download any or all of these based on your Need, but the series will focused on Power BI. For Other Articles About Power BI Refer Table of Index .

Hi All, As there are so many products updated Version are being released for so many Microsoft products. Below are some Links which are worth to have a look with respect to NAV Ecosystem. These links are part of the ecosystem that we use for Microsoft Dynamics NAV like Visual Studio, Azure... With Every New Microsoft Dynamics NAV release we are getting strongly tied up with other technologies like discussed below.

Hi All, Today I would like to discuss a issue that we have during upgrade from Navision Classic Client to Navision RTC Client. What is the issue ? The Issue is with the data having Line Feed & Horizontal Tab. On Which Fields the issue is? The major issue is with the Primary key field. On Fields other than primary key it dosent make much of the difference.

Hi All, Today I would like to introduce a Tool Released by Microsoft Called as "POWER BI".  As per my understanding its a combination of four tools which were released by Microsoft - Power Pivot. Power Query. Power View. Power Map. I would be exploring the Product and will be sharing the Information as per my learnings and understanding. 

Hi All, We will be discussing Microsoft Power BI in a series of articles. As I am assuming there will be so many articles that I will be coming up related to Microsoft Power BI. This page will act as Table of Contents, where you can find link of all the articles released for Power BI. List will keep on appending as we keep on discussing New Things. Stay Tuned for update and Book Mark the article to remain updated. Microsoft Power BI - Introduction Microsoft Power BI - Installation Microsoft Power BI - Links To Remember Regards, Saurav Dhyani saurav-nav.blogspot.com

Hi all, Please find below the details of Cumulative Update 30 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 30 for Microsoft Dynamics NAV 2013  Build No. -   42591 Release Date - Sep, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 23 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 23 for Microsoft Dynamics NAV 2013 R2 Build No. - 42610 Release Date - Sep, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Hi all, Please find below the details of  Cumulative Update 11 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 11 for Microsoft Dynamics NAV 2015 Build No. - 42603 Release Date - Sep, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 9.

Hi All, Today we will discuss about the Parameter String Field in Navision Job Queue Entry Page / Form.  The Functionality is still same, so the steps below can be replicated and used in NAV Classic also. For Demo Purpose We will be using NAV 2013 R2.

Hi All, In Back Old Days we used to Run a Batch File From Navision Using Shell Command. The Shell Command is now discontinued with Release of Role Tailored Client. Today we will discuss the possibility of same using Dotnet Command. For the Demo i have create a .bat file named as autonav.bat. The bat file used in demo just rename a text file placed in C:\NAVDemo\ . The File Placed at above location is named as "agic ile". On Right Hand Side you can see  image shows the code in bat file and the files.

Hi All, This article list down the updates done based on comment on the article "NAV 2013 R2 - Roles & Permission Wizard". I had received request from some of my readers for minor changes in the tool. I have incorporated all the changes in the tool. If you haven't went to the article till now please visit the article from the hyper-link Roles & Permission Wizard Version 1. Update 22/08/2015: - Increased the Size of Role ID to 20 (as of Standard Microsoft Field Size). - NAV 2015 Compatibility. - Ability to Save New Role or Update Existing Role. If Any Permission Set Already Created with Same Name, then the Update process will happen otherwise a new Role Will be Created. You can download the updated tool from below links - SkyDrive                 Mibuso               File Name - SauravNavRP.NAVW17.01.02.rar Regards, Saurav Dhyani saurav-nav.blogspot.in

Hi all, In the following post we will try to conditional colour the values appearing on the matrix Page. For the Demo Purpose we will use the Page "Items by Location Matrix". The Article is based on request of Mr.  Thiyagarajan M . All thanks to him if you find the article useful. A standard Item By location Matrix Page Look Like as shown in Right. For Conditional colouring a Non Matrix Page,please Refer the Article Conditional Colouring in NAV 2013 Pages

Hi all, Please find below the details of Cumulative Update 29 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 29 for Microsoft Dynamics NAV 2013  Build No. - 42219 Release Date - Aug, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 22 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 22 for Microsoft Dynamics NAV 2013 R2 Build No. - 42221 Release Date - Aug, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Hi all, Please find below the details of  Cumulative Update 10 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 10 for Microsoft Dynamics NAV 2015 Build No. - 42222 Release Date - Aug, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link

Hi All, In today's article we will try to add two things on the Email send from the Navision - URL of a website. Company Logo in Email Footer. The Post is based on the requirement raised by  +Jonas Thilemann , so all thanks to him for the article.

Hi All, This post is based on Requirement/ Query of one of my Blog Reader  +shital bawage  . All Thanks to Shital for the article. In this article we will discuss how to achieve Export To Excel with Font, Color and Back Ground Color. Please go through the article and let me know your views and queries as comment to the article. If you are looking for same solution in Navision Classic Version  refer the article . There are some issues which are resolved in a Separate Article, Please Refer Here For Updated Article for NAV 2013 R2 . Let's Begin.

Hi all, In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export. The Article is based on request of Mr. Anand gupta , so all thanks to him for the query. Most of us know how to export data using excel buffer, but it only contain a single sheet. Now let's consider a scenario where i want to export my customers, vendors and Items from Navision in excel. So its pretty obvious that i want then in different sheets.

Hi all, Please find below the details of Cumulative Update 28 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 28 for Microsoft Dynamics NAV 2013  Build No. - 41767 Release Date - July, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 21 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 21 for Microsoft Dynamics NAV 2013 R2 Build No. - 41768 Release Date - July, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5

Hi all, This is known to most of NAV People around the world as its been trending on social media from yesterday, when microsoft Revealed the Official Name of NAV "Corfu" as Microsoft Dynamics NAV 2016 at World Partner Confrence 2015.

Hi All, I am not sure about the article that I am writing that I Should Write it or not. The area that i am about to discuss is something where I am a newbie and would like to explore the area. The Reason behind article was something asking a query about database size based on keys. In this article we will see by a small demo how much the database size get increased based on No. of Keys that we have in one table.

Hi all, Please find below the details of  Cumulative Update 9 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 9 for Microsoft Dynamics NAV 2015 Build No. - 41779 Release Date - July, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link

Hi All, This article is based on a friend request. The Requirement was to import the data in a table From an Excel File. Most of us know this feature is there in standard objects of Microsoft Dynamics NAV from a long time. If you are one of those who don't know about it please go through the article.

HI All, In This Article we will see how we can use Grouping (Group Header, Group Footer) Via Code in NAV 2013 R2 Reports. This situation is faced during upgrade of a Report where we had put code for Some Task Say Export to Excel in Sections Like Group Header and Footer in 2009 or Previous Version. In the Demo we will see a case of Export to Excel Report on Item Ledger Entry Table Having Grouped by Location Code and  Item Category Code . 1. As i Need Grouping on Location Code and Item Category Code in Item Ledger Entry Table i need to have a Key on Table 32 Item Ledger Entry as shown below.

Hi all, In Last Week, Microsoft have released Best Practices Steps that we should follow during Upgrading a Database. The Best Practices List the Steps while Upgrading a Database - From NAV 2009 R2 to NAV 2015. From NAV 2013 to NAV 2015. From NAV 2013 R2 To NAV 2015. Even if you are upgrading From NAV 2009 R2 to NAV 2013 / NAV 2013 R2 do read the Best Practices. The Article contain the points that we need to take care during Migration.

Hi all, Microsoft have published a technical article of the Inventory Costing functionality. The Article provides guidance on how the Adjust Cost - Item Entries batch job identifies and assigns a posting date to the value entries that the batch job is about to create. The Article should answer questions that we have about the functionality.

Hi all, Please find below the details of Cumulative Update 27 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 27 for Microsoft Dynamics NAV 2013  Build No. - 41354 Release Date - June, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 20 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 20 for Microsoft Dynamics NAV 2013 R2 Build No. - 41371 Release Date - June, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5

Hi all, Please find below the details of  Cumulative Update 8 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 8 for Microsoft Dynamics NAV 2015 Build No. - 41370 Release Date - June, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 4.

Hi all, There are some magical numbers in life to remember and I surely consider completing this nice milestone of 5 Years as a Part of Microsoft Dynamics NAV Family is something to cherish and brag about :). Not that it is going to change anything, it is always a feel good factor. Sense of getting reborn into a new role itself was something worth as part of this whole experience. There are some Great things happened in Past Five Years -

Hi All, Just a Quick Info. Microsoft Have Identified some issues in NAV 2013 R2 - Cumulative Update 19. Issue Description -  The problem is in table 114, Sales Cr. Memo Header, where the number of field 1300, Canceled, is changed to 1301. A typical partner development license does not allow field changes, so you will run into the problem when you try to import CU 19.

Hi all, I think most of us know SUMIF Function IN Excel , Those who don't know below is a sample. Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase. There are two ways to achieve same - 1. I Filter the Data based on Entry Type and Sum up Quantity. 2. Or I Can Use SumIF Excel Function where i can put a condition.

Hi All, In Back old days we have tools for creating Roles and Permission Using Code Coverage. There were so many. One such tool for classic Client is still available at Mibuso . Recently During a Implementation i was struggling with Roles and Permission and thought to Upgrade the Tool For Role Tailored Client. Disclaimer -  ** This Tool does not provide you complete Roles and Permission Set to be Created. It will help you in creating a basic Structure. As the Tool is based on Code Coverage, it will only consider objects which are called during operations via Code Only. ** This tool automatically assign Read, Insert & Modify Permissions on all Table Data called during Operation. User need to modify the Permission as per requirement. Below are the Details of the same.

Hi all, Please find below the details of Cumulative Update 26 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 26 for Microsoft Dynamics NAV 2013  Build No. - 40940 Release Date - May, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 19 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 Build No. - 40941 Release Date - May, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5

Hi all, Please find below the details of  Cumulative Update 7 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 7 for Microsoft Dynamics NAV 2015 Build No. - 40938 Release Date - May, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 4.

Hi All, Microsoft Have Released a Load Test Tool For Microsoft Dynamics NAV... Yes you heard it correct for Microsoft Dynamics NAV . Till Now it was kind of impossible to measure the Performance of Microsoft Dynamics NAV. With Introduction of Role Tailored Client in Microsoft Dynamics NAV it is now possible to write these Test cases in Visual Studio to simulate scenarios. The Video Series in Available in Microsoft Partner Source with HDI Series Dedicated for Same.

Hi all, This post is based on query of one of my reader Peter Huba . During Report Development we face queries like resetting the Row  No. when there is a change in Group. What we exactly Try To Do ? We tried to write C/AL code based on our group and try to set/reset a variable. But in some cases that doesn't help too as we have visibility condition in RDLC Rows which create issues. What we Don't Do ?

Hi all, Please find below the details of Cumulative Update 25 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 25 for Microsoft Dynamics NAV 2013  Build No. - 40468 Release Date - April, 2015 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, Please find below the details of  Cumulative Update 18 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 18 for Microsoft Dynamics NAV 2013 R2 Build No. - 40452 Release Date - April, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Hi all, Please find below the details of  Cumulative Update 6 released for Microsoft Dynamics NAV 2015. Title - Cumulative Update 6 for Microsoft Dynamics NAV 2015 Build No. - 40459 Release Date - April, 2015 Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK. Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 4.