NAV Account Schedules 101

I’ve decided to give away my account schedule class material here on the blog in this Series: NAV Account Schedules 101. Check back to see what’s been added, or choose to follow the blog to receive email updates (or subscribe to the RSS feed), so you don’t miss any of these when they come out. Most examples and screen shots will be shown in NAV2013, but I’ll make sure to tie back any significant differences to 5.0 and NAV2009 Classic and RTC. The list of topics we’ll be covering is below and you’ll see two or three new ones come out every week until we’re through the whole list.

Don’t forget to visit the Account Schedule Formulas and Account Schedule Examples pages if you’re looking for even more ideas on how to improve your financial reporting using account schedules with Microsoft Dynamics NAV.

101v2

 

NAV AS 101 Lesson 1: Why do I use Account Schedules?

NAV AS 101 Lesson 2: Am I anti add-on?

NAV AS 101 Lesson 3: Where else can you learn about Account Schedules?

NAV AS 101 Lesson 4: Basic Elements of Account Schedules

NAV AS 101 Lesson 5: Getting Started

BONUS WEBINAR – I did a repeat of a NAVUG sponsored Convergence session from this last March titled, “Basic Financial Reporting with Account Schedules”. The one hour session covered some account schedule basic concepts, but also shows how to look at an income statement nine different ways with live demonstrations done in a NAV2013 database. The webinar is recorded and is available for viewing at this link out on Collaborate if you have a premium NAVUG membership.

NAV AS 101 Lesson 6: Row Setup

NAV AS 101 Lesson 7: Column Layout

NAV AS 101 Lesson 8: Formatting

NAV AS 101 Lesson 9: Formulas

NAV AS 101 Lesson 10: Comparison Period v. Comparison Date

NAV AS 101 Lesson 11: Filtering

NAV AS 101 Lesson 12: Drilling Down

NAV AS 101 Lesson 13: Printing Account Schedules

NAV AS 101 Lesson 14: Exporting to Excel

NAV AS 101 Lesson 15: Dimensions with Account Schedules

NAV AS 101 Lesson 16: Analysis Views

NAV AS 101 Lesson 17: Budgets with Account Schedules

NAV AS 101 Lesson 18: Account Schedules not balancing?

NAV AS 101 Lesson 19: Row numbering

NAV AS 101 Lesson 20: Sharing with your friends

NAV AS 101 Lesson 21: Account Schedule Bugs

NAV AS 101 Lesson 22: Dealing with Zeros

NAV AS 101 Lesson23: Copy and Paste

NAV AS 101 Lesson 24: When to change the sign

NAV AS 101 Lesson 25: What else can I do with Account Schedules?


2 Comments on “NAV Account Schedules 101”

  1. […] In this blog I am not going to go into in-depth discussions on how to write Account Schedules.  There are already quite a few blogs out there on how to do this and I am not a particular fan of reinventing the wheel.   If you want to know how to set up an Account Schedule then I suggest you check out the excellent series of Account Schedules 101 by Kerry Rosvold here. […]

  2. […] Why does Kerry Rosvold use account schedules in Microsoft Dynamics NAV? It's a question with many good answers, some functional, others more philosophical. Rosvold, the Corporate Controller at Augsburg Fortress Publishers in Minneapolis, Minnesota has been busy enlightening readers of her blog, Dynamics NAV Financials, in a new series this spring. […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s