Tuesday, December 31, 2013

HAPPY NEW YEAR - 2014...

Hi all,


Some great Lines from —Neil Gaiman Which i would like to Share with you all.

“I hope that in this year to come, you make mistakes.

Because if you are making mistakes, then you are making new things, trying new things, learning, living, pushing yourself, changing yourself, changing your world. You're doing things you've never done before, and more importantly, you're Doing Something.

So that's my wish for you, and all of us, and my wish for myself. Make New Mistakes. Make glorious, amazing mistakes. Make mistakes nobody's ever made before. Don't freeze, don't stop, don't worry that it isn't good enough, or it isn't perfect, whatever it is: art, or love, or work or family or life.

Whatever it is you're scared of doing, Do it.

Make your mistakes, next year and forever.”

Sunday, December 29, 2013

NAV 2013 R2 - Mutlitenant Concept

Hi all,

With Release of NAV 2013 R2 a New Concept have been coined by Microsoft i.e Multi-tenant.

In this post we will try to understand the concept of Multi tenant and in next post we will see how we can actually implement it with the help of a demo database.

JET Reports - Types of Jet Users.

Hi all,

For all Earlier Post Related to Jet Report Please follow the Link


In this post we will see Types of Jet Users. You might be thinking why it is important to discuss this but you will find it useful when you are actually creating Reports for a Customer.

Without Wasting much time Jet Report Users Are Classified Into Three Types.



JET REPORT - Menu Introduction Part 2.

Hi all,

Let's see part 2 of detailed explanation of Jet Report Menu available in Excel after installing Jet Reports.

For all Earlier Post Related to Jet Report Please follow the Link.

Once we are done with the Menu Options we will see how to create Jet Reports.

In Last Post we have Covered Following Menu -
a) Settings.
b) Information.

Friday, December 27, 2013

Do You Know - Number of Parameter In Message & Error Functions?

Hi all,

Just a small post to share something which i found today.

DO You know how many Parameter are supported by Message and Error Function in Navision?


Wednesday, December 25, 2013

NAV 2013 R2 NAS - Where is my NAS Default Company in Service?

Hi all,

This post is about the Change is Service Tier Between NAV 2013 and NAV 2013 R2.

I was trying to configure NAS in NAV 2013 R2 and was stuck because i don't see the Company Parameter as we had in NAV 2013.


NAS - Email Intimation when NAS Services Stops.

Hi all,

A common question that we have in mind about NAS is -
what happens if NAS Services are turned off?

We are mostly looking for something like a E-mail Intimation to Administrator.

This article is based on inputs provided by +Arul Venthan  and +Neha Pr .

This article is not for NAS Service only. This applies to all windows services and can be setup for any of them.


Saturday, December 21, 2013

Friday, December 20, 2013

NAV RTC - Get Data From Navision in a External Application using Web Services - Part II

Hi all,

Let's See Today How to Read Data From Navision Using an External Application - Part 2.

If you haven't read post 1 then Read Here.

Step - 4 Connect the windows Application to Navision Using Web Service.

Thursday, December 19, 2013

NAV RTC - Get Data From Navision in a External Application using Web Services - Part 1

Hi all,

Let's See Today How to Read Data From Navision Using an External Application - Part 1.

Agenda for Part 1 & Part 2 -

Part 1 -
1) Create a codeunit in Navision to get inventory when user sends the Item No.
2) Create & Publish a Web Service in Navision.
3) Create a Windows Based Application in Visual Studio.

Tuesday, December 17, 2013

Review - Microsoft Dynamics NAV Financial Management.

Hi all,

I recently got a chance to Read a Book (thank you, Tobin) on – Microsoft Dynamics NAV Financial Management.

A Book By - Cristina Nicolàs Lorente & Laura Nicolàs Lorente.

This is the first time i was reading any functional book about Microsoft Dynamics Navision, and if i am not wrong we have very few of these in market.

This book is different from the books that we get from PartnerSource as a partner. The books in PartnerSource target to people who understand the specific business area.

