Blogiversary Top 20 (#1) Account Schedules Formulas PagePosted: April 29, 2013 Filed under: Uncategorized | Tags: account schedule formulas, Account Schedules, cheat sheet, comparison date formula, comparison period formula, Dynamics, Microsoft, NAV, tips and tricks Leave a comment
We’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
The most viewed blog entry in the Dynamics NAV Financials first year isn’t an entry at all, but an entire page! Check out the Account Schedules Formulas Page found here to see what 15 people a week come to the blog to use.
I developed this page in response to a question I would get in my classes on account schedules. “Do you have a cheat sheet for all the formulas you can use in Account Schedules?” I’ve shied away from this in the past, because it’s a complex question. You’ve got to take into account comparison period versus comparison date, column type used, use of filters, and like all Microsoft products, there is often more than one way to accomplish the same result. But I think I’ve got us a start. To my knowledge, there are bits and pieces of this out there, but this is the most comprehensive guide to account schedule formulas that I know of.
If you know of more, please submit them here. As long as I can test it to prove it works in the way described, and it’s different enough from already listed formulas, I’ll add it to the list and make sure to put a shout out to the contributor on the blog.
I believe the power of community is an amazing thing. We continually make each other better by sharing information. I’m looking forward to seeing what our amazing NAV community can accomplish!