NAV Account Schedules 101
Posted: April 9, 2014 Filed under: Uncategorized 2 CommentsI’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.
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 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?
[…] 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. […]
[…] 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. […]