Most of the  Books that are available in market are for the Techi's (People like me and most of my readers) and did not focus on how business work in Navision.

NAV 2013 - Update Rollups 9 Released.

Hi all,

Please find below the updates on Update Rollup 9 released for Microsoft Dynamics NAV 2013.

For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 below are the links -

   a) Update Rollup 1 to 6
   b) Update Rollup 7
   c) Update Rollup 8


BEFORE NAV 2013 - SMTP SETUP WITH Port No. Other Than 25.

Hi all,

You might have faced and resolved this issue as it is a common problem.

This article is intended for those who haven't faced issue Related to Non Standard SMTP Port during SMTP Setup till NAV 2009 R2.

Saturday, December 14, 2013

SSRS - Configuration & Issue Resolution.

Hi all,

As per the previous post we have configured the SQL Server Reporting Services.

For getting access to Reporting Manager you need to click URL in Report Manager URL tab.
* You will find it again on Reporting Services configuration Pane.

While navigating to the page you might end up with an error message saying -

"This page might not function correctly because either your browser does not support scripts or active scripting is disabled."

Thursday, December 12, 2013

How to Configure SQL Server Reporting Services

Hi all,

In this post we will see how we can configure SQL Server Reporting Services.

Tuesday, December 10, 2013

JET REPORT - Menu Introduction.

Hi all,

I was thinking from so long about Sharing my knowledge about Jet Reports.
I will be posting articles about Jet Report from Now on.

So let's start with introduction.

-- For Installation of JET Report (Before NAV 2013) Follow Link.
-- For Configuration of JET Report (Before NAV 2013) Follow Link.
-- For Installation & Configuration of JET Report (After NAV 2013) Follow Link 1 & Link 2.

Monday, December 9, 2013

NAV 2013 R2 - JET REPORT Configuration with NAV - Part 2

Hi all,

We will start the configuration of Jet Report from the point where we left in Post 1.

we have completed the installation and imported objects into the database.

Thursday, December 5, 2013

NAV 2013 R2 - JET REPORT Configuration with NAV - Part 1

Hi all,

I guess most of us know how to install JET Reports. If you still don't know then just follow the steps in Post.

The Configuration before NAV 2013 is different than in NAV 2013 or Later.

Reason - JET Report used C Front till NAV 2009 R2 to connect to database. As now C Front component have been discontinued by Microsoft.

Tuesday, December 3, 2013

NAV Three Tier - Auto Kill Idle Session..

Hi all,

This question was asked by one of my Friend, and i thought i will share will all.

Normally we have some code written till NAV 2009 or in SQL to kill an Idle Navision Session.

Monday, December 2, 2013

NAV 2013 & R2 Report - Repeat Table Header on New Page.

Hi all,

I guess i am late in posting this but i will still share with you all.

This change is after NAV 2013 that the table header dosen't repeat when there is a next page.

Sunday, December 1, 2013

Update Rollup 1 For NAV 2013 R2 Released.

Hi all,

Please find below the details of first Update Rollup released for Microsoft Dynamics NAV 2013 R2.






Title - Update Rollup 1 for Microsoft Dynamics NAV 2013 R2
Build No. - 35701
Release Date - November, 2013
Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK

Download Link

Saturday, November 30, 2013

NAV 2013 - Update Rollups 8 Released.

Hi all,

Please find below the updates on Update Rollup 8 released for Microsoft Dynamics NAV 2013.

For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 below are the links -

   a) Update Rollup 1 to 6
   b) Update Rollup 7

Thursday, November 28, 2013

NAV 2013 R2 - Cumulative Update 1 - Released Today

Hi all,

The Cumulative Update 1 has been released for NAV 2013 R2 today.

The cumulative update is an application update only. It mainly contains Cash Management features, such as:

Monday, November 25, 2013

Future - What Next After NAV 2013 R2. Code Name - CRETE...

Hi all,

While browsing through Partner Source i found a new news Article about Next thing about Navision.

So What is Crete...

