Skip to main content


Showing posts from 2011

Hide Specific Department From Department Menu in Navision RTC

Hi all, Today i came across a different type of query,where my client who is using Navision 2009 R2 RTC Client. He wanted to only Role specific jobs to all his users. Yeah we have a hotfix for the same which can hide department button from the Role Center page and user can only see the task that he need to perform. * Detail of the hotfix for hiding department from RTC can be found in this post . But the query was that he don't want to hide the whole department button from the role center page. What he wanted that Users other than finance and Administration can only see all other department than these two. He only wanted to hide Administration and Finance Menu from Department. Unfortunately microsoft have no hotfix for the issue, so i created a suggestion for the same at Microsoft connect. If you think that this is importany than vote for it here . We will find it in new release of navision. But while exploring this option i figured out that if the user wants to hi

Remove Departments Menu and Disable Personalization Feature Enhancements in Microsoft Dynamics NAV 2009 RoleTailored Client

Hi all, This had been so late to share this, but i think people still searching for this. Microsoft have release a hotfix to Remove Departments Menu and Disable Personalization Feature Enhancements in Microsoft Dynamics NAV 2009 RoleTailored Client In Microsoft Dynamics NAV 2009 R2 and in Microsoft Dynamics NAV 2009 SP1 with build 31671 and later the following 2 Personalization feature enhancements have been added:     1.   Remove Departments menu from Navigation Pane      2.   Disable Personalization For more information visit:   CustomerSource or PartnerSource Thanks & Regards, Saurav Dhyani

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

RTC Report Page Number - Format x/y

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

RTC Report Page Number - Format x/y

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Navision RTC How to place the Actions in the pages to new category

Hi all, Instead of placing the actions in the standard categories like New, Process and Report, you can also place your action to your own categories. The following steps will show the process with an example: 1) In the object designer, design the page 30 Item Card. 2) Move to the last blank line in the page. 3) Go to the Actions using View Actions. 4) Go to the properties of the Action you want to move to the new Category.     Change the following properties:           Promoted to Yes           PromotedCategory to Category4 .           *Category 4 to 10 are available in the NAV 2009 SP1, other than the standard categories like New, Report and Report.           PromotedIsBig to Yes/No(as required) 5) Go to the Page properties and change the PromotedActionCategoriesML property value like below:      ENU=New,Process,Report,New Category First three values should be same like New, Process, Report and from there you can give your own name. If you change these values s

Navision Page Property InstructionalTextML

Hi all, Navision Page Property InstructionalTextML. Used For Declares the multi-language text label that will be displayedon the page before any other user interface element. It only has effect on ConfirmationDialog type Pages . Example - PAGE 343. The Label for the Page - "The quantity on inventory is not sufficient to cover the net change in inventory. Do you still want to record the quantity?" is set as the value of InstructionalTextML property of Page. Thanks & Regards, Saurav Dhyani

Configure SQL Server Agent Mail to Use SQL Mail.

Hi all, This topic describes how to use SQL Server Management Studio to set up SQL Server Agent Mail to use SQL Mail. Before you can use SQL Mail, you must enable SQL Mail and set up a mail profile. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node, by using the Surface Area Configuration facet of Policy-Based Management, or by the using the sp_configure stored procedure.

Schedule a database backup operation by using SQL Server Management Studio in SQL Server

To schedule a database backup operation by using SQL Server Management Studio in SQL Server, follow these steps: 1) Start SQL Server Management Studio. 2) In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list. 3) Click Connect.

NAV 2009, 2009 SP1 and 2009 R2 in Same Machine Continued...

Hi all, As promised in earlier post    that I will try to figure out the way to run classic report from Role Tailored client which is not installed on my machine. One of my post  I explained that from where Role Tailored client find the path of classic client, I am just using that. My machines have NAV 2009 SP1 Installed. I went to registry editor (regedit.exe) to find the key where the information of classic client in stored. As you can see in the screen shot above (FOR WIN 7) that the information about classic client is stored in Computer\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS\CurrentVersion\App Paths\finsql.exe Go to File & select Export and save the registry file on desktop with Name say NAV Classic for NAV 2009 SP1. Now open the file in notepad. The selected line shows the path of finsql that need to start when we execute a report whose RTC Layout is not created. Let’s change the file and make changes for other

