Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi All, This article is intended for those who want to use OR Have to Use web services with SSL. In this Post we will discuss how to configure same with a Non Qualified Name SSL Certificate. I will come back with Second part of this article asap where we would see how to create a Qualified Name SSL Certificate. This article is based on the request of some of my Blog Readers who were unable to use Web Services. The Article should only be used for Testing Environment, For Production Environment please contact the Certifying authority to get the SSL Certificate. Here is What is Article Contain (Table Of Index) - Pre-Requisites Story before This Configuring Microsoft Dynamics NAV Web Services to Use SSL (Non-Qualified) Creating an SSL Certificate. Installing of SSL Certificate Configuring the Access Control List and the Web Services Port for SSL Verifying the Configuration and Execute the Web Services

Hi all, As discussed in Previous post we will see more about Modes in Upgrade Codeunits, Powershell Commands & benefits of New Schema Synchronization in NAV 2015. If you haven't read the earlier post, refer the links below - NAV 2015 - Changes in Schema Synchronization - Part I. NAV 2015 - Changes in Schema Synchronization - Part II. What does Check, Move, Copy and Force Options are in Upgrade Codeunits? Below is the Summary of All the Options that we will use in Upgrade Codeunits.

Hi all, As discussed in Previous post we will see more about Options of Synchronization Schema, Destructive Table Changes, Upgrade Codeunits, Modes in Upgrade Codeunits, Powershell Commands & benefits of New Schema Synchronization in NAV 2015. If you haven't read the Previous Post please Refer the Post here - NAV 2015 - Changes in Schema Synchronization - Part I Below is the difference between three Synchronize Schemas as discussed in Earlier Post -

Hi all, Just got a Link from a Friend  Mahesh dahal about NAV 2015. So now its officially available to download at Microsoft Partner Source. Please follow the Below Link to Download the Microsoft Dynamics NAV 2015 Download NAV 2015

Hi all, One more major change which was a pain in NAV 2013 R2 have been enhanced in NAV 2015. Below are the Changes in Schema Synchronization in NAV 2015. In Microsoft Dynamics NAV 2015, Microsoft have introduced a number of improvements to the schema synchronization process that make it more explicit, more granular and controllable, providing you with the flexibility of deciding when and how your table changes should be synchronized with corresponding SQL tables. So What is schema synchronization? Any Change we do in Navision developer Environment related to Tables Need to be updated in SQL Server Database. That is What is called as Schema Synchronization. Below Picture Might Help Those who are still Unaware about it.

Hi all, With NAV 2015 there are some enhancement for the Development Team as we discussed below - Non Default Properties will be Bold. Most of us while checking the properties of a Object / Field till NAV 2013 R2 have only option to identify the property as the Non Default value will come without <> .

Hi all, While Reading Readiness Document for NAV 2015 i came across some new Feature For Simplified Email  in NAV 2015. Let's see what document says in the article. To me this is something cool as most of the customer had this feature customized from there partners. If its in standard Customers will be really happy with a feature which everyone was looking for. 1. Simplified Email - Microsoft have introduced a new feature called "Simplified Email with a Report Attachment", which enables a uniform way of sending document reports as attachments from any client.

Hi all, While Reading Readiness Document for NAV 2015 i came across some new UI Changes in NAV 2015. Let's see what document says in the article. What Benefits These Changes Should Bring (AS per Microsoft) - 1. Easier page overview and processing - By indicating which fields on a page are mandatory, users get a better overview of their process, especially users that do not use the page frequently. Mandatory Fields will Now be  Highlighted in NAV 2015.

HI all, While Reading Readiness Document for NAV 2015 i came across a  commonly asked feature from most of the customer about UI Element Removal . Let's see what document says in the article. What Microsoft Says - To simplify the users’ experience in Microsoft Dynamics NAV 2015, we have introduced the UI Elements Removal feature. The feature can be used to remove user interface (UI) elements, such as fields and actions from pages in Microsoft Dynamics NAV so that the Role Center and pages become simpler to look at, easier to navigate on, and faster to get through. 

Hi all, After Reading More about next major release i.e NAV 2015 i found some great things which i would like to share. Twitter - Supported Cash Management process in NAV 2015.

Hi all, Finally wait is over and we have some more news about NAV 2015. I know most of us were waiting for updates on NAV 2015. Below are some bytes from partner source about Microsoft Dynamics NAV 2015. Let's go through them and get a feel what the product will look like and what's new in this version of us as partners / Developers.