Sunday, November 24, 2013

NAV RTC - Introduction to Web Services.

Hi all,

This post is a introdcution post about web services in Navision.

Agenda for this post -

1) Types of Web Services.
2) Differences between types of web services.
3) How to publish a web service.
4) How to see the published web service in Internet Explorer.
5) How to check all Published Web services.


Saturday, November 23, 2013

NAV 2013 R2 - Upgrade From NAV 2009 SP1 / R2 to NAV 2013 R2 (one Step)

Hi all,

Yesterday Microsoft have released a Upgrade toolkit for Upgrading data from NAV 2009 SP1 / R2 in one single step.

The components needed to upgrade data directly from Microsoft Dynamics NAV 2009 R2 to Microsoft Dynamics NAV 2013 R2 are now available for download.

You can download the upgrade Toolkit from Partner Source.

Wednesday, November 20, 2013

NAV 2013 - EXPAND COLLAPSE in Developer Environment.

Hi all,

With Release of NAV 2013,we had a new feature in Developer environment where we can expand and collapse a section of code.

In this post we will see how we can expand/collapse all code segments in our objects.


Tuesday, November 19, 2013

NAV 2013 R2 - NAVTechDays 2013 Sessions..

Hi all,

NAV Tech Days 2013 was a conference in Belgium this year.

Consultant like me, which are unable to being a part of the conference can see the videos of the sessions.

Monday, November 18, 2013

NAV 2013 R2 - How to Use Report Builder for Report Development.

Hi all,

Most of you may know how to enable Report Builder in NAV 2013 R2. If that is the case you are not required to read ahead.

Sunday, November 17, 2013

How Do I - Series for NAV 2013 R2.

Hi all,

Microsoft have released so many videos on HOW DO I Series for NAV 2013 R2.

Below are the link for the videos.

Tuesday, November 12, 2013

NAV 2013 R2 - Configure a Shortcut to point a Specific Database.

Hi all,

Consider a scenario where your client have two database -

a) Live Database. (Hosted on Port No. 7046)
b) Test Database. (Hosted on Port No. 10046)

Now Client wants to have two shortcuts on User Desktop which should point to Live and Test Database Respectively. User does not require to Select Server and change the database.

Question 1 - HOW RTC CLIENT POINTS TO DATABASE ?

- When you click on Windows Client,by Default it tries to connect to Last Successfully Connected database Service.

Monday, November 11, 2013

NAV 2013 - Import & Export as XML not supported.

Hi all,

Just an informative post, suggested by +Saheli Mukherjee.

When Navision moved to three tier Architecture (NAV 2009), we had a new File type option during export & Import window, i.e XML.

Saturday, November 9, 2013

NAV 2013 R2 - Help Toolkit Download

Hi all,

We will be adding customized Help Page for the customized objects created by us in NAV 2013 R2.

For that we require Help Toolkit which can be downloaded from Partner source.

Download Link.

Friday, November 8, 2013

NAV 2013 R2 - Install and Configure Help Server.

Hi all,

With Release of NAV 2013 R2 the F1 Help have been also changed drastically.

Help server provide help to both client i.e RTC as well as the Web client. Till NAV 2013 we don't have any help on web client.

Earlier we used to have .chm files for Help but now its a web site that has been published on your server.

In this article we will see how to configure HELP Server on server instead of client.

Thursday, November 7, 2013

NAV 2013 R2 - How to Create a New Service Instance..

Hi all,

Most of us know it but i still would like to have a post on this because a keep on getting questions about it.

This post is just list down the steps for creating a new service in NAV 2013 R2. So if you know it you don't need to read ahead.

Wednesday, November 6, 2013

NAV 2013 R2 Windows Client & Web Client with NavUserPassword - Configuring the Credential Type on the Microsoft Dynamics NAV Clients

Hi all,

This is Fourth & Last post in this series. Please make sure that you have read all the previous post before you start reading this post.

All the post related to this series can be found in Introduction Post.

