Skip to main content


Showing posts with the label TBD

Save Navision RTC Reports into PDF, Word & Excel..

Hi all, If you would have noticed with the introdcution of RTC Client in 2009 i.e NAV 2009, in C/AL Symbol Menu Report have some new options.

Add a language layer from database objects.

Hi All, Let's discuss a conman Question mostly asked/raised during Upgrade Process. How do i add a language Layer to my Database.

Numbering in NAVISION...

Hi all, I always used to get confused during development about numbering of objects & fields. Today i browsed and found out a link which explain mostly all the commonly used numbering patterns in Navision.

NAS Configuration Before NAV 2013

Hi all, As discussed in earlier post about NAS Installation . Let's proceed with NAS Configuration. From Start Menu or Administrative Tools under Control Panel Open - Application Server Manager for Microsoft Dynamics NAV.

JET Report Configuration Issues..

Hi all, Let's see common issues faced with JET Report and there resolutions. The Best way to find issue is - 1) Open Excel. 2) Click on Data Source Settings and see Color of Icon in Left Bottom. 3) If its Red there are some configuration error, click on Hyperlink Next to Red Icon.

Configuration of JET Reports.

Hi all, For Installation of JET Report Please refer post . Let's see how to configure JET Report for using Report Development or Viewer.

Installation of JET Reports.

Hi all, Let's see how to install JET Report Addin for Dynamics NAV till NAV 2009 R2. For Installing JET Report Please download Jet Report from Link . * To get access to the link you need to have an account with JET Report.

What is Use of Attach file in Open Database Window ?

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

Tip #1 - Account used to Run Services For Navision RTC ?

Hi all, TIP FOR CONSULTANT, not to be followed in Customer Environment. The account need to run Services of NAVISION RTC Client as per Microsoft Documents Should be a Domain Account with Password expiration policy set to False. What if you are not in domain and the database and service are in your local machine? If you are working at home and don't have a internet connectivity that can connect you to domain. Does this service Work? NOT of Course.

Started Tips & Tricks

Hi all, Starting a new series - Tips & Tricks. This Group of articles will contain Small Articles (may be one Line) which we need to take care during Use of Navision. These will be Grouped Under Label Tips & Tricks . Regards, Saurav Dhyani

Multiple Copies Classic & RTC with Report Page No. Reset with Each Copy - Part 2

Hi all, Let's Continue with the part that we left in last session ( Reference Article 1 )- So we were done with classic report, let try to do same on RTC Too. Again from taking reference from Report 206 we follow below listed steps -

SQL Maintenance Plan with Database Mail.

Hi all, As discussed in last two post about 1) How to Configure Database Mail in SQL Server. 2) How to create operator in SQL? Let's see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan. There are many Default maintenance Task available in SQL, but for demo we will be using Complete Backup Maintenance Task.

How to create operator in SQL?

Hi all, I hope everyone is great. As discussed in last post , lets have a look on how to add operators in SQL. Use of Operator - The operator is used in SQL Management Plans and Jobs to send mail in case of Success or Failure of Jobs. We will discuss how to create jobs and SQL Maintenance Plans in a separate post. As of now let's stick to agenda and discuss how to create the operator.

How to Configure Database Mail in SQL Server.

Hi all, Let's see how to configure Database Mail in SQL Server. we will see use of same in future post. Open SQL Server Management Studio. Open Management and Right Click Database Mail as shown below.

The Breakpoint Already Exist...

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.

NAV 2013 Upgrade Part IV - SQL Migration.

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.

The date format is incorrect in an Excel worksheet when you export in excel via RTC Client

Hi all, Today i created a processing only report in navision classic client which used to pull some data into excel. The format contain the date fields too. Now while running that report from classic client it works great but while running report from RTC client the date format was incorrect. If the report would have the field then i would have changed the date format in the RTC Report layout but that was not the case.

Unhandled thread exception caught. Exception while trying to create an instance of the Dynamics NAV integration pages

Hi all, After installing  Connector for Microsoft Dynamics NAV with CRM and during configuration we get below error message. Unhandled thread exception caught. Exception while trying to create an instance of the Dynamics NAV integration pages

Action Image in Navision 2009, 2009 SP1 & 2009 R2

Hi all, While Developing Pages for Role Tailored Client we face issues when we create an action an set its prompted to true, and want an image for the action. Below is the screenshot of the page property where we set the image for an action.

Error 47-1 During Export Objects as Text

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