Wednesday, January 29, 2014

NAV 2013 - Update Rollup 10 Released.

Hi all,

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

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

   Update Rollup 1 to 6

   Update Rollup 7

   Update Rollup 8

   Update Rollup 9

Title - Update Rollup 10 for Microsoft Dynamics NAV 2013
Build No. - 36005
Release Date - January, 2014
Local Version Included - AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK

Download Link

These links required valid Partner Source / Customer Source Login...

Saurav Dhyani

Friday, January 24, 2014

NAV 2013 R2 - Multi- Tenancy - Tables with Data Comman to All Companies.

Hi all,

I found one more issue after applying Multi - Tenancy to my database.

Here is the problem -

When i try to create a table with DataPerCompany Property Set to NO, Developer Environment give an error message saying

"There are multiple tenants mounted on the server. Validating table layout changes to protect against data-loss is only supported with a single tenant mounted on the server."

Thursday, January 23, 2014

NAV 2013 R2 - Multi-Tenancy Environment Web Client.

Hi all,

Till now we have seen how to implement Multi-Tenancy. Today let's discuss the web client in  Multi-Tenancy Environment.

Now what changes do i need to do to run a Web client for a specific Tenant. Suppose i want to run web client for all the Tenants.

Objective of Post -

1) Configure the Web Server for the Service MultiTenancy.
2) Access the web client with all Tenants.

Tuesday, January 21, 2014

NAV 2013 R2 - Multi-Tenancy Run Objects from Developer Environment.

Hi all,

As we discussed in earlier post about Multi-Tenancy, we are facing some issues after implementing the same.

One of the issue was discussed in earlier post. In this post we will see a common error message after Multi-Tenancy i.e "I cannot run the object from Object Designer after implementing Multi-Tenancy".

Monday, January 20, 2014

NAV 2013 R2 - Multi-Tenancy Errors.

Hi all,

During implementation of MultiTenant we have discussed that there are some data common to all companies tables which remain in the application database.

Let's open the application database from SQL Server and see the list.

Now let's open the Windows Client and try to add records in any of these tables.

Saturday, January 18, 2014

NAV 2013 R2 - Where is the Tenant Information Stored?

Hi all,

During Previous Post we have successfully migrated from a single tenant to Multi Tenant Environment.

But there are some questions in my mind and may be in your mind also.

a) From where system identify that the Service Instance is Single / Multi Tenant?

b) Where exactly the Information about Tenants stored in the system?

Friday, January 17, 2014

NAV 2013 R2 - Multi-Tenancy Part 4

Hi all,

Previous Post in this series are -
  - Implementing Multi-Tenancy Part 2.
  - Implementing Multi-Tenancy Part 3.

This post was created due to questions from multiple readers about existence of Default Tenant.
1. Do we need Default Tenant if there are no Companies?
2. Is Default Tenant is Mandatory?

The answer of both the questions is No.

So what we will see in this post is -

1. Move to Default Company in a separate Tenant say Test.
2. Delete the default Tenant.

Thursday, January 16, 2014

NAV 2013 R2 - Multi-Tenancy Part 3

Hi all,

Previous Post in this series are -

In This post we will move to next steps to Creating Multiple Tenants From Customer Database.

Till Now, We have separated the Application, Data Part, Configured Service Tier & Mount The Application & Customer Data in Service Tier.

Wednesday, January 15, 2014

Tuesday, January 14, 2014

Monday, January 13, 2014

Friday, January 10, 2014

NAV 2013 & NAV 2013 R2 - Save Export to Excel

Hi all,

In Last post we had seen how to use export to Excel Reports in NAV 2013.

The Next question asked to me is with older version with some code we used to able to save the Report at a specified path instead of opening it. Is it possible with NAV 2013 and later?

So here it is, we can again create some functions in excel buffer and save the excel files.

This article Applies to Microsoft Dynamics NAV 2013 & NAV 2013 R2. Attached Screens are from NAV 2013 R2.

Thursday, January 9, 2014

NAV 2013 & R2 - Export to Excel Report With Enter Cell.

Hi all,

Yesterday we had seen the changes in Excel Buffer in NAV 2013, but there is one more conman way that we used to use in NAV 2009 For Export to Excel Reports (i.e Enter Cell Function in Report).

Lets discuss that today. The Idea for this post came from Ms +shubhangi verma.

Let's see what changes we need to do in a export to excel report created in NAV 2009 or Previous Version to use in NAV 2013 with ENTERCELL.

Wednesday, January 8, 2014

NAV 2013 & R2 - Export to Excel Report

Hi all,

Let's see the Changes in Excel Buffer Table in NAV 2013 as compared to NAV 2009.

1. As automation are discountinued in NAV 2013, Microsoft have created a DLL for Excel Operations.

2. A new field added in Table "Cell Type", used to specifying type of field.

Tuesday, January 7, 2014

NAV 2013 R2 - Copy A Company.

Hi all,

Today post is a simple post about copying a company within a database with diffrent name.

This post was on request of +chandru s  , so all thanks to him that you all are reading this.

I have done this in Cronus IN Database. Currently it had only company as shown below.

Monday, January 6, 2014

NAV 2013 R2 - Multiple Web Clients.

Hi all,

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

*Thanks for the update +Mukesh Verma, sorry for misleading information.

We had already done it in NAV 2013, Let's try to do it on NAV 2013 R2.

The requirement was raised by Mr. +Ganesh S. All thanks to him for finding that there are changes in NAV 2013 R2 for multiple web clients.

Saturday, January 4, 2014

NAV 2013 R2 - Introduction to PowerShell.

Hi All,

With Release of NAV 2013 Microsoft have introduced one more component of NAV Administrators.

Yes that is Microsoft Dynamics NAV 2013 R2 Administration Shell.

With Release of NAV 2013 R2 one more pr-requisite before installing Navision is Powershell which comes up with a windows Update.

Powershell can used to access all Cmdlets available for windows. we can also use same for running Cmdlets for NAV 2013.

Thursday, January 2, 2014

NAV 2013 R2 - Update Rollup 2 Released.

Hi all,

Details of Update Rollup 1 For NAV 2013 R2.

The details of Second Update Rollup released for Microsoft Dynamics NAV 2013 R2 are as follows -

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

Download Link

Update rollup 2 includes Cumulative Update 1 for Microsoft Dynamics NAV 2013 R2.

To Access Link you requires to have a valid Partner Source / Customer Source Login...

For all Rollup Released Till Date for NAV 2013 and 2013 R2 follow the link.

Saurav Dhyani