Skip to main content


Showing posts from February, 2013

Report Export to Excel with Font & Colour

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.

Export to Excel - Delete Un-used Sheets.

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.

Grid Layout in NAV 2013.

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.

Error After Restore SQL Backup of NAV 2013 Database

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

How to Check Available Object Range in License?

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?

NAV 2009 Reports - Common Issue & Resolutions.. (Part 2)

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?

How to Save License in Navision Database?

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.

Use of NAVDEMO Instance in Development Environment

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.