So Let's see what we need to do the configuration on Clients.

Windows / RTC Client -

I will explain this you all in a separate post, as of now just follow the steps as shown below -

1. Navigate to C:\Users\<UserName>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\71

2. Copy the File ClientUserSetting to say D Drive.

3. Open the copied file and do changes for these parameters as shown below.

Tuesday, November 5, 2013

NAV 2013 R2 Windows Client & Web Client with NavUserPassword - Configuring the Credential Type for Microsoft Dynamics NAV Server.

Hi all,

This is third post in this series. Please make sure that you have read all the Previous post before you start reading this post.

All the post related to this series can be found in Introduction Post.

Let's move ahead from where we left yesterday.

31. We need a user that we will use to Run the Windows and web client.

32. Let's Open windows client and create a user.

Monday, November 4, 2013

NAV 2013 R2 Windows Client & Web Client with NavUserPassword - Installation of Security Certificates.

Hi all,

This is second post in this series. Please make sure that you have read the first post before you start reading this post.

All the post related to this series can be found in Introduction Post.

I hope you would have finished all the steps as discussed in Post 1. Let's Move Ahead.

11. As of now if we check the certificate information we will find that its not trusted.
we now need to install the certificate & revocation list on the computer running Microsoft Dynamics NAV Server.

Sunday, November 3, 2013

NAV 2013 R2 Windows Client & Web Client with NavUserPassword - Create a Security Certificate.

Hi all,

This is first post in this series. All the post related to this series can be found in Introduction Post.

This post will focus on creating the files which are required.

We require to create the certificate , Key and Revocation List which will be used in next post.

Create a Security Certificate.
- Certificate. (.pfx)
- Certificate Key. (.pvk)
- Certification Revocation List. (.crl)

Pre-Requisites -
1. MMC.exe.
2. makecert.exe utility (installed with Microsoft Visual Studio).

Saturday, November 2, 2013

NAV 2013 R2 Windows Client & Web Client with NavUserPassword - Introdcution

Hi all,

This thing was asked me many times and i guess that is what most of us are trying to explore these days.

For NAV 2016, Steps have been Reduced, Please Refer here.

This is introduction post for the articles that i will be posting in few days. These articles will be related to use of NAVUSerPassword with NAV 2013 R2 Windows Client and Web Client.

I had already posted same article for windows client in NAV 2013, but from the comments i found that its confusing to most of the readers because of the length of the post.

This time i am breaking the post into some parts.


Happy Diwali to All the Reader.

Hi all,


The festival of lights is just around the corner wish you all a Very Happy Diwali!!


We meditate on the glory of the creator, who has created the universe, who is worth of worship, who is the embodiment of knowledge and light, who is the remover of all sin and ignorance.

May he enlighten our Intellect. Wishes You a Very Happy Diwali. 



Regards,

Saurav Dhyani

saurav-nav.blogspot.in

Friday, November 1, 2013

NAV 2013 R2 Create a New Company.

Hi all,

Yeah i am late for this but today i have installed NAV 2013 R2 on my machine.

So my First Post Goes for NAV 2013 R2 is about Creating New Company.

Monday, October 28, 2013

NAV 2013 R2 Image Library..

Hi all,

During development of pages we sometime get confused while selecting images for actions.

The reason is simple that we don't know how should image will look like if we select a particular option.

Saturday, October 26, 2013

Table of Index - for articles NAS & Email From NAV.

Hi all,

As there are many post regarding for NAS and Email Articles.

Below are links for all these articles.

Automatic Mail Using NAS and SMTP Setup..

Hi all,

I know its been too late for this post, but the final post from the series of posts where we were discussing about NAS and E-mail is here.

Target -

a) To send a email to customer based on E-mail in customer card.
b) The Mail should be send automatically to all the customer who have valid e-mail Id's after 30 days.

NAV 2013 Hotfix - UPDATE.

Hi all,

Please find below the list of New Updates for Microsoft Dynamics NAV 2013.

Saturday, October 19, 2013