NAV 2009, 2009 SP1 and 2009 R2 in Same Machine

Hi all, After Microsoft Released NAV 2009 Three Tier Architecture, we find issues while testing RTC on a version which is not installed. Most of us uninstall current version and install the required version just for testing purpose. I thought of creating multiple services for NAV 2009, NAV 2009 SP1 and NAV 2009 R2 in same machine with diffrent port numbers, so that we can run RTC also whenever required. My Machine have NAV 2009 SP1 installed and i copied the Classic, Service and RoleTailored Client folder on my C Drive for Other two Versions. I have created two Folders NAV2009 & NAV2009R2 inside "C:\Program Files\Microsoft Dynamics NAV\60". For Creating Service for NAV 2009 i used the command- SC CREATE MicrosoftDynamicsNAV2009 binpath= "C:\Program Files\Microsoft Dynamics NAV\60\NAV2009\Service\Microsoft.Dynamics.Nav.Server.exe" start= auto obj= "NT Authority\NetworkService" type= own For Creating Service for NAV 2009

Create File encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

Hi all, Most of time while trying to attach a database in SQL Server We face a issue. ERROR Message - TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:Databasefilepath.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: ------------------------------ Resolution - While starting SQL Server Managment Studio, dont just double click the icon, Right Click it and select Run As Administrator. Thanks & Regards, Saurav Dhyani

JET Reports In Navision

Hi all, Navision have introduced new type of Reports Jet Reports. Lets see some details about the product. As of today Jet Reports Express for Microsoft Dynamics NAV is available for download at PartnerSource and CustomerSource for customers on an active Business Ready Enhancement Plan. Partner Source  JET Reports For Navision Customer Source  Jet Reports For Navision

TransHeader & TransFooter in RTC Reports

Hi all, While Trying to figure out something new features in Navision RoleTailored Client, I figured out a blog which I find useful to share with you all. Most of the time customer ask for Transheaders and Transfooters in Role Tailored Client(RTC) Reports and we say that it cannot be done as read in Microsoft documents. I tested by creating a report as suggested in the Blog and it worked as expected. Its is done by using the Hash Table in the Report Code Section. Please read the complete blog at here . Thanks & Regards Saurav Dhyani

Database Backup from SQL Server Managment Studio

Hi all, Some Client requires to take database backup on daily basis but due to increasing size of data its is tedious and time consuming if we suggest to go for Navision Backup.At this point the best solution to suggest is to take backup from SQL Server.So lets discuss how to take backup of a database from SQL Server Managment Studio. For taking Backup from SQL Server there are certain steps -

Problem In Dynamics NAV 2009 R2...

Hi all, While browsing over web about new features of Dynamics NAV 2009 R2, i find some information about same in Waldo Blog. The title of the Blog is Dynamics NAV 2009 R2 is not a "normal" release ... beware!.  After reading the Blog i was surprised and thought that every partner and customer should know about the same. So before upgrading to Dynamics NAV 2009 R2, please read the article at Waldo Blog. You can read the post here .        Thanks & Regards, Saurav Dhyani  

Types Of Pages in NAV 2009 and Later...

Hi all, I figured out that lot of us find issues while designing Pages. So I thought why not start writing about Pages. Lets see different types of Pages in this Post and Later on in other posts we can discuss how to create them and transform them.

Server Is Not Enable for Microsoft Dynamics NAV Classic.

Hi all, Yesterday i restored the backup of a R2 Database in Navision. After Restoring i tried to start the role tailored client but i gave me an error. The error is shown is screenshot below. Resolution for the Error- 1) Open the database in classic client. 2) From the file menu, Under databases select ALTER. 3) Go to Options Tab. 4) First check the Single User check box and Then select check for for Enable for Microsoft Dynamics NAV Server. After that click ok and close the database. Then again follow the steps from 1 to 3 and uncheck the Single user and Click Ok. Try Starting Role Tailored Client, it will work now. Thanks & Regards, Saurav Dhyani

