Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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.

Hi all, The most awaited feature in NAV 2013 R2 by most of the consultants around the globe have been finally come as a work around. All Thanks to Microsoft Product Team. In this post we will see the various ways of taking the Backup of the Database available in NAV 2013 R2 and in subsequent posts we will see how to take backup using Powershell and Windows Client. ** The NAV 2013 R2 Should Have the Build 7.1.36987. ** Uninstall the Previous Version of NAV 2013 R2 and install the latest build. UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution. Post in this series - 1. The Concept (This Post). Without Tenants - 2.   Backup Using Direct Connection to Database.             3.   Backup Using Service Tier .                                         4.   Backup Using Windows Cl...

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 Today we will see a small but important point about ODATA i.e How we can see Metadata of Odata Web Service we have exposed.

Hi all, Please find below the details of Update Rollup Cumulative Update 8 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2 Build No. - 36897 Release Date - June, 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 15 released for Microsoft Dynamics NAV 2013. Title - Update Rollup 15 for Microsoft Dynamics NAV 2013 Build No. - 36919 Release Date - June, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK Download Link For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 below are the links -

Hi all, We had seen how to create a Multi Tenant Environment & How to Backup the Complete Environment with NAV 2013 R2 in the respective articles. But what if i want to do a restore backup of the Multi Tenant Environment in a Different Server. How can i achieve it as in my SQL now i have multiple databases. So let's see how we can achieve it. ** References - Waldo Blog. Thanks to Waldo for sharing the Information, i have tried to append the steps listed in the Video. Scenario - I took backup of My Multi tenant Environment Created with Multiple Tenants (5) and Application Objects. I want to Restore the whole Environment and Restore it on New Server.

Hi all, We had seen how to create a Multi Tenant Environment with NAV 2013 R2 earlier. But what if i want to do a backup of the Multi Tenant Environment and Restore it on a Different Server. How can i achieve it as in my SQL now i have multiple databases. So let's see how we can achieve it. ** References - Waldo Blog. Thanks to Waldo for sharing the Information, i have tried to append the steps listed in the Video. Scenario - I have a Multi tenant Environment Created with Multiple Tenants (5) and Application Objects. I want to Backup the whole Environment and Restore it on New Server.

Hi all, This post is based on suggestion from  +Ami Paneri Upadhyay * The Screen Shots and Query Applies - TO NAV 2013 R2. Steps Remain Same for NAV 2013 but query will get change. * The Query for NAV 2013 can be found in my Skydrive, Link at the end of the post. Let's see what was required and how we can achieve it. CASE - I received a database from customer and my windows login is not there in the database. I don't want to delete Customer Users from the database but want to add myself in the Users. How can we do this? OR We have a database internally for development. All the consultants having User ID's in the database are not available. I want to access the database, How can i achieve it? If you are using NAV 2013 R2 or Higher Please refer this article.

Hi all, I know most of us know this but its a post for the New Consultants. This post is based on requirement of one of my friend + Shrikant Sharma .  In this post we will see How to Add Users  in the Database, so if you know how to do you can skip the post.

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

Hi all, I found a great page on Partner source which i always wanted to have. I thought you might also be interested to know about the page. Microsoft Dynamics Localization Portal - Microsoft Dynamics NAV is what i am taking about. So lets see what is it - What Microsoft Says about the Page - "This Dynamics Localization portal provides partners information by country about localization features including info on regulatory features, documentation, plus associated ISV solutions. "

Hi all, Please find below the details of Cumulative Update 14 released for Microsoft Dynamics NAV 2013. Title - Update Rollup 14 for Microsoft Dynamics NAV 2013 Build No. - 36605 Release Date - May, 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, As discussed and Found the Cause of Issue related to Dimension During Upgrade, Lets' see how to Resolve Same Before Upgrading or During Step 2. If you haven't Read the Earlier Post Use The Link. NAV 2013 & NAV 2013 R2 - Common Issue Related to Dimension in Step 2  There are two points which make our life Easy - 1. In Earlier Version i.e 2009 / 2009 SP1 / 2009 R2, the Dimension Values were used to Store in a separate Table. 2. The Upgrade Step Batch Job Commits the Transaction Before the Error Occurs, i.e If Table X have Issue in Data Everything done before Table X is Committed.

Hi all, This is one of the most Common error that most of us are facing while upgrading to NAV 2013 or NAV 2013 R2 From NAV 2009 / 2009 SP1 / 2009 R2. What we had Completed? A. We completed Step 1 Successfully. B. Converted the Database to NAV 2013. C. Converted the Database to NAV 2013 R2. D. Imported the Merged Objects & Toolkit Step 2 Objects.

Hi all, Let's see how to Display an Embedded Picture in a Report. * The Steps Shown below are from NAV Version 2013 R2. It was a query from one of my friend +shubhangi verma   about how to add Embedded Picture in Report. I am using Standard report 405 Which can be downloaded from the link provided at the end of the Post. There are certain steps that we need to follow while adding an Embedded Picture in a Report. Let's see them.

Hi all, A common Command referred in many of the Forums that can be used to Sync Changes of Navision in SQL is Sync Tenant. Most of us are not aware how to run this command. In this post we will see how to Run and When to Run this Command? When to Run? A- When Upgrading Database from NAV 2009 / NAV 2009 SP1 / NAV 2009 R2 to NAV 2013 R2. After Opening Database in NAV 2013 R2, Compiling System Tables and Importing Merged Objects of NAV 2013 R2.

