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 →
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 →
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 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 →