Dimensions – Detail Report in Dynamics NAV

Default Dynamics NAV reports. You either hate them, or you love them. You either use them consistently, or you don’t even know they exist. So, let’s have a look at a one of default Dynamics NAV reports called Dimensions – Detail Report.

Financial Management > General Ledger > Reports > Dimensions – Detail
Dimensions - Detail Report

Dimension – Detail Report displays a detailed classification of how dimensions have been used on entries over a selected period. The entries shown in the report are linked to a particular analysis view. Therefore, only entries with dimensions or dimension combinations that are included in the analysis view you have selected will be included in the report.

The report can be used to investigate which activities use which dimensions, and how individual dimensions are combined with other dimensions on specific entries. For a less detailed analysis of dimensions, you should use the Dimensions – Total report.

You can define what is included in the report by filling in the fields on the Option tab as follows:

  • Analysis View Code: Here you can enter the code for the analysis view you want the report to be based on. To select among the analysis view codes you have set up in the Analysis View table, click the AssistButton in the right of the field.
  • Include Dimensions: Here you can enter the dimensions that you want to include in the report. You can only select dimensions included in the analysis view that you select in the Analysis View Code field. To see the dimensions that are available, click the AssistButton in the right of the field. To include dimensions, define Levels you would like to analyse:
    Dimensions - Detail Report - Define Dimension Levels
  • Date Filter: In this field, you can set a filter to filter entries by date. You can enter a particular date or a time interval.
  • Print Empty Lines: Place a check mark in the field if you do not want the report to include dimensions and dimension values that have a balance of zero.
  • Show Amounts in Add. Reporting Currency: Place a check mark in the field if you want the amounts on the report to be shown in the additional reporting currency.

By running same report (with different dimension levels selected), you might get different outputs:
Dimensions - Detail Report - Print Report

But, generally, Dimensions – Detail report should allow you to analyse how dimensions are being used for your general ledger postings.

This entry was posted in Dynamics NAV / Navision, functionality and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *