Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi all, In previous post we had seen how to install developer toolkit . Now for performing any action in developer toolkit we require a developer toolkit database.

Hi all, In Previous posts we discussed how to install NAS and configure NAS on your system. Please move ahead with steps only if you have one NAS installed as discussed in previous post. *Remember NAS is Company Specific (It means once instance of NAS cannot run for multiple companies).

Hi all, If you would have noticed with the introdcution of RTC Client in 2009 i.e NAV 2009, in C/AL Symbol Menu Report have some new options.

Hi all, Let's see how to install Developer toolkit for Microsoft Dynamics Navision. This has been discontinued by Microsoft but most of us still requires it during upgrade process.

Hi All, Let's discuss a conman Question mostly asked/raised during Upgrade Process. How do i add a language Layer to my Database.

Hi all, During upgrade one of the conman issue is extra language in database objects.

Hi all, I always used to get confused during development about numbering of objects & fields. Today i browsed and found out a link which explain mostly all the commonly used numbering patterns in Navision.

Hi all, As discussed in earlier post about NAS Installation . Let's proceed with NAS Configuration. From Start Menu or Administrative Tools under Control Panel Open - Application Server Manager for Microsoft Dynamics NAV.

Hi Readers, Let's see how to install NAS (Navision Application Server)  in this post. Remember - 1) Never Run NAS from NAS folder inside DVD, as it doesn't install its pre-requisites using this installation procedure. 2) Always use Auto run and Select Application Server to install. For demo I will be Using NAV 2009 R2 IN. This article is part of the Series. Please Refer  Table of Content here .

Hi all, Just an update. While using NAV 2013 i was missing a great tool that was Code Coverage which used to resolve most of issues during debugging. It was used to show objects that have been called during execution of a Function.

Hi all, Let's see common issues faced with JET Report and there resolutions. The Best way to find issue is - 1) Open Excel. 2) Click on Data Source Settings and see Color of Icon in Left Bottom. 3) If its Red there are some configuration error, click on Hyperlink Next to Red Icon.

Hi all, For Installation of JET Report Please refer post . Let's see how to configure JET Report for using Report Development or Viewer.

Hi all, Let's see how to install JET Report Addin for Dynamics NAV till NAV 2009 R2. For Installing JET Report Please download Jet Report from Link . * To get access to the link you need to have an account with JET Report.

Hi all, While browsing the document for Service Tax - Reverse Charge Hotfix Released for Microsoft Dynamics NAV 2013 IN, i found out that there are Some features which are not support by this Hotfix. Below is the List of FEATURES NOT IMPLEMENTED IN THIS RELEASE -

Hi all, While browsing Partner source i found some nice KB articles which i think of sharing. Just follow the link below to download the Hot fix or Read the KB Article. One of the major finding is the Reverse Charge for Microsoft Dynamics NAV 2013 - IN .

Hi all, I was wondering from a long time for the use of Attach File in Open Database Window. I don't know you have noticed it ever or not. Curiously i pressed F1 to find out use of it and here is what i got - "If you want to attach and open a detached database that consists of a single data file, excluding the transaction log file, then you must enter the complete path and file name of the database in the Attach File field. This file typically has the .mdf file name extension. You can give this single file database any name by entering it in the Database Name field on the General tab. If no transaction log file exists with the data file, it is automatically created when you attach the data file. The database file is attached when you open it."

Hi all, Integration with Excel Continued ... (Previous Article 1 & Article 2 ) NAV USERS WHO CANNOT SEE DYNAMICS NAV TAB IN EXCEL CAN START FOLLOWING STEPS FROM STEP NO. 5.

Hi all, Integration with Excel Continued ... ( Previous Article ) Now lets assume a Live Environment. Server A have the Database, its a Database Tier (Navision). Server B have the service, its a Service Tier (Navision). Clients X1 & X2 have Navision clients. Client Y is not a Navision User ( Navision Client Not Installed ).

Hi all, Today i will be explaining you the Send to Excel Feature in NAV 2013. After installing NAV 2013, you might have found 2 Things

Hi all, TIP FOR CONSULTANT, not to be followed in Customer Environment. The account need to run Services of NAVISION RTC Client as per Microsoft Documents Should be a Domain Account with Password expiration policy set to False. What if you are not in domain and the database and service are in your local machine? If you are working at home and don't have a internet connectivity that can connect you to domain. Does this service Work? NOT of Course.

Hi all, Starting a new series - Tips & Tricks. This Group of articles will contain Small Articles (may be one Line) which we need to take care during Use of Navision. These will be Grouped Under Label Tips & Tricks . Regards, Saurav Dhyani http://saurav-nav.blogspot.in/

Hi all, During most of the demo session we had seen NAV 2013 on Windows Azure. Finally Microsoft have released Feature Pack 1 for NAV 2013, which contain tools we will need to implement on Windows Azure.

Hi all, Let's Continue with the part that we left in last session ( Reference Article 1 )- So we were done with classic report, let try to do same on RTC Too. Again from taking reference from Report 206 we follow below listed steps -

Hi all, I found lot of Queries about this, so lets try to do this. I Divide this article into three parts - 1) Enabling Multiple Copies in a standard Report - Classic. [This Article] 2)  Enabling Multiple Copies in a standard Report - RTC. 2) Set Page X / Y in Multiple Copies printing Reports. For the Demo I will be using Standard Report 16593 - Excise Invoice. This report have none of the above listed points.

Hi all, I was just browsing NAV 2013 during which i figured out a efficient way of entering data in NAV 2013 - QUICK ENTRY.

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.