Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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 Client .                                   5.   Restore Using Direct Connection to Database .           6.   Restore Using Service Tier .      

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

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

Hi all, Please find below the details of Fix for Issues in Update Rollup 5 released for Microsoft Dynamics NAV 2013 R2. Build No. - 36310 Release Date - March, 2014 Download Link

Hi all, Please find below the details of Update Rollup 5 released for Microsoft Dynamics NAV 2013 R2. Title - Update Rollup 5 for Microsoft Dynamics NAV 2013 R2 Build No. - 36281 Release Date - March, 2014 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK   NEW * - AT, BE, CH, ES, FI, IS, NO Download Link

Hi all, In NAV 2013 and NAV 2013 R2 a conman issue faced is - "You do not have the following permissions on Codeunit ApplicationManagment: Execute."

Dear all, As discussed in Last post Microsoft NAV 2013 R2 had a Critical Bug of Data Loss when we change an Objects Multiple Times or Compile Objects in Live Database that has active users connected. Microsoft Have Released A Platform Hotfix for the same, which is now available for download from partner source. Below are the details of KB Article - Platform hotfix for Microsoft Dynamics NAV 2013 R2 (Build 36281) Tag for Major Issue -  357487 Data loss can occur when you change an object multiple times or compile all objects in a live database that has active users connected. Download Link -  https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2934571 Please note that implementing KB 2934571 will require a database conversion Regards, Saurav Dhyani saurav-nav.blogspot.com

Hi all, Please find below the latest Updates from Microsoft Team Blog - 1. Modifying the Microsoft Dynamics NAV 2013 R2 Installation Program to Include Microsoft.Dynamics.Nav.Client.WinForms.tlb

Hi all, I know I was kind of unavailable from last two months. The reason that I was unable to post any articles was due to my busy schedule. I will try again to gain some pace but just wanted to share with you all about a Data type which I learnt recently. The Data Type that we will be discussing is RECORDID . Some of us know how to use it but most of like me were unaware about the use of data type.

Hi all, Please find below the details of Update Rollup 4 released for Microsoft Dynamics NAV 2013 R2. Title - Update Rollup 4 for Microsoft Dynamics NAV 2013 R2 Build No. - 36078 Release Date - February, 2014 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK New in update rollup 4 

Hi all, Please find below the details of Update Rollup 11 released for Microsoft Dynamics NAV 2013. Title - Update Rollup 11 for Microsoft Dynamics NAV 2013 Build No. - 36076 Release Date - February, 2014 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK Download Link

Hi all, With NAV 2009, while using web services we face a common issue related to Metadata of the Table with Id 2000000073. Let's see the reasons behind it and how to resolve it.

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. For Last 26 Videos Link Please refer to the Post here . Below are the Links for New Videos.

Hi all, Please find below the details of Update Rollup 3 released for Microsoft Dynamics NAV 2013 R2. For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 R2 below are the links -     Update Rollup 1     Update Rollup 2 Title - Update Rollup 3 for Microsoft Dynamics NAV 2013 R2 Build No. - 36035 Release Date - February, 2014 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK Download Link Regards, Saurav Dhyani saurav-nav.blogspot.in