Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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.

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