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 Excel and performing the pivot table operation on the entries to give a precise results.

Bron : Cloudfronts
Lees meer…

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?

Bron : ArcherPoint
Lees meer…

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.

Bron : ArcherPoint
Lees meer…

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?

Bron : ArcherPoint
Lees meer…

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.

Bron : Gunnar’s Blog
Lees meer…