Downgrade 2009 sp1 objects into 5.x or older databases.

Hi all, Last week I required to do some customization on 5.x database that i have already done on 2009 SP1. It consist of multiple tables and Reports so i was frusted that i have to do it again for 5.x as i cannot just import the objects of 2009 SP1. While looking for some solution on the web, i find out that Mr. Rashed Amini have developed a tool which can downgrade objects from 2009 SP1 to 5.x and older versions of navision. I used the tool and everything worked fine. What this tool does is  remove the 2009 specific areas out of the text file and then importing them into 5.0 or older can try and test the tool. You can find the tool on Rashed Amini Blog here   here (Updated on 16-11-2015) . Thanks To  +Preslav Velkov  for the Updated Link. Thanks & Regards, Saurav Dhyani

Finding Application Build For Navision

Hi all, While Locking a case in Microsoft Partner/Customer Source it asks about the certain details about Navision Version being used. Most of us find issue where it ask for Navision Build. So in this post we will see where we can find the Application Build for Navision we are using.

Data port with Headers

Hi all, Most of time customer requires data from Navision, but they also request to have headers in the output. We create a dataport but the problem occurs while having headers for the values. Let’s see how we can do this- Create a new dataport for Customer Table which will export Customer No., Name, City and Contact. Once you are done with creation of dataport and adding dataport fields, go to OnPreDataItem().

Note’s in Navision 2009 RTC

Hi all, While trying to figure out new features in Navision 2009 RTC I figured out a new feature called Notes/Links. In Navision 2009 RTC, you will find a system part called as Notes. Let’s see how we can use this. Below is the image which shows a list of Sales order in Role Tailored Client and you can see a note window in the right hand side. As soon as user opens an existing order or creates a new order, he/she can put his comments about the same and notify the user whose windows login is synchronized in the database. As I opened a sales order, I can see a link for creating a new note in the right hand panel (Fact Box). As soon as user clicks on the link to create a new note, he get a window opened which ask for certain information. 1) Your message/ comments. 2) User Id whose you want to send the notification. 3) A Boolean for Notify. User select one of the user from the list and click on the notify Boolean and then save the note. When t

Show only Date not Date and Time in RTC Reports?

Hi all, Most of the time client requires only date to be printed in the report, say for the shipment date. But when we create the report in RTC and set the dataset field for the shipment date we get data and time. The date in RTC Report shows date and time and that is the standard format. If you want to show only date then we need to use the Format Property. Example Then in Page body click on the expression of the text box which says  “=SalesLine_ShipmentDate” and convert it to =FORMAT(SalesLine_ShipmentDate,"Short Date"). This will only show date. Regards, Saurav Dhyani

How to Start Navision Application Server?

Hi all, We always face issues while using NAS. Lets discuss how we can install, configure and use Navision Application Server (NAS). Go to Server Folder in the installation disk of the Navison version for which you want to start the Navision Application server. Install the server on the disk. This will create a service, go to services.msc to change the startup parameter of the service and use an administrative account to start the service.

RTC Report Development 3.

Hi all, If you haven't read part1 and part2 then click here for Part1 and Part2. Now lets see what can be done to create Page Header without any issues. Lets check what Microsoft do to create Page Header for the same report. Here is what it see the Layout of standard Report.

ERROR The trasaction log for database is full.

Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for  database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where  query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-

RTC Report Development 2.

Hi all, If you haven't read the part first then read it  here. Now when you created the suggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body. The most part of an RTC Report is the Page Header, we all face issues in this. Let's discuss what happens when we say suggest layout.

RTC Report Development 1.

Hi all, we all have some known and unknown issues while creating a Report For Role Tailored Client . we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch. I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1. Then I deleted its existing layout by using Tools->Delete Layout. Now lets create the Layout from Scratch. Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.

Microsoft Dynamics NAV Classic client was opened from an untrustworthy component. Contact your system administrator.

