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

Wednesday, December 25, 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.


Friday, December 20, 2013

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.

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

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

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

Monday, December 2, 2013

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

Monday, November 25, 2013

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

Tuesday, November 19, 2013

Monday, November 18, 2013

Sunday, November 17, 2013

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

Saturday, November 9, 2013

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

Monday, October 28, 2013

Saturday, October 26, 2013

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.

Saturday, October 19, 2013

Tuesday, October 15, 2013

Wednesday, October 9, 2013

Monday, October 7, 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

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

Tuesday, September 17, 2013

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

Saturday, September 7, 2013

Saturday, August 31, 2013

Wednesday, August 21, 2013

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

Thursday, August 8, 2013

Thursday, July 18, 2013

Wednesday, July 17, 2013

Sunday, July 14, 2013

Saturday, July 13, 2013

Friday, July 12, 2013

Thursday, July 11, 2013

Wednesday, July 10, 2013

Tuesday, July 9, 2013

Wednesday, June 26, 2013

Tuesday, June 25, 2013

Monday, June 24, 2013

Sunday, June 23, 2013

Saturday, June 22, 2013

Friday, June 21, 2013

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

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

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.

Tuesday, June 11, 2013

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

Monday, May 20, 2013

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

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

Monday, April 8, 2013

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.

Thursday, February 7, 2013

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

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/