Pivot – Pardaan.com

Applying Pivot Table in Excel using Automation Server Objects in NAV

In NAV when building a custom report that deals with totalling the amount by multiple G/L accounts by week then the report becomes tough to read as well as develop in standard SSRS Report. A possible and easy workaround is dumping all the entries in the…

30 August 2018

Dynamics NAV & BC Tips & tricks

Using Microsoft Excel Pivot Tables to Verify Posting Group Setup and Analysis in Microsoft Dynamics NAV

In the early stages of a Dynamics NAV implementation, it is essential to verify your Posting Group Setup through testing. Excel Pivot Tables are ideal for this analysis. We will use a Dynamics NAV Finished Production Order to illustrate this concept. What we want to find…

15 December 2014

Dynamics NAV & BC Tips & tricks

Query Object Data usage in Power Pivot – NAV 2013

What is a Power Pivot?? What do we achieve with it in NAV? In General, Power Pivot as we all know is a data exploration tool. With OData and Power Pivot, we gain access to a powerful set of tools and technologies for data exchange and…

5 September 2013

Dynamics NAV & BC Tips & tricks

Quick Reporting in Dynamics NAV Using Microsoft Excel Pivot Tables

Yesterday a client called and asked if there was a report in Dynamics NAV that listed inventory on hand and in which warehouse bins the inventory was located. I did not find a report for this, so I thought that if I could get to the…

10 July 2013

Dynamics NAV & BC Tips & tricks

Using Microsoft Excel Pivot Tables to Verify Posting Group Setup and Analysis in Microsoft Dynamics NAV

In the early stages of a Dynamics NAV implementation, it is essential to verify your Posting Group Setup through testing. I have come to rely on Excel Pivot Tables for this analysis. I will use a Dynamics NAV Finished Production Order to illustrate this. What I…

3 July 2013

Dynamics NAV & BC Tips & tricks

Creating an Excel Pivot table from a ledger table

I just finished creating a report that can export job ledger entries to Excel and build a Pivot Table for analysis of the data. Global dimensions and data from master, supplement and tables are included in the export. A similar report can be built for other…

19 June 2012