Hi all, Please find below the details of Cumulative Update 11 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative update 11 for Microsoft Dynamics NAV 2013 R2. Build No. - 37799 Release Date - September, 2014 Local Version Included - AU, AT, BE, CH, CZ, 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. Title - Cumulative update 18 for Microsoft Dynamics NAV 2013  Build No. - 37798 Release Date - September, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi all, During Upgrade From 2009 or Previous to NAV 2013 or Later we miss some of our best Friends. There is a new Label (Group) is created on the Blog " Discontinued Components ". This will contain how to use these discontinued components with NAV 2013 and Later using DOT NET Component. I find this as a query from most of the blog readers. So we start with one of my best friend which is missing in NAV 2013 and later i.e " INPUT BOX ".

Hi All, In this post we will be discussing how we can move a Native Database to SQL Database. In Simple Words If a customer is Using Native Database (FDB), how we can move that database to SQL Server. So if you know how to do SQL Migration rest is something you will not be interested in. Others who want to learn it please read the complete article.

Hi All, One of my NAV Friend while working on SSRS Reports asked a Question. Below is the Query is his words? "Hey Saurav - When I trying to access table Sales Prepayment % or Field Prepayment % or using a database Named as Demo Database NAV (7-0) I get a different name is SQL instead of Navision. Why there is a change? Which all character get changed? Where I can find this change Character List?"  So those who Know this, I guess what is below is nothing new for you, but those who still are curious about it should Read Ahead...

Hi all, While Browsing Partner Source I found a article which is worth sharing with all my Blog Readers. Announcement: Effective August 13, 2014  (Official Statement) Microsoft is announcing the elimination of ​​certification/exam requirements for Microsoft Dynamics GP, Microsoft Dynamics NAV, Microsoft Dynamics SL, Microsoft Dynamics RMS and Microsoft Dynamics C5. This includes pre-sales and sales assessments as well as implementation methodology and technical certifications and covers both SPA and MPN.

Hi all, In Previous post related to ODATA we saw how to publish and consume a Odata Web Services from NAV 2013 & 2013 R2. For Articles Related to ODATA & web services posted before today please Refer Label Web Services . Today we will see how to Using FlowFilters in OData URIs.

Hi All, Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2 . Below are the link for new videos available on MSDN. Thanks Microsoft & Microsoft MVP's for the HDI Series. IF you are looking for Previously Released HDI Series Videos Please Refer Below Links. >> From 01 To 26 Videos . >> From 27 To  42 Videos . >> From 43 To 73 Videos . Below are the Links for New Videos.

Hi all, Some time before we discussed about Import and Export Functionality with and without multitenacy in NAV 2013 R2. The Feature was released with Cumulative Update 8 for NAV 2013 R2. The Process of Exporting and Importing data between databases was fast (i would say) from Legacy Backup of Classic Client, but still there are some flaws which i hope will be removed by Microsoft in New Cumulative Updates or in New Release. For the Details of Steps how to Export and Import you can refer the blog article here .

Hi All, While Browsing Partner Source and Microsoft Team Blog i found out some interesting link and thought of sharing them. Below are some updates from Microsoft on Team Blog -

Hi all, Please find below the details of  Cumulative Update 10 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 10 for Microsoft Dynamics NAV 2013 R2 Build No. - 37534 Release Date - August, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU 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 17 released for Microsoft Dynamics NAV 2013. Title - Cumulative update 17 for Microsoft Dynamics NAV 2013  Build No. - 37532 Release Date - August, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link

Hi All, During a Upgrade Project from NAV 2009 SP1 to NAV 2013. Step 1 was performed successfully. But After Converting Database to NAV 2013 and Running Upgrade Step 2 I found an error message. Below is the Screen Shot of the Error Message -

Hi all, Yesterday I received a message on Facebook Page from Dynamics101 , mentioning that  - “After Careful Consideration we have decided to include your blog in our first annual list of Top 25 Dynamics NAV Sites.” The Complete List of Top 25 Sites Available here http://www.dynamics101.com/2014/08/top-25-dynamics-nav-sites/ All my Blog Readers are actually the people who deserve the Batch.. I would like to take this opportunity to thanks all my Blog Readers. Thank you all. Regards, Saurav Dhyani www.sauravdhyani.com

Hi all, Below is a detailed post from one of the article listed in Microsoft Team blog about "Introducing the Microsoft Dynamics NAV Application Pro filer". With the tool, we can monitor how your application code performs at real time? You can also consider it as advanced version of old Client Monitor. Let's see how to install and configure the tool and use this tool to enable C/AL code tracing and determine application performance during code execution. Download = 1. Download the Dynamics NAV Application Profiler From CodPlex

HI all, While Reading a article on Mibuso i see a simple requirement i.e to change the Start UP Screen of Navision Role Tailored Client. The Post below in not related to any Navision Feature or Functionality, but if you want to read it let's scroll Down.

Hi all, While reading through Waldo Blog i came to know that its official announced by Microsoft about the new version release of Microsoft Dynamics NAV. This all happened in Microsoft World Partner Conference.

