web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

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

Suraj M Patel Profile Picture Suraj M Patel 332
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”.

 

Path


 

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

 

Form

 

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

 

Excel Buffer Function

 

Step 4 – Calling from a Report

 

Function Call

 

And it’s done.



Your valuable comments and feedback are appreciated.

"Power is gained by Sharing Knowledge not hoarding it"

This was originally posted here.

Comments

*This post is locked for comments