Using hands-on exercises, you will have the opportunity to apply what you learn during class to a basic trial balance and master the three basic account schedule building blocks:  row setups, column layouts, and analysis views.  You’ll discover how to filter your financial reporting by dimensions, layer in budgeted information, and produce reports by exporting to Excel in the most efficient way possible!

Using hands-on exercises, you will have the opportunity to apply what you learn during class to a simple balance sheet and income statement.  You’ll discover how to design and use multiple column layouts with the same row setup base and expand time periods reported beyond the basics.  Move past simple dimension filtering and incorporate dimensions into row setups and column layouts!  Learn how to use more advanced formulas like base for percent and see how to use account schedules as an alternative way to reporting from the NAV budget tool.

In this class all hands-on exercises will be done using NAV2013.  Almost all account schedule functions are applicable to lower versions of NAV, so you will still benefit from the training if you use a version below NAV2013.

Functionality of account schedules is virtually the same, but navigation and look and feel is significantly different.  This class is being taught only in the NAV2013 version. If you are using the Classic Client and will not be moving to NAV2009 RTC or NAV2013 soon, please wait to take a Classic class.  If you are an experienced Classic account schedule user who wants to learn more about NAV2009 RTC or NAV2013, it is recommended that you begin with the Account Schedules: Basics class simply to get used to the new navigational paths required.

Learning Objectives:

• Build essential financial statements, including an income statement and balance sheet

• Extend knowledge of additional time periods used in column layouts

• Expand use of dimensions into account schedules

• Use account schedules to report on all budgeting information

Instructor: Kerry Rosvold

Audience: Finance

Level: Intermediate

Prerequisites: Intermediate to advanced level of experience as a NAV financials end user; have taken Account Schedule Basics or equivalent prior experience with account schedules

Account Schedules and Analysis Views – full day course, 8:00am to 5:00pm, (10/21)

Microsoft Dynamics NAV account schedules can be a powerful tool used to create custom financial statements and analysis reports directly from your general ledger. Attend this all day training session to get a firm foundation on the basic principles of account schedule construction and learn how to build all of your essential financial statements. Using hands-on exercises, you will have an opportunity to stretch beyond the basics and discover how to build multiple row and column layouts, how to create dynamic reports using dimensions, how to incorporate budgets into your schedules, and how to leverage the power of integration to Excel to make your reports even more flexible. Additional time will also be spent on analysis reports and analysis by dimensions.

Microsoft Dynamics NAV version: This class will be taught in NAV 2013, and backward compatible with NAV 2009 RTC. If you are using NAV 2009 Classic, you will benefit from the class as the concepts and approaches are the same, however the navigation and user interface is different. These differences will be addressed during class.

Learning Objectives:

• Build essential financial statements, including an income statement and balance sheet

• Understand construction of row setups and column layouts

• Use filters, formulas, and formatting

• Integrate account schedules to Excel

• Incorporate dimensions and budgets to account schedules

• Extend principles to use of analysis reports and analysis by dimensions

Instructor: Kerry Rosvold, Augsburg Fortress Publishers

Audience: Finance

Level: Intermediate

Prerequisites: Intermediate to advanced level of experience as a NAV financials end user