Hi all, Please find below the details of  Cumulative Update 9 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 9 for Microsoft Dynamics NAV 2013 R2 Build No. - 37221 Release Date - July, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU, CZ (NEW) Download Link With Cumulative Update 9 Microsoft have released a new feature i.e Merging Application Objects using Windows PowerShell . We will see the use of new feature in future post.

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

Hi all, In Previous post related to ODATA we saw how to publish and consume a Odata Web Services from NAV 2013 & 2013 R2. Below are some link Related to Old Articles Published for Odata - NAV RTC - Introduction to Web Services. Introduction of ODATA Services In NAV 2013. What is the ODATA? Max. Page Size in ODATA Parameter. Consuming Output of ODATA - Part 1 How to Use OData to Return OR Obtain a Service Metadata (EDMX) Document How to - Use OData to Return OR Obtain a JSON Document Today we will see how to Using Filter Expressions in OData URIs. To add a filter to an OData URI, add $filter= to the end of the name of the published web service.

Hi all, In Previous post related to ODATA we saw how to publish and consume a Odata Web Services from NAV 2013 & 2013 R2. Below are some link Related to Old Articles Published for Odata - NAV RTC - Introduction to Web Services . Introduction of ODATA Services In NAV 2013 . What is the ODATA? Max. Page Size in ODATA Parameter Consuming Output of ODATA - Part 1 How to Use OData to Return OR Obtain a Service Metadata (EDMX) Document Today we will see how to Return / Obtain a JSON Document. What is JSON?

Hi all, Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2 . Below are the link for new videos available on MSDN. Thanks Microsoft MVP's for the HDI Series. IF you are looking for Previously Released HDI Series Videos Please Refer Below Links. >> From 01 To 26 Videos.       >> From 27 To  42 Videos. Below are the Links for New Videos.

Hi all, In this post we will list down the steps to restore backup taken in Previous Post using power shell Using Direct Database & Service Instance For a MultiTenant Database. If you haven't read the Previous post, please refer to Index of Posts . UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. Below is the Details of my Companies in Each Tenant -

Hi all, In this post we will list down the steps to take backup using power shell Using Direct Database & Service Instance For a MultiTenant Database. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. If you haven't read the Previous post, please refer to Index of Posts . Below is the Details of my MultiTenant Service -

Hi all, In this post we will list down the steps to Restore backup using Windows Client. * Steps Remain Same for Web Client. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. If you haven't read the Previous post, please refer to Index of Posts . Pre-Requisites - To export or import data from a Microsoft Dynamics NAV database, you must be a user in the Microsoft Dynamics NAV database, and your user account must have a permission set that enables you to export or import data, such as the SUPER permission set.

Hi all, As discussed in earlier post, we will see how to take Restore backup in a new database. In this post we will list down the steps to restore the backup taken using powershell service commandlet. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. If you haven't read the Previous post, please refer Index Post here . Let's check the Content of Backup Taken Via Emport-NavData. Microsoft have provided a Commandlet for the same i.e  Get-NAVDataFile. This Commandlet takes file Location and Name as parameter and returns the details of Content of the backup File. Open Powershell and Let's check the two file content using Get-NAVDataFile = -------------------------------------------------------------- Get-NAVDataFile -FileName "c:\Two_Comapniesbackup_Service.navdata" --------------------------------------------------------------- So its clear from the Result of Commandlet that the above fi

Hi all, As discussed in earlier post, we will see how to take Restore backup in a new database. In this post we will list down the steps to restore the backup taken using Powershell. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. If you haven't read the Previous post, please refer Index Post here . From the Task Performed in Earlier Posts Backup From Powershell, i have below files as shown Below -

Hi all, In this post we will list down the steps to take backup using Windows Client. * Steps Remain Same for Web Client. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. If you haven't read the Previous post, please refer to Index of Posts . Pre-Requisites - To export or import data from a Microsoft Dynamics NAV database, you must be a user in the Microsoft Dynamics NAV database, and your user account must have a permission set that enables you to export or import data, such as the SUPER permission set.

Hi all, In this post we will list down the steps to take backup using power shell & Service Instance. If you haven't read the Previous post, please refer to Index of Posts . We will see usage of below listed 3 & 4 Commandlet options in this post. 3. UseNST_AllCompanies 4. UseNST_SomeCompanies Let's see how to use each of them.

Hi all, As discussed in earlier post, we will see how to take navision backup similar to .fbk file and restore it in a new database. In this post we will list down the steps to take backup using power-shell. If you haven't read the Previous post, please refer here . UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. Hope till now you have uninstalled the older build of NAV 2013 R2 and installed the latest Build i.e 7.1.3687 as shown below. For Demo Purpose i have a created 4 companies in a database as shown below, where A & B are copy of Cronus international whereas C is a blank company.