Nav 2016 Preview Report without Request Page

REPORT.EXECUTE Runs a report in preview or processing only mode without running the request page. The function gets the request page parameter values as an input parameter string. This is the new reporting function added on 2015 version Requirement : preview Sales invoice report without the request page  Create New codeunit to generate the XML … Continue reading Nav 2016 Preview Report without Request Page

Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

While exporting budget from nav 5.1 version system hit following error message The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.   Error hitting on  report 82 Export Budget to Excel Line ExcelBuf.CreateRange(ColumnDimCode[i]) Line This is the standard Nav 5.1  report  bug and Microsoft has already … Continue reading Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

How to save outlook attachments files from Navision ?

we have one new requirement to read outlook from Navision Details User will send one text file. The text file will be on specific format, then program should read new mails from outlook and  download the file to a pacific place . Read the text file and creates item journals and posts it. The main … Continue reading How to save outlook attachments files from Navision ?

How Create Excel Pivot table report from Navision?

A pivot table is a data processing tool used to query, organize and summarize data or information between spreadsheets, tables or databases. Dragging and dropping fields into a pivot table facilitates rotational, or pivotal, structural changes. Using excel automation we can create the excel  Pivot table report from  Navision This is one example to analyze … Continue reading How Create Excel Pivot table report from Navision?