PaulsenConsult.com, Microsoft Dynamics NAV Consulting
PaulsenConsult.com
 PaulsenConsult.com

Reporting on the Chart of Accounts

When it comes to Microsoft Dynamics NAV General Ledger reporting, the first thing you can do is to simply look at the Chart of Accounts.

 

 

Chart of Accounts with Date Filter

 

If you click the small black drop-down arrow next to the blue heading Chart of Accounts a section called Limit totals to: opens, where you can set a Date Filter.

Microsoft Dynamics NAV - Chart of Accounts - Date Filter Dynamics NAV - Chart of Accounts - Date Filter

In this example, the Date Filter is set to ..01/31/2016 meaning up to the 31st of January 2016. The Balance at Date column observes this filter and reports the balance on all G/L Accounts as of 01/31/2016. The Balance column ignores the Date Filter and shows the current balance on all G/L Accounts.

 

On the Home tab of the Ribbon you can find a Send to Excel button which simply exports the content of the window you are looking at to Excel. Whether such an Excel sheet is particularly usefull depends on what you want to report on.

Microsoft Dynamics NAV - Chart of Accounts - Ribbon Dynamics NAV - Chart of Accounts - Ribbon

 

Standard Reports

 

The next thing you can do is to take a look at the REPORT tab in the Ribbon. The reports are pretty much self-explanatory except for the Account Schedule which is a reporting tool allowing you design your own reports.

 

You can print reports out to paper or preview them on your screen. When you preview a report on your screen, you have the option to save it as an Excel, PDF, or Word file:

Dynamics NAV - Report Trial Balance Detail/Summary Dynamics NAV - Report Trial Balance Detail/Summary

 

Chart of Accounts Overview

 

In the NAVIGATE tab of the Chart of Accounts ribbon you can find a link Chart of Accounts Overview:

Dynamics NAV - Chart of Accounts - Ribbon Dynamics NAV - Chart of Accounts - Ribbon

In the Chart of Accounts Overview window you can expand or collapse sections of the Chart of Accounts. Notice our new G/L Account 11399 Checking Accounts shows the total for all checking accounts. If you click the triangular icon in the No. column the section expands and shows the individual checking accounts that make up the total.

Dynamics NAV - Chart of Accounts - Overview Dynamics NAV - Chart of Accounts - Overview

 

G/L Balance by Dimension

 

 

Microsoft Dynamics NAV - G/L Balance by Dimension Dynamics NAV - G/L Balance by Dimension
Microsoft Dynamics NAV - G/L Balance by Dimension Matrix Dynamics NAV - G/L Balance by Dimension Matrix

to be continued...

Contact

PaulsenConsult.com
4300 Jog Road #541824

Green Acres, FL 33454


Phone: +1 561 275-9519+1 561 275-9519

E-mail: Thomas@PaulsenConsult.com

Print Print | Sitemap
©PaulsenConsult.com Microsoft Dynamics NAV and Microsoft Navision are registered trade marks of Microsoft Corporation