Skip to main content

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



We have synchronized Windows Login of X1, X2 & Y in Navision Database.


Story / Requirement -

Client Y Require to See below listed information in excel (Every Day)-
1) Release Sales Orders.

* But as per management we cannot provide access to Navision to Y.

Solution -

We have below listed options -

1. Either Client X1 or X2 Provide List to Client Y Daily by exporting it to excel.

2. We can have a report which can be automated using NAS to send daily to Client Y.

3. We can use the Excel Integration.

Solution Analysis -

Solution 1.
What if Both X1 & X2 are not in office ?
What if Y Requires the List At 8:00 AM but X1 & X2 reach office at 11:00 AM?


Solution 2. 
What is the filters have been changed, Partner intervention required to do customization.

Let's see how we can use Excel integration to full fill requirement of Client Y -

As discussed in Post 1, Either X1 or X2 can use Excel Integration with Navision 2013 and  Export Filtered Sales Order List to Excel.

As per Y Requirement, X1 / X2 Created the filtered view and exported it to Excel. The Excel Sheet will look like as shown below.


The First Row shows the service Path which points to Server B.

Q & A -

1) Does User Y have rights to use the service tier (server B) ?

YES.

2) Does User Y have Refresh Tab in Excel to get the updated information from NAV?

NO.

In the next post we will see how we can bring that Dynamics NAV tab in User Y Machine.

Regards,
Saurav Dhyani

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

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. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.