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 Excel and performing the pivot table operation on the entries to give a precise results.
Tag Archives: Pivot
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 out is: Did postings go to the correct General Ledger Accounts?
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 analysis like
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 Bin Contents Table, I could export the data to Excel and create a Pivot Table to present the information.
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 want to find out is: Did postings go to the correct General Ledger Accounts?
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 ledger tables.