Wednesday, February 27, 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.

Monday, February 25, 2013

NAV 2013 Certification YET to Come...

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.

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.

Thursday, February 7, 2013

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.

Tuesday, February 5, 2013

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.

Monday, February 4, 2013

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?

Sunday, February 3, 2013

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.

Issue -
The license uploaded on the server is a Partner developer license.

I know we can Change the license for our instance of Navision from Tools -> Licence information -> Change.

Why don't we add the license into the database so that i remain there till we have the database.

Saturday, February 2, 2013

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.