Hi all,

In a official statement from Microsoft it have been confirmed that Now it time to say Bye Bye to NAV 2009 Series.

Mainstream Support for Microsoft Dynamics NAV 2009 Ends January 13, 2015.

With this Statement Microsoft Says Good Bye to CLASSIC CLIENT. 

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,

While trying to open a database in Version 4 SP3 (5 SP1) i faced the below error message.

Hi all,

This article is based on request from my friend  +Damith Shan Abeywicrema.

Hey, man below are the steps how you can achieve it.

Hi all,

As discussed earlier how to open a specific database from the command line.

Let's see today one more customer requirement that a particular for should open on the start-up of windows.

Hi all,

Just a small Post, but this was asked to me by lot of peoples, so planned to keep user updated.

Hi all,

Today Let's try to save a classic report in PDF format.

We need to use any third party tool (PDF Printer) which will be used to print report in PDF.

There are plenty of them if you search on the web. I will be using Bullzip Printer for Demo.

For Downloading Bullzip Printer follow the Link.

Download and Install the PDF Printer.

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,

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,

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,

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,

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.

Hi all,

Just a quick post.

Most of time we get a error message "The BreakPoint Already Exist" Error Message in Navision.

The Error message is due to - "During testing the process by Technical Consultant we put breakpoints to test the value at that particular instance.

One of my user reported this error which he was getting during execution of Job in Event Viewer.

So now how can i remove all the breakpoints that i have applied, as i might have applied into multiple objects into multiple places.

Hi all,

While Release of NAV 2013, we had some new things but some old things became obsolete and cannot be used with this version of Navision.

One of them that effect most of the customer is Support to NATIVE Database. So today we will discuss about Native to SQL Migration which is one of the steps during upgrade to NAV 2013.

Hi all,

Sometime we face an error message while exporting objects as Text file, but when we try to export as .fob it works fine.

Today i require to compare some object so i needed them in text file, when i tried to export as text i get below listed error.

There are errors in the text conversation (text no. 165-205 does not exist in the .stx file).

Internal error: 47-1

Reason of Error -
The reason of the error is due to objects version conflict. The objects which i was trying to export as text file are of higher version and were in the older version of database. In my case the objects were from NAV 2009 SP1 and were in NAV 5 SP1.

Resolution of Error -

1) Export the objects into .fob format.
2) Create a new temporary database in new version.
3) Import the exported objects into new created database.
4) export objects into text file.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Hi all,

While exporting the objects in FOB format we sometime get the below error that says -

"The Object File cannot be used with this version of the program."


 I got this error while trying objects from NAV 2009 installed and trying to export the objects in FOB Format whereas the Text format export was working fine.

After searching i found out that it was due to some exported objects of NAV 2013 lying at the same path.

Once i removed those higher version FOB files from the location i was able to take backup on that location.


Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Hi all,

As most of us know that due to changes in version there has been changes in Debugging Process of Navision Processes.
Let's start with the Orignal Debugging version of Navision i.e Debugging in classic client.

In classic client the debugger was present in the classic client window itself under Tools Sections.

Here are some screenshot of the debugger in classic client -

Hi all,

Sometime User want to force the user to click on the Cancel button instead of pushing the Esc key.

This can be done From in Navision from Tools Menu in Navision Menu and select Options.

There is an option Close Forms On Esc which is by default set to YES, set it to No.

Refer to screen below.



This option will set the ESC Disabled for all objects.

If we want to customize this for a specific form follow steps below -

1. In the form declare a Boolean variable i.e. OverwriteEsc.
2. Set the Cancel property of the Cancelbutton to No
3. In the OnPush trigger of the Cancel button and Ok button: OverwriteEsc := TRUE;
4. In the OnQueryClose Trigger of the form: EXIT(OverwriteEsc);

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Hi all,

While adding export to excel functionality into Reports sometime we face issues while sending numbers with Leading Zeros to excel.

In My case customer wanted to export a Report to Excel. Report have first field as Item Number which have Leading Zeros. I created the report and below is the diffrence between excel and Navision Data.



The issue at this point is that Leading Zero in Item No. have been skipped.

Reason-

Excel formatted the cell as integer, while formatting as intger excel removes leading zeros. Beacuse a number starts with zero dosen't make any sense.

Resoultion-

After seraching through blogs and articles i figurred out a soultion so that excel formats the cell as text not as integer.

The solution is simple just to add four single quotes ('''') for the field which you want excel to format as text not as intger.

Sample -
EnterCell(Row, Column, '''' + "No.", FALSE, FALSE, FALSE);
OR
ExcelBuffer.AddColumn((''''+ "No."),False,False,False,False,'');

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Hi all,

While developing reports in classic client with Export to Excel Enabled, client wants to have Header cell merged. This is mostly faced issue.

Resolution -
What i did is that i added a function in Excel Buffer table which merge specified cell.

Function -

PROCEDURE MergeRange(FromRow : Integer;FromCol : Integer;ToRow : Integer;ToCol : Integer);
VAR
  FromRec : Record 370;
  ToRec : Record 370;
BEGIN
  FromRec.VALIDATE("Row No.",FromRow);
  FromRec.VALIDATE("Column No.",FromCol);
  ToRec.VALIDATE("Row No.",ToRow);
  ToRec.VALIDATE("Column No.",ToCol);
  XlWrkSht.Range(FromRec.xlColID + FromRec.xlRowID + ':' + ToRec.xlColID + ToRec.xlRowID).Merge;
END;