Microsoft NAV 2013 R2, NAV 2009 .

Take your financial reporting to the next step with with Microsoft Dynamics Nav (Navision) Account Schedules

Microsoft Dynamics NAV account schedules are a powerful tool used to create custom financial statements directly from the general ledger. Many of our clients master creating various types account schedules including balance sheets, income statements and cash flow statements.  What is not as well known though is that advanced dimensions are also available from the account schedule area. Advanced dimensions are related to the analysis of the shortcut dimensions.

Let’s use the Cronus company as an example.

In the Cronus company, the Department and Project  dimensions are assigned Global Dimension 1 Code and Global Dimension 2 Code respectively.  The remaining dimensions – CustomerGroup, Area, Business Group, and SalesCampaign are shortcut dimensions.

clip_image002

When creating a new account schedule, the first step is to insert a new Account Schedule Name.  As a general rule, account schedules publish financial information from the General Ledger Entries table.  The General  Ledger Entries table records contain the Global Dimension 1 Code and Global Dimension 2 Code fields i.e. Department and Project. 

clip_image003

However, the shortcut dimension are not available directly from the General Ledger Entries records, as the they are stored in a separate table. To analyze financial performance related to the shortcut dimensions, analysis views are used. Analysis views summarize general ledger entries by dimension combinations (both global and shortcut dimensions)  into the Analysis View Entries table.

In order to utilize the analysis views with account schedules, two steps are required:

1.      Setup an analysis view.

2.      Attach the analysis view to the account schedule name.

Setting up an Analysis View

To setup an Analysis View, go to Departments> Financial Management> Administration> and choose Analysis Views.  Analysis views allows for the analysis of the dimension information  that was posted to general ledger entries and budgets . Up to four dimensions, as well as specify criteria for G/L accounts, dates and business units are setup. Trends can be analyzed based on the relationships of the dimension information that has been posted. 

Let’s review the Revenue analysis view.

clip_image005 

clip_image006

The SalesRev analysis view focuses on the Area, Department and Project dimensions

clip_image008

Once the Analysis View has been established, the next step is to assign the analysis view to the account schedule.  In the picture below, the Revenue Analysis View has been assigned to the ‘Revenue’ account schedule.   By assigning the ‘Revenue’ analysis view, the Area, Department, and Project dimension become available to allowing filtering of the targeted analysis view dimensions on the account schedule rows, column layout and account schedule report.

clip_image010

From the picture below, the user now has the ability to filter the account schedule by any of the assigned dimensions from the analysis view.

clip_image012

When printing of the account schedule, the user can choose the appropriate filter combinations at run-time.

clip_image014

Written by Mark Stept

Clients First Business Solutions, LLC