Thursday, February 9, 2017

How to Use of Excel Buffer in MS Dynamics NAV 2016

NAV 2016 - USE OF EXCEL BUFFER TO EXPORT DATA IN EXCEL.

Hi All,
This post is written on the requirement of one of my client to export data from NAVISION in Excel format and using some formatting requirement.In this article we will discuss how to achieve Export To Excel using Excel Buffer in NAV 2016.

Requirement :- To export Vendor Ledger entries in required format.
Select the DataItem.



Add the Global Variable , Text Constant and functions used while using export to excel functionality for this report. Copy paste these from Report 6 Trial balance.These are the few triggers on report where you need to add the functions to call excel buffer functionality. Use these according to your requirement. for reference you can follow this.

MakeExcelInfo() function is used to generate Information page in resulted excel sheet. I had customised this function.


This function at end contains MakeExcelDataHeader. I customised it accordingly.



Now you have to customise MakeexcelDataBody()



Finally you have to add CreateExcelBook()




Summarizing the whole Post the main Functions you need to customize are

MakeExcelInfo() ,
LOCAL MakeExcelDataHeader(),
MakeExcelDataBody().

For reference you may see the concept in Trial Balance report 6 in NAV.
You may Download the created FOB from here.
Report FOB DownLoad