Upgrade Error - The database collation cannot be changed if a schema-bound object depends on it.

Hi all,

Found a issue while upgrading from Navision 5 SP1 to NAV 2013 related to database collation.

Posted the issue on mibuso and got the hint to resolve same.

I thought i should share it with you all, so here it is.

Tuesday, October 15, 2013

Export to Excel - With Fixed Column Width / Row Height

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.

Wednesday, October 9, 2013

NAV 2009 SP1 IN - FVU version 3.9 for e-TDS/TCS return.

Hi all,

This post is for Indian Localization customers / partners who use Navision to file TDS.

Monday, October 7, 2013

Microsoft Dynamics NAV 2013 R2: Download Page

Hi all,

Just a small update for all of you.

Microsoft have released NAV 2013 R2 yesterday 06-10-2013.

Friday, October 4, 2013

NAV 2013 - Visual Studio Component Require for Report Development.

Hi all,

As a developer we have to work on various versions of Navision. This task may contain RTC Report Development.

As we all are aware that Every version (2009 Onward) supports different versions of Visual studio for Report development.

Tuesday, October 1, 2013

NAV 2013 - Development Environment Crash During Creation of Report Request Page.

Hi all,

I found a issue while upgrading reports to NAV 2013 and Plan to share same with you all.

During Upgrading Classic Reports with Request Form to NAV 2013 (say from Version 5), while trying to create request page for Report - NAV 2013 Development Environment Crashes.

Friday, September 27, 2013

NAV 2013 - Update Rollups

Hi all,

Please find below the list of Update Rollup released till date for Microsoft Dynamics NAV 2013.



Saturday, September 21, 2013

NAV Certification - Second Shot is back through May 2014!

Hi all,

Just an update for those who are planning to get certified on Microsoft Exams.

Friday, September 20, 2013

NAV 2013 Web Client Access on Local Area Network From Different Machine.

Hi all,

Today's discussion is on Using Navision 2013 Web client on Local Area Network.

I found out that many of us facing issues while trying to access web client from another machine.

First we need to check that is web client is working on the machine where we have deployed/installed it.

Thursday, September 19, 2013

NAV Classic - Open a Form at windows Start-up.

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.

Wednesday, September 18, 2013

NAV 2013 IN Localization Hotfix - TILL SEPTEMBER 2013

Hi all,

Below are the available hotfix released for NAV 2013 IN till September 2013-

Tuesday, September 17, 2013

Navision Classic Client - Shortcut Points to a specific Database.

Hi all,

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

Saturday, September 14, 2013

NAV 2013 R2 New Features...

Hi all,

I was reading blogs which share details about NAV 2013 R2, i thought sharing the link of those articles with you.

Below are some links which list down new features in NAV 2013 R2, so lets go through all of them and explorer what are additional features in NAV 2013 R2 and how its about to make our life Easy.

Sunday, September 8, 2013

NAV 2013 R2 Updated From Direction EMEA Vienna

Hi all,

Directions EMEA in Vienna talked mostly about Microsoft Dynamics NAV 2013 R2. You might be reading like me it on web.

Saturday, September 7, 2013

NAV 2013 R2 - Release Date Announced.

Hi all,

Microsoft have planned to release NAV 2013 R2 (code name Sicily) on or before 31 October 2013.

Saturday, August 31, 2013

Difference between Page Action and Control Action..

Hi all,

While adding actions to pages from view menu we find two options Page Actions & Control Actions as shown below.

Wednesday, August 21, 2013

JOBQUEUE - Test Job

Hi all,

During our previous post we read about installation and configuration of NAS.

Let's try to use this to automate a task.

For this Demo i consider the below scenario.

How to Setup Jobs in Job Queue (Till NAV 2009 R2)

Hi all,

During our previous post we read about installation and configuration of NAS.

Let's see how to setup Job Queue.

Tuesday, August 20, 2013

Cash Management in Microsoft Dynamics NAV 2013 R2!

Hi all,

