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 →

Creating Matrix Reports in Nav 2013 R2

In this article we are going to see how to create a Matrix Report , Matrix reports display grouped data and summary information. You can group data by multiple fields or expressions in row and column groups.A matrix  report grows horizontally and vertically on the page lets see how to create one  inventory  matrix report based... Continue Reading →

HAPPY NEW YEAR 2014.

Wish you all a very happy and fun-filled New Year, hope there is no end to the world, there is still lot to be seen. .. 🙂 “We will open the book. Its pages are blank. We are going to put words on them ourselves. The book is called Opportunity and its first chapter is... 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 →

Blog at WordPress.com.

Up ↑