Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi all, As per my understanding yeah the rumors about new version are true. CodeName - Sicily  (for Navision 8).

Hi all, In all the previous posts we have discussed about how to create multiple NAV Services to Run Multiple RTC for same or Different version of Role Tailored Client. But we never discussed about how we can create multiple Web Services. I required to Publish Multiple Web services and that is the reason i come up with this Post. Hope you will find it use of this post somewhere.

Hi all, As discussed in earlier post, let's Try use One Note Integration in Local Machine. If you haven't read the earlier post click here . 1. Open Navision and Open Profiles by Search box or navigating to    Departments - Administration - Application Setup - RoleTailored Client - Profiles

Hi all, I was just going through article about Integrating with Microsoft One Note in MSDN . With Microsoft OneNote 2010 integration you can attach notes to customers, items, or invoices. One Note notes can be created for a specific record, but also for a whole page depending on the setup. Reminder - Pages notes can only be used on pages that are based on a source table. This means that, for example, the Role Center page cannot use page notes.

Hi all, I got an error message due to a mistake done by my during Export Raid Start Package.  Spent lot of time to resolve below listed error. Just thought to share the resolution for same, may be it's save someone time.

Hi all, I know most of this know this, but this is some of us who are still doesn't know about configuring the Role center page. Let's start with the article provided by Microsoft for Configuring a Profile. The article can be read here . Let's follow the steps and try configuring profile "ORDER PROCESSOR".

Hi all, Today we will discuss the impact of parameter Max. Page size in ODATA Tab of the service tier. It is called as "Server-Driven Paging in OData Web Services" .

Hi all, As discussed in earlier post today we will try to consume output from the ODATA Services. The best tool that i like for same is Power Pivot , an Microsoft Excel add in. You can download same from link -  Power Pivot

Hi all, Let's discuss about a New Services came up with NAV 2013 - ODATA. In the post we will see the basic introduction about ODATA, how to enable it and how it can be browsed. Later on we will discuss on how to consume data exposed via ODATA.

Hi all, Its been so long from my last post. Sorry for that, i am busy these days and don't get time to put my experiences in the BLOG. As we all know a new Service is available in NAV 2013 aka ODATA. Let's try to figure out what is OData? OData is Open Data Protocol.

Hi all, As required by most of the Blog visitor here is a post for export to excel with Font Size, Font Color, Background Color and Font Name. If you are looking for the same solution in NAV 2013 R2 or any of the Role Tailored Client then  Refer Here for the Updated Article for NAV 2013 R2. Let's see how we can achieve them - 1. I have added some fields in Excel Buffer Table (370) listed Below.

Hi all, While Browsing the Partner source i figured out that we need to wait for NAV 2013 till  October 2013. Microsoft have put up the   Microsoft Dynamics NAV Certification Exam Preparation Guides for NAV 2013 and there are some changes in Professional Exams also.

Hi all, I know most of us know if but i still got queries where some of our colleges don't know how to delete the un-used sheets while add export to excel functionality in a Report. So if you know how to do it you can skip this article.

Hi All, A new Page Designer concept has been introduced in NAV 2013, i.e. Grid Layout. This concept provides us a little facility for placing of control in the page.  Let’s try to work on same. Below is the how Standard Customer Page look like.

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Hi all, As most of the reader may know this, but this is still a query from most of the new consultants. Query - I have customer license and I want to check the valid object range that have rights in the license file for all types of objects. Requirement - While creating a new object for a customer, we need to check that is the Object ID that we are using is a part of the license range that customer have purchased?

Hi all, As promised in the blog entry  I will list down some common known things that we need to take care while estimating & developing RTC Reports in 2009 Versions. * These are my faced issues and their resolutions, you may not agree with all these. If that will be case I would suggest you to share same with others. Lets begin with RTC Report Header - During development you might have seen that in standard reports there are basically two ways to display report Headers. 1) Using Page Header. 2) Using Header in Body. When to use which?

Hi all, I know most of know this but still I am posting this because I was getting queries about it. * This post only applies to classic client. Scenario - While Testing a customization Developed for a customer? The Development team have completed their task and now internal testing need to be carried. The best way to test a customization is with the customer license. With this approach we will be able to find out the permission errors (to new objects) if any.

Hi all, This post is only for the Development Environment where we NAV Technical and Functional Consultants works on Multiple Versions. Till NAV 2009 R2 there was no issues that we have all the version running without installing even RTC (with some tweaks). But Let's See what is the issue we faced when NAV 2013 have launched. Below are some facts which I hope you all will agree.

Hi all, I was comparing NAV 2013 W1 and NAV 2013 IN for some changes that have been done specifically for INDIA. During comparison i found that all the objects have some changes. When i drilled it down i found that a new language layer have been added in NAV 2013 for India named as ENN . I was bit amazed to see this, and was confused that may be i would have missed in previous version. But when i checked in NAV 2009 SP1 IN Database i figured it out that its added in NAV 2013 only.

Hi all, As discussed in last two post about 1) How to Configure Database Mail in SQL Server. 2) How to create operator in SQL? Let's see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan. There are many Default maintenance Task available in SQL, but for demo we will be using Complete Backup Maintenance Task.

Hi all, I hope everyone is great. As discussed in last post , lets have a look on how to add operators in SQL. Use of Operator - The operator is used in SQL Management Plans and Jobs to send mail in case of Success or Failure of Jobs. We will discuss how to create jobs and SQL Maintenance Plans in a separate post. As of now let's stick to agenda and discuss how to create the operator.

Hi all, Let's see how to configure Database Mail in SQL Server. we will see use of same in future post. Open SQL Server Management Studio. Open Management and Right Click Database Mail as shown below.

Hi all, It's been so long from my last post. Sorry but i am busy these days. Let's have a quick post about the new Freeze Pane that is available in NAV 2013 List Pages and how we can change that freeze pane. What is freeze Pane? Freeze Pane means the selected Columns remain fix when you navigate in the page records.

Hi all, I know it to late but I wish you all a very Happy  & Prosperous New Year . I am so much busy these days that I can't even make a Blog entry. So here is the list of points that I will be coming up in next few days (once I will get free) - As most of us still working on NAV 2009 Reports. Let's figure out the challenges we face during development of RTC Reports.