Dynamics NAV Financials

account schedules, financial reporting, dimensions, budgets and all the rest of the fun, fun world of Microsoft Dynamics NAV from a (former) Controller who still uses the software every day

  • Account Schedule Examples
  • Account Schedule Formulas
  • Popular Series
  • Services
  • About

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 | Author: kpeters | Filed under: Uncategorized | Tags: Account Schedules, financial reporting, general ledger, learning, NAV 2013, NAVUG Academy, training | Leave a comment

TrainingLooking 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


TwitterYouTubeFacebookGoogleLinkedInEmailRSS
MVP_Logo_Preferred_Cyan300_RGB_72ppi
All Stars_NAVUG(1)
400dpiLogo

Blog Stats

  • 623,875 visits

Enter your email address to follow this blog and receive notifications of new posts.

Join 477 other subscribers

Top Posts & Pages

  • Account Schedule Formulas
  • Account Schedule Examples
  • NAV Account Schedules 101
  • NAV AS 101 Lesson 10: Comparison Period v. Comparison Date
  • Basic Trial Balance
  • 12 month Trend Balance
  • NAV Error Message: G/L Account No. '' does not exist
  • NAV default dimensions and value postings applied to master data (part 6 of 15)
  • Tips and tricks for a flawless budget load in NAV
  • Detailed Budget
My Tweets

Account Schedules accounts payable accounts receivable aging analysis by dimensions Analysis Reports analysis views balance at date BREP budgets chart of accounts Classic Client code mandatory column layout community comparison date formula comparison period formula consolidation Convergence CustomerSource dimensions document date dual monitors due date Dynamics ERP Excel export to excel financial reporting financial statement fiscal year general ledger global glued column increase header item ledger entries JET journal entry keyboard shortcut learning Management Reporter manuals Microsoft NAV NAV 2013 NAVUG NAVUG Academy net change networking Office2013 paperless payment terms pivot table posting accounts PowerPivot productivity query tool reconciliation account reporting tool ROI row setup RTC set base for percent setup options shortcut show opposite sign SSRS tips and tricks totaling type training trial balance user group user level configuration user poll video

Blogroll

  • Microsoft Dynamics NAV Team Blog
  • Microsoft Connect
  • Microsoft Dynamics CustomerSource
  • I Love NAV
  • Microsoft Dynamics Community
  • NAVUG

Archives

  • December 2020
  • September 2020
  • November 2019
  • October 2019
  • August 2019
  • May 2019
  • March 2019
  • April 2018
  • December 2017
  • October 2017
  • April 2017
  • March 2016
  • December 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • March 2015
  • January 2015
  • December 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
Blog at WordPress.com. Mid Mo Design.
  • Follow Following
    • Dynamics NAV Financials
    • Join 477 other followers
    • Already have a WordPress.com account? Log in now.
    • Dynamics NAV Financials
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...