Get the skills you need to produce robust financial reporting using the software you already own! New NAV2013 account schedules training now available!
Posted: August 14, 2013 Filed under: Uncategorized | Tags: Account Schedules, financial reporting, general ledger, learning, NAV 2013, NAVUG Academy, training Leave a commentLooking for training on NAV account schedules? There are new classes now available. NAVUG Academy distance learning is offering two half day instructor led online sessions on September 20th. There is also a full day classroom session on October 21st held as part of the pre-conference training for NAVUG Forum, held in sunny Tampa, Florida. Detailed descriptions of all three classes can be found below, or simply click on the title of the session you want to register!
Account Schedules: Basics – half day course, 9:00am to 1:00pm, (9/20)
Microsoft Dynamics NAV account schedules are a powerful tool used to create custom financial statements directly from your general ledger. In this in-depth training session, you will learn the fundamental principles of account schedule construction. This course is open to any NAV user.
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!
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:
• Understand basic construction of row setups and column layouts
• Learn how to build, update, and apply analysis views
• Use filters, formulas, and formatting
• Incorporate dimensions and budgets
• Integrate account schedules to Excel
Instructor: Kerry Rosvold
Audience: Finance
Level: Intermediate
Prerequisites: Intermediate to advanced level of experience as a NAV financials end user
Account Schedules: Beyond the Basics – half day course, 2:00pm to 6:00pm, (9/20)
If you already understand the three basic account schedule building blocks and you’ve got a firm grasp on dimension and budget filtering (or if you’ve already taken Account Schedules Basics), you are ready to expand what you know with this class! This course is open to any NAV user.
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