Blogiversary Top 20 (#9) Where can I learn more about NAV analysis reports and analysis by dimensions?Posted: April 17, 2013
We’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
Analysis reports and analysis by dimensions are the native reporting options that extend NAV reporting to the item ledger entries generated from the sales, purchasing, and inventory areas of the application. I find that many users don’t know that this reporting option exists and think it is one of the more underutilized areas by NAV financial users.
These reporting options can be found on the general ledger, sales & marketing, purchasing, and inventory menus.
The main advantage this reporting tool has over account schedules is that it reaches a further level of detail that just isn’t recorded on the general ledger. Being able to get to quantity information at the item or location level in addition to the dollar values posted makes these tools great as a way to get operational reporting.
What is the difference between the two?
Analysis by dimensions is a query tool. The key to using this tool effectively is to use aggressive filtering, especially if you have a large number of items. It can be a very quick way to get information about what may be going on with a single or small group of items. You can also export to Excel and it shows up in a pivot table.
Analysis Reports allow you to configure and save row setups and column layouts for later use, which makes it a reporting tool. These reports work a lot like account schedules, with some added features to accommodate the additional data you can reach because you’re reporting against the item ledger entry tables instead of the general ledger.
A few hints on analysis reports and analysis by dimensions:
- Skip the analysis report on the general ledger menu and use accounts schedules; you’re not going to get any added value here.
- When posting sales or purchase orders, you must be fully utilizing the sub module, i.e. do not allow any posting of lines to general ledger accounts on the sales or purchase order documents. Any posting that goes “around” these modules will cause your analysis report to show a lower number than what is on your general ledger. Avoid the argument of reporting credibility by understanding this, and either being able to explain the variance, or prevent it from happening altogether.
- Know that analysis reports will not automatically update if you add new items. You’ll need to go in and do this manually to each report every time you add new items.
For those of you who are looking for more resources on Analysis by Dimension and Analysis Views, reference the documents below, found on Customer Source:
Documentation => User Guides => Overview of Training Manuals and Hands-On Labs for Microsoft Dynamics NAV 2009
- Trade in Microsoft Dynamics NAV 2009 – Chapter 9
- Business Intelligence for Information Workers in Microsoft Dynamics NAV 2009 – Chapter 5
Documentation => User Guides => Overview of Training Manuals for Microsoft Dynamics NAV 5.0
- Trade in Microsoft Dynamics NAV 5.0 – Chapter 10
- Business Intelligence for Information Workers in Microsoft Dynamics NAV 5.0 – Chapter 6