Hi all, A Comman error faced while trying to Run a Report From Role Tailored Client (a report with no layout defined), it try to start the Report Engine from classic Client. It can happen that after updating RTC, you end up with a version of RTC which is not compatible with the default classic client. In this case you will typically get this error message when trying to run the report. First of All you need to find the build of classic and Role tailored client. The Build for both should be same. Following screen shows how to check the build for both client. If the build is diffrent you need to udate the Build using this link (require Partner/Customer source login). If the build is same then we need to find out from where does RTC find the classic client for running classic reports? RTC finds the location of Finsql.exe in this place in registry: (can be opened by typing regedit in RUN) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\

Starting the RoleTailored Client from a Command Prompt

Hi all, We all face situations where clients ask for some  specific   requirement  as per user, as in he want that user cannot see anything other than a certain page or something like this.  By using command line parameters we can  achieve  that.

Statement of Direction for Microsoft Dynamics NAV

Hi all, Most of us always trying to find out about the future release of Microsoft Dynamics Navision. Microsoft have released the statement of Direction for Microsoft Dynamics Navision. Document contain the major release plan from now till 2016-2017, and the gimps of changes that will happen in Navision future Release. The document can be downloaded from here with login credentials for Partner Source. Thanks, Saurav Dhyani

Microsoft Windows XP Multilingual User Interface

Hi all, While Trying to open a database that is created in Navision client with country  specific version we face the error shown below. Error in Classic Client

Change Drill Down in the Page?

Hi all, A friend of mine asked me yesterday that one of his client want to change the Drop Down option in RTC Page. As shown in image below, and client says that when he want to choose item No. he don't want No., Description, Base Unit of Measure, Bill of Materials, Unit Price.

Debugging of Client Add in

Hi all, Debugging of an Add-in in the client is very simple. After the client has started up all you need to do is to attach the Visual Studio to the process of the Role Tailored client. For debugging compile your project with the “Debug” solution configuration.

Use Boolean Variable in Page Property.

Hi all, ­­­­we all have read in Microsoft manuals for NAV 2009 Page Development that most of the page control properties are not limited to values yes and no. Now developer can use a Boolean variable and change the property value on the runtime by using that Boolean variable at run time. But what, when I first tried to use same if didn’t worked and I was amazed so I re- read the manuals but didn't find any resolution for the same.

Extended Stored Procedure xp_ndo.dll Error (64 Bit)

Hi all, When we install Navision 2009 and later on 64 bit operating system, most of us get error like shown below while we try to connect Role Tailored Client or Classic with Windows authentication. In this article, we will discuss why this error message and how to resolve this.

Extended Stored Procedure xp_ndo.dll Error

Hi all, We may face this error while trying to connect Role Tailored Client or Classic Client with Windows Login. Reason for the Error Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures do not exist, you will get this error when trying to log on using Windows Authentication:

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

Run Multiple Services in Navision R2

Hi Readers, We all face issues with clients where they want my to run RTC for multiple Databases. Thanks to Kine for providing solution for same. Kamil Sacek (Kine) provided a solution by creating a solution for the same. This can be downloaded from  here . Steps to follow to setup multiple services in NAV R2-

Error After Installation of Microsoft Dynamics Navision R2.

Hi Readers, While trying to install the Navision 2009 R2, most of us get the below given error. “Service 'Microsoft Dynamics NAV Server' (MicrosoftDynamicsNavServer) failed to start.  Verify that you have sufficient privileges to start system services.”

Microsoft Dynamics Navision Certification

Hi all, I found most of the people asking questions about certifications that are provided by Microsoft for Dynamics Navision. Here is a list of certifications provided by Microsoft. Microsoft Certified Technology Specialist for Microsoft Dynamics NAV Help boost your professional qualifications by earning a Microsoft Certified Technology Specialist (MCTS) for Microsoft Dynamics NAV certification. This certification helps verify your technical proficiency in one module of Microsoft Dynamics NAV, a comprehensive business management solution used worldwide by small and medium-sized organizations. Certifications There are 15 Technology Specialist certifications for Microsoft Dynamics NAV. You must pass one exam to obtain each certification. Exam Exam number Microsoft Dynamics NAV 2009 C/SIDE Introduction Or Microsoft Dynamics NAV 5.0 C/SIDE Introduction Exam MB7-840 Exam MB7-514 Microsoft Dynamics NAV 2009 C/SIDE Solution Development or Micros