Account – Page 10 – Pardaan.com

Video Demo: How to export NAV account schedules to Microsoft Excel

There are some quick and easy ways to publish NAV Account Schedules to Microsoft Excel but some of them end up with some pretty ugly formatting unless you know a few secrets on how to make them look better. This short demo video shows you how…

13 February 2013

Dynamics NAV & BC Tips & tricks

Use show opposite sign to reflect net income correctly on an income statement using NAV account schedules

One of the concepts I see students in my NAV account schedules class get stuck on is exactly how to use the show opposite sign function when constructing an income statement. It can be a bit mysterious why it behaves the way it does, and it…

26 December 2012

Dynamics NAV & BC Tips & tricks

Expand your use of dimensions in NAV account schedules by using analysis views

If I had to pick only three basic elements to Microsoft Dynamics NAV account schedules, I’d have to choose row setups, column layouts and analysis views. Of course, row setups give you access to basic general ledger accounts and column layouts give you options on how…

31 October 2012

Dynamics NAV & BC Functional Tips & tricks

Account Schedule Formulas

Any formula with ** in front of it is considered a Best Practice. To get budgeted numbers on any of these options, change the Ledger Entry Type from G/L Entries to G/L Budget Entries. All examples assume a calendar fiscal year for ease of illustration but,…

26 October 2012

Dynamics NAV & BC Functional Tips & tricks

The NAV accountant’s little helper: the reconciliation account check box

There’s a tiny feature in NAV that I take for granted. It’s there, in the background, hiding in the setup, and it helps me out just a little almost every time I make a manual journal entry. Especially if I’m in a bit of a rush,…

10 October 2012

Dynamics NAV & BC Tips & tricks

Basic column layout options for NAV Account Schedules

Column layouts in NAV account schedules are what you build to add more flexibility to your financial statements. You can have an unlimited number of column layouts to match together with your already existing row setups. In general, most basic row setups contain general ledger numbers…

28 September 2012

Dynamics NAV & BC Tips & tricks

Can you use NAV account schedules to create a statement of cash flows? Yes, you can!

John Bellinger of Archerpoint recently posted a great article illustrating how to use account schedules to build the statement of cash flows, using both the indirect as well as the direct methods. For those of you who have struggled with this sometimes challenging financial statement using…

17 August 2012