Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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

Hi all, Please find below the details of Update Rollup 10 released for Microsoft Dynamics NAV 2013. For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 below are the links -     Update Rollup 1 to 6     Update Rollup 7     Update Rollup 8     Update Rollup 9 Title - Update Rollup 10 for Microsoft Dynamics NAV 2013 Build No. - 36005 Release Date - January, 2014 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK Download Link These links required valid Partner Source / Customer Source Login... Regards, Saurav Dhyani saurav-nav.blogspot.in

Hi all, I found one more issue after applying Multi - Tenancy to my database. Here is the problem - When i try to create a table with DataPerCompany Property Set to NO, Developer Environment give an error message saying "There are multiple tenants mounted on the server. Validating table layout changes to protect against data-loss is only supported with a single tenant mounted on the server."

Hi all, Till now we have seen how to implement Multi-Tenancy. Today let's discuss the web client in  Multi-Tenancy Environment. Now what changes do i need to do to run a Web client for a specific Tenant. Suppose i want to run web client for all the Tenants. Objective of Post - 1) Configure the Web Server for the Service MultiTenancy. 2) Access the web client with all Tenants.

Hi all, As we discussed in earlier post about Multi-Tenancy, we are facing some issues after implementing the same. One of the issue was discussed in earlier post. In this post we will see a common error message after Multi-Tenancy i.e "I cannot run the object from Object Designer after implementing Multi-Tenancy".

Hi all, During implementation of MultiTenant we have discussed that there are some data common to all companies tables which remain in the application database. Let's open the application database from SQL Server and see the list. Now let's open the Windows Client and try to add records in any of these tables.

Hi all, During Previous Post we have successfully migrated from a single tenant to Multi Tenant Environment. But there are some questions in my mind and may be in your mind also. a) From where system identify that the Service Instance is Single / Multi Tenant? b) Where exactly the Information about Tenants stored in the system?

Hi all, Previous Post in this series are -   -  Multitenant Concept.   -  Implementing Multi-Tenancy Part 1 .   -  Implementing Multi-Tenancy Part 2 .   - Implementing Multi-Tenancy Part 3 . This post was created due to questions from multiple readers about existence of Default Tenant. 1. Do we need Default Tenant if there are no Companies? 2. Is Default Tenant is Mandatory? The answer of both the questions is No. So what we will see in this post is - 1. Move to Default Company in a separate Tenant say Test. 2. Delete the default Tenant.

Hi all, Previous Post in this series are -   - Multitenant Concept.   - Implementing Multi-Tenancy Part 1 .   - Implementing Multi-Tenancy Part 2 . In This post we will move to next steps to Creating Multiple Tenants From Customer Database. Till Now, We have separated the Application, Data Part, Configured Service Tier & Mount The Application & Customer Data in Service Tier.

Hi all, Previous Post in this series are -   - MutiTenant Concept .   - Implementing Multi -Tenancy Part 1 . In This post we will move to next steps to configure Service and Mounting Databases. Till Now, We have separated the Application and Data Part. STEPS -

Hi all, As discussed the concept of Mutlitenant in Previous post , let see how we can actually implement it. Current State - 1. I have a NAV 2013 R2 database in SQL named as "ABC Company Database NAV 2013 R2" which we are going to convert to Mutlitenant.

Hi all, I was waiting to see this and I would say i am really happy after visiting the Next Generation Partner Source which is now available.

Hi all, In Last post we had seen how to use export to Excel Reports in NAV 2013. The Next question asked to me is with older version with some code we used to able to save the Report at a specified path instead of opening it. Is it possible with NAV 2013 and later? So here it is, we can again create some functions in excel buffer and save the excel files. This article Applies to Microsoft Dynamics NAV 2013 & NAV 2013 R2. Attached Screens are from NAV 2013 R2.

Hi all, Yesterday we had seen the changes in Excel Buffer in NAV 2013, but there is one more conman way that we used to use in NAV 2009 For Export to Excel Reports (i.e Enter Cell Function in Report). Lets discuss that today. The Idea for this post came from Ms  +shubhangi verma . Let's see what changes we need to do in a export to excel report created in NAV 2009 or Previous Version to use in NAV 2013 with ENTERCELL.

Hi all, Let's see the Changes in Excel Buffer Table in NAV 2013 as compared to NAV 2009. 1. As automation are discountinued in NAV 2013, Microsoft have created a DLL for Excel Operations. 2. A new field added in Table "Cell Type", used to specifying type of field.

Hi all, Today post is a simple post about copying a company within a database with diffrent name. This post was on request of +chandru s   , so all thanks to him that you all are reading this. I have done this in Cronus IN Database. Currently it had only company as shown below.

Hi all, As we have multiple RTC Clients, can't we have multiple Web Clients  Server? *Thanks for the update  +Mukesh Verma , sorry for misleading information. We had already done it in NAV 2013 , Let's try to do it on NAV 2013 R2. The requirement was raised by Mr.  +Ganesh S . All thanks to him for finding that there are changes in NAV 2013 R2 for multiple web clients.

Hi All, With Release of NAV 2013 Microsoft have introduced one more component of NAV Administrators. Yes that is Microsoft Dynamics NAV 2013 R2 Administration Shell. With Release of NAV 2013 R2 one more pr-requisite before installing Navision is Powershell which comes up with a windows Update. Powershell can used to access all Cmdlets available for windows. we can also use same for running Cmdlets for NAV 2013.

Hi all, Details of Update Rollup 1 For NAV 2013 R2 . The details of Second Update Rollup released for Microsoft Dynamics NAV 2013 R2 are as follows - Title - Update Rollup 2 for Microsoft Dynamics NAV 2013 R2 Build No. - 35800 Release Date - December, 2013 Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK Download Link Update rollup 2 includes Cumulative Update 1 for Microsoft Dynamics NAV 2013 R2 . To Access Link you requires to have a valid Partner Source / Customer Source Login... For all Rollup Released Till Date for NAV 2013 and 2013 R2 follow the link . Regards, Saurav Dhyani saurav-nav.blogspot.com