Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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, 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, 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, In NAV 2013 and NAV 2013 R2 a conman issue faced is - "You do not have the following permissions on Codeunit ApplicationManagment: Execute."

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, 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, 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?