While Browsing through Microsoft Team Blog i found out that with NAV 2013 R2! Microsoft is adding a new feature - CASH MANAGEMENT.

Features with new release -

a) Cash Management

b) Bank Reconciliation

c) Payments

d) Single Euro Payments Area (SEPA)

For detail information please follow Link.

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

Send Mail with Attachment From Navision

Hi all,

we have seen how to save a report into PDF and how to send mail to a customer.

Let's link these two post in one i.e Mailing statement to a customer into PDF Format.

If you have the old objects set let me brief you what i will be changing -

Email From NAV.

Hi all,

Let's extend the mail feature as discussed in earlier post.

Let's try to send mail to customer with some details like Open Invoice entries from customer ledger entries.

Send Test Mail Using Navision...

Hi all,

Let's see how we can send an E-mail message from Navision.

If you have gone through previous post, we will just be using function which were discussed in those posts.

Let's see what all we need -

1) SMTP Server Settings.
2) Sendor Name.
3) Sendor Email.
4) Receiver Name.
5) Receiver Email.
6) Subject & Body of the Mail.

Tuesday, August 13, 2013

Navision Classic - Save Report in PDF File as User Defined Path.

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.

Sunday, August 11, 2013

Navision SMTP Setup and Uses

Hi all,

Let's discuss and try to find out uses of SMTP Related Objects in Navision.
A Navision Database contain following SMTP Objects -

Table - SMTP Mail Setup
Form / Page - SMTP Mail Setup
Codeunit - SMTP Mail

Thursday, August 8, 2013

How Job Queue works till Navision 2009 R2?

Hi all,

Let's discuss Job Queue in Navision.

If you filter navision database(till NAV 2009 R2) with @*Job Queue* you will find -

-5 Tables.
-6 Forms & Pages.
-2 Codeunits.

Thursday, July 18, 2013

Multiple Web Client Continued...

Hi all,

In previous post we saw how to add multiple web client and host them.

Now if try to Browse the New site Created you might end up with error -

Multiple Web Client in NAV 2013.

Hi all,

As we have multiple RTC Clients, can't we have multiple Web Clients?

A instance of web client run for a single company at a time. What if we require web client for multiple companies.

OR

What if we want to have multiple web clients for two different databases.

Wednesday, July 17, 2013

Impact of User Roles in SQL in NAVISION.

Hi all,

I was thinking about this post form a long time. It's about roles assigned to user in SQL.

Let's see how these roles effect us in Navision.

Tuesday, July 16, 2013

How to Import Text File In Developer Toolkit?

Hi all,

In Previous post we had seen

 A) How to install Navision developer Toolkit 
 B) How to create developer toolkit databases.

Let's see how to import database objects into toolkit database.

How to Create Navision Developer Toolkit Database?

Hi all,

In previous post we had seen how to install developer toolkit.

Now for performing any action in developer toolkit we require a developer toolkit database.

Sunday, July 14, 2013

Multiple NAS Before NAV 2013.

Hi all,

In Previous posts we discussed how to install NAS and configure NAS on your system.

Please move ahead with steps only if you have one NAS installed as discussed in previous post.

*Remember NAS is Company Specific (It means once instance of NAS cannot run for multiple companies).

Saturday, July 13, 2013

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.

Friday, July 12, 2013

Installation Steps of Microsoft Dynamics Navision Developer Toolkit.

Hi all,

Let's see how to install Developer toolkit for Microsoft Dynamics Navision.

This has been discontinued by Microsoft but most of us still requires it during upgrade process.

Thursday, July 11, 2013

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.

Wednesday, July 10, 2013

Delete a language layer from database objects.

Hi all,

During upgrade one of the conman issue is extra language in database objects.

Tuesday, July 9, 2013

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.

Wednesday, June 26, 2013

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.

Tuesday, June 25, 2013

NAS Installation Before NAV 2013

Hi all,

Let's see how to install NAS (Navision Application Server)  in this post.

Monday, June 24, 2013

Code Coverage for Dynamics NAV 2013

