Showing posts with label NAV Classic and RTC. Show all posts
Showing posts with label NAV Classic and RTC. Show all posts

Wednesday, October 29, 2014

NAVISION - How To Display Time in Words.

Hi all,

This is nothing most of you would be interested in. This post only show steps about how to Display Time in words in Navision.

If you don't know this, then please go ahead.

The intended readers for this post are the Peoples who have recently joined and are still Learning NAV. Based on a Query from a Friend Via Contact Form.

Friday, May 23, 2014

NAV Classic & RTC - How to Add Users in Database.

Hi all,

I know most of us know this but its a post for the New Consultants.

This post is based on requirement of one of my friend +Shrikant Sharma

In this post we will see How to Add Users  in the Database, so if you know how to do you can skip the post.


Thursday, March 6, 2014

RecordID Data Type

Hi all,

I know i was kind of unavailable from last two months. The reason that i was unable to post any articles was due to my busy schedule.

I will try again to gain some pace but just wanted to share with you all about a Data type which i learnt recently.

The Data Type that we will be discussing is RECORDID.

Some of us know how to use it but most of like me were unaware about the use of data type.

Tuesday, July 9, 2013

Wednesday, October 17, 2012

Run XMLPORT in Navision Before NAV 2013

Hi all,

For Running a XML PORT in Navision Before NAV 2013, we can do that via a codeunit.

Below is the sample of execution of Xml Port via a codeunit.

Variables in Codeunit


Name                                 DataType
_Filev                                 File
_DatafileOutstream                 OutStream
Selection                                 Integer
_DatafileInstream                 InStream


Wednesday, June 6, 2012

Table xxx is Locked by User XXX.


Hi all,

Sometime client face issues while posting transaction that Table is Locked by a particular User.

Yes, i know that if a user is Performing a huge transaction then it happens and we can identify that from
File - Database - Information - Session Tab. Here we can get the User Name in Blocking User ID Field.

But what if the Blocking user id is BLANK. What can be the reason of the Locking message that client users are getting?

Thursday, April 5, 2012

Navision Cannot generate SSPI context State ID HY000


Hi all,

Sometime while trying to connect database in classic client with windows authentication or connect to Role Tailored Client we face an error message.

Error -
The following ODBC error occurred:
Error: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context 
State ID: HY000

Wednesday, December 21, 2011

All about ZUP file in Navision


Hi all,
Most of time we heard that this problem in navision can be resolved by deleting ZUP file, lets see what is it and where it is stored.

What is ZUP file?
The Dynamics NAV ZUP file is used to store the user setup and preferences for the current session so that they are "remembered" for the next session.

What operations can be performed on ZUP file?
The ZUP file can not be edited but it can be deleted.

Where ZUP file is stored in windows XP or windows 7 ?
In Windows XP, zup file is stored in - C:\Documents and Settings\username\Application Data.
In Windows 7, zup file is stored in - C:\Users\Username\AppData\Roaming.

Thanks & Regards,
Saurav Dhyani

Tuesday, August 23, 2011

Monday, May 30, 2011

Trace flag in SQL Server for Dynamics NAV 2009


Hi all,

This is one of the common issue faced by most of us.

When starting the RTC client or open the database in classic client you will get a warning if you have not set the trace flag correct. Because of changed security in SQL Server 2005 Dynamics NAV 2009 will only connect to the SQL Server if the trace flat ‘4616’ is set.

Resolution Steps