NAV 2009 R2 and Lower - Save Export to Excel - At a specific Location

Hello Everyone,

If we want to Export Data to Excel and Save that file at a particular location, here is one of the simplest way to do it.

We all know the famous blog of Saurav Dhyani – “NAV 2013 & NAV 2013 R2 - Save Export to Excel” – But it is for Navision 2013 and above.

 

http://saurav-nav.blogspot.in/2014/01/nav-2013-nav-2013-r2-save-export-to.html

 

 What if we want to do the same in Navision Older Version?

 

Here is the way,

 

Step 1 – Create a Field in Setup Table in my case its “Sales & Receivables Setup”.

 

 

Step 2 – Adding that field to Form “Sales & Receivables Setup”

 

 

Step 3 – Add a function “Save Excel File” in Table 370 Excel Buffer

 

 

Step 4 – Calling from a Report

 

 

And it’s done.

Your valuable comments and feedback are appreciated.

"Power is gained by Sharing Knowledge not hoarding it"