Hi all,

Just an update.

While using NAV 2013 i was missing a great tool that was Code Coverage which used to resolve most of issues during debugging.

It was used to show objects that have been called during execution of a Function.

Sunday, June 23, 2013

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.

Saturday, June 22, 2013

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.

Friday, June 21, 2013

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.

Features Not Available in Service Tax – Reverse Charge for Microsoft Dynamics NAV 2013 - India

Hi all,

While browsing the document for Service Tax - Reverse Charge Hotfix Released for Microsoft Dynamics NAV 2013 IN, i found out that there are Some features which are not support by this Hotfix.

Below is the List of FEATURES NOT IMPLEMENTED IN THIS RELEASE -

Thursday, June 20, 2013

Latest Updates from Partner Source

Hi all,

While browsing Partner source i found some nice KB articles which i think of sharing.

Just follow the link below to download the Hot fix or Read the KB Article.

One of the major finding is the Reverse Charge for Microsoft Dynamics NAV 2013 - IN.

Monday, June 17, 2013

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

Sunday, June 16, 2013

Excel Integration With NAV 2013 - Part III

Hi all,

Integration with Excel Continued ... (Previous Article 1 & Article 2)

NAV USERS WHO CANNOT SEE DYNAMICS NAV TAB IN EXCEL CAN START FOLLOWING STEPS FROM STEP NO. 5.

Excel Integration With NAV 2013 - Part II

Hi all,

Integration with Excel Continued ... (Previous Article)

Now lets assume a Live Environment.

Server A have the Database, its a Database Tier (Navision).

Server B have the service, its a Service Tier (Navision).

Clients X1 & X2 have Navision clients.

Client Y is not a Navision User (Navision Client Not Installed).

Excel Integration With NAV 2013 - Part I

Hi all,

Today i will be explaining you the Send to Excel Feature in NAV 2013.

After installing NAV 2013, you might have found 2 Things

Saturday, June 15, 2013

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
http://saurav-nav.blogspot.in/

Tuesday, June 11, 2013

Microsoft Dynamics NAV 2013 on Windows AZURE

Hi all,

During most of the demo session we had seen NAV 2013 on Windows Azure.


Finally Microsoft have released Feature Pack 1 for NAV 2013, which contain tools we will need to implement on Windows Azure.

Tuesday, June 4, 2013

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 -

Monday, June 3, 2013

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

Hi all,

I found lot of Queries about this, so lets try to do this. I Divide this article into three parts -

1) Enabling Multiple Copies in a standard Report - Classic. [This Article]
2) Enabling Multiple Copies in a standard Report - RTC.
2) Set Page X / Y in Multiple Copies printing Reports.

For the Demo i will be using Standard Report 16593 - Excise Invoice. This report have none
of the above listed points.

Monday, May 27, 2013

Quick Entry - An Efficient Way of Data Entry in Microsoft Dynamics NAV 2013.

Hi all,

I was just browsing NAV 2013 during which i figured out a efficient way of entering data in NAV 2013 - QUICK ENTRY.

Monday, May 20, 2013

Get Ready for New Version of NAV - NAV 8 / Sicily

Hi all,

As per my understanding yeah the rumors about new version are true.

CodeName - Sicily (for Navision 8).

Sunday, May 19, 2013

Running Multiple Web Service In NAV 2009, 2009 SP1 & 2009 R2.

Hi all,

In all the previous posts we have discussed about how to create multiple NAV Services to Run Multiple RTC for same or Different version of Role Tailored Client.

But we never discussed about how we can create multiple Web Services.

I required to Publish Multiple Web services and that is the reason i come up with this Post. Hope you will find it use of this post somewhere.

Saturday, May 11, 2013

Integrating with Microsoft OneNote - Part 2


Hi all,

As discussed in earlier post, let's Try use One Note Integration in Local Machine.

If you haven't read the earlier post click here.

1. Open Navision and Open Profiles by Search box or navigating to
   Departments - Administration - Application Setup - RoleTailored Client - Profiles