Hi all, While installing NAV 2013 R2 on Windows Server 2012 the Installer gives an error message of missing component of Windows Search. ERROR - "The following external program are prerequisites to one of more of the selected product components. They must be present on your computer before the configuration can be installed. For more information, see the system requirement's for Microsoft Dynamics NAV.

Hi All, Let's continue from the point we left in earlier Post. If you haven't read earlier post read it here NAV 2013 R2 Synchronization Paradigm Microsoft Dynamics NAV 2013 R2 SCENARIO 2 (DEPRECATED):  • Single-tenancy / Legacy mode • “Prevent data loss from table changes” = No (Manually opted, not persistent) IMPORTANT NOTICE:  Setting the “Prevent data loss from table changes” C/SIDE switch to “No” has been intended to be used as last resource in a pure multitenancy scenario and in Test or Staging environments when partners does not have any business data database mounted against the application database. Never change for any reason this parameter to “No” when developing against a single-tenant / Legacy mode database.

Dear All, Below are some extracts of the article published in Microsoft Team Blog about "The New Table Synchronization Paradigm in Microsoft Dynamics NAV 2013 R2". It start's explaining the History, how it used to happen in NAV 2009 /  NAV 2013- Microsoft Dynamics NAV 2009 / Microsoft Dynamics NAV 2013  When we import/compile an object in C/SIDE, system checks the object Metadata Version and Compare with Current Version. If the Current Version is New it updates the Object Metadata in Navision and Schema changes are directly applied to SQL Server. So before NAV 2013 R2, everything used to get updated directly from Classic Client and at the time when we used to process. At most the only issue we used to have was “The Object Metadata does not exist. Identification and values … “ when running the Microsoft Dynamics NAV Windows client. Which used to be resolved just by recompiling the Objects specified in error or all the objects or deleting the metadata o...

Hi all, While installing NAV 2013 R2 on Windows Server 2008 the Installer gives an error message of missing component of Windows Serach. ERROR - "The following external program are prerequisites to one of more of the selected product components. They must be present on your computer before the configuration can be installed. For more information, see the system requirements for Microsoft Dynamics NAV. WINDOWS SEARCH.

Hi all, This post can also be used for NAV 2013 R2 - Creating New Companies in Database From Cmdlets. With Release of NAV 2013 R2, we can create database from the Developer Environment but there is no option of creating company from Developer Environment. Due to this we have so many issues as Role Tailored Client will not open until there is a company in the database. One of the issues is discussed below with resolution.

Hi all, Please find below the details of Update Rollup Cumulative Update 6 released for Microsoft Dynamics NAV 2013 R2. NOTE: The term “update rollup”, which has been used until now for hotfix releases, has been replaced with the term “cumulative update”. The meaning of the term is unchanged. Title - Update Rollup Cumulative Update 6 for Microsoft Dynamics NAV 2013 R2 Build No. - 36366 Release Date - April, 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, Let's see a simple thing today i.e How to add images in Reports in NAV 2013 and Later. * Below screen shot are from NAV 2013 R2, the steps remain same for NAV 2013 too. So let's do it in a standard Report, say Report 405 which doesn't contain Company Logo. We will add the Company Image from Company Information Card / Table.

Hi all, Please find below the details of Update Rollup Cumulative Update 13 released for Microsoft Dynamics NAV 2013. NOTE: The term “update rollup”, which has been used until now for hotfix releases, has been replaced with the term “cumulative update”. The meaning of the term is unchanged. Title - Update Rollup 13 for Microsoft Dynamics NAV 2013 Build No. - 36347 Release Date - April, 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 we had seen how to download the Rollup of NAV 2013 and Later . Let's see how to apply Rollup of Microsoft Dynamics Rollup for NAV 2013 & NAV 2013 R2. Remember - Before applying the rollup there should be no user accessing client. All NAV Services, NAV Clients (windows & developer Environment) should be stopped & closed. Thank you  +nishant srivastava   for suggesting correction in the article. File Already Downloaded in previous post, Extract the file in a folder and open the extracted Folder.

Hi all, It has been asked so many time so here it is "How to Download the Rollup for NAV 2013 and NAV 2013 R2". Follow the Link to the KB Article as per the Rollup you want to Download. You can find details of all Rollup released for NAV 2013 and NAV 2013 R2 here. You can find details of all updates roll ups for NAV 2013 and NAV 2013 Here .

Hi all, While trying to open a database in Version 4 SP3 (5 SP1) I faced the below error message. The error message was new to me till today. Resolution - The above error also appear of our SQL Start up Parameter  4616.

Hi all, I am in process of upgrading a database from NAV 2009 SP1 to NAV 2013 R2 in one step. Earlier the One Step was not working for me but i hope this time i will be able to complete it. Keeping my finger crossed. During upgrade step 1 i faced a issue that i would like to share with you all. After Step 1 of Data Migration when i tried to open the database in NAV 2013. NAV 2013 gave me below error - Error: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified. State ID: IM002

Hi all, Let's discuss a issue resolution which most of us are facing after applying Rollup 5 for NAV 2013 R2 with Build  36281. The Error Message that i faced is - The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type. Field : Version List Type: Text 248 SQL type : VARCHAR(80)

Dear All, During a upgrade process to NAV 2013 R2 from NAV 2009 SP1, i faced an issue which took a lot of time to resolve. So i thought sharing the same with you all. When i tired to run a page it crash the NAV 2013 Windows Client exe, I thought that page might have issues but when i run table from developer environment everything same. The ERROR that i was getting - "An item with the same key has already been added" Below is the Some part of Error in event viewer - System.ArgumentException was unhandled   HResult=-2147024809   Message=An item with the same key has already been added.   Source=mscorlib