Integrating with Microsoft OneNote - Part 1


Hi all,

I was just going through article about Integrating with Microsoft One Note in MSDN.

With Microsoft OneNote 2010 integration you can attach notes to customers, items, or invoices. One Note notes can be created for a specific record, but also for a whole page depending on the setup.

Reminder - Pages notes can only be used on pages that are based on a source table. This means that, for example, the Role Center page cannot use page notes.

Sunday, April 28, 2013

NAV 2013 Rapid Start Error - "There is no application associated with the specified file for this operation."

Hi all,

I got an error message due to a mistake done by my during Export Raid Start Package. Spent lot of time to resolve below listed error.


Just thought to share the resolution for same, may be it's save someone time.

Tuesday, April 23, 2013

Configuring a Profile in Role Tailored client


Hi all,

I know most of this know this, but this is some of us who are still doesn't know about configuring the Role center page.

Let's start with the article provided by Microsoft for Configuring a Profile. The article can be read here.

Let's follow the steps and try configuring profile "ORDER PROCESSOR".

Tuesday, April 9, 2013

Max. Page Size in ODATA Parameter.


Hi all,

Today we will discuss the impact of parameter Max. Page size in ODATA Tab of the service tier.


It is called as "Server-Driven Paging in OData Web Services".

Monday, April 8, 2013

Consuming Output of ODATA - Part 1


Hi all,

As discussed in earlier post today we will try to consume output from the ODATA Services.

The best tool that i like for same is Power Pivot, an Microsoft Excel add in.

You can download same from link - Power Pivot

Introduction of ODATA Services In NAV 2013.

Hi all,

Let's discuss about a New Services came up with NAV 2013 - ODATA. In the post we will see the basic introduction about ODATA, how to enable it and how it can be browsed.

Later on we will discuss on how to consume data exposed via ODATA.

Sunday, April 7, 2013

What is the ODATA?


Hi all,

Its been so long from my last post.
Sorry for that, i am busy these days and don't get time to put my experiences in the BLOG.

As we all know a new Service is available in NAV 2013 aka ODATA.

Let's try to figure out what is OData?

OData is Open Data Protocol.

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

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.

Tuesday, January 29, 2013

NAV 2013 New Language for Indian Database

Hi all,

I was comparing NAV 2013 W1 and NAV 2013 IN for some changes that have been done specifically for INDIA.

During comparison i found that all the objects have some changes. When i drilled it down i found that a new language layer have been added in NAV 2013 for India named as ENN.

I was bit amazed to see this, and was confused that may be i would have missed in previous version. But when i checked in NAV 2009 SP1 IN Database i figured it out that its added in NAV 2013 only.

Thursday, January 24, 2013

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.

Wednesday, January 23, 2013

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.

Monday, January 21, 2013

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.

Freeze Pane in NAV 2013

Hi all,

It's been so long from my last post. Sorry but i am busy these days.

Let's have a quick post about the new Freeze Pane that is available in NAV 2013 List Pages and how we can change that freeze pane.

What is freeze Pane?
Freeze Pane means the selected Columns remain fix when you navigate in the page records.

Thursday, January 10, 2013

NAV 2009 Reports - Common Issue & Resolutions..

Hi all,

I know it to late but I wish you all a very Happy  & Prosperous New Year. I am so much busy these days that i can't even make a Blog entry.

So here is the list of points that i will be coming up in next few days (once i will get free) -

As most of us still working on NAV 2009 Reports. Let's figure out the challenges we face during development of RTC Reports.

1) Report Header in First Page Only?
2) Report Header in All Pages?
3) Report Footer in Last Page Only?
4) Report Footer in All Pages?
5) Report Footer in Last Page Bottom Only?
6) Resetting page number while running report for multiple records?

I will be posting entries for all these points, if anyone have any other doubts about RTC Report please add it as comment on this article. I will try to figure out the solution for same and will append the above list.

Let's try to work to RTC reports as easy as it used to be in Classic Version.

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