New NAV2013 Videos page added to DynamicsNAVFinancials
Posted: September 19, 2013 Filed under: Uncategorized | Tags: learning, NAV 2013, video Leave a commentThere are a whole lot of very technical NAV2013 videos out there made for programmers and NAV developers. Videos geared toward the NAV end-user are a bit more difficult to find. I’ve added a new page to the blog so I can add videos I’ve found that I think are helpful. I’ll view each video I find personally and post some comments on each to make it easier for you to decide if you want to spend your time viewing it yourself.
I’ve got a pretty big list to start with, and will put a post out there each time I get a new set of videos reviewed and on the page. If you’ve seen some great stuff out there, or if you’re working on something yourself and want me to review it and add to the page, send me a message!
Let’s get started with some short but effective videos from Microsoft MVP Alex Chow.
Closing the year in Dynamics NAV 2013 in 2 minutes; Alex Chow (1:51) Super quick overview of the year-end close process and great for a quick refresher of the steps you need to follow for this once a year routine. Fast, to the point, accurate. Covers closing the year, closing the income statement, what to do with dimensions, posting the journal, and gives some nice examples on using the NAV2013 search feature to find these functions that we do infrequently.
Processing vendor 1099 in Dynamics NAV 2013 in 2 minutes; Alex Chow (1:52) Super quick overview of setting up a vendor for proper 1099 processing. Also covers how to post your invoices to gather 1099 information properly and how to print out the 1099s directly from NAV2013. Hidden gem: quick tour of the same information in NAV Classic.
My #1 Objective for NAVUG Forum is…
Posted: September 17, 2013 Filed under: Uncategorized | Tags: NAVUG, user group Leave a commentAs a member of the NAVUG programming committee, I’ve got just one goal at NAVUG Forum this year, and that is to find GREAT examples of what NAV users are doing with NAV at their companies and get these companies to do a CUSTOMER SHOWCASE for other NAV users in webinar format later in the year. I’m ready with a list of questions and I will be talking to as many NAV users as possible to ask them:
- What’s the most amazing thing your company has used NAV to accomplish this last year?
- What special project have you completed using NAV this year?
- What thing have you been doing with NAV lately that has saved you a ton of time?
- What one thing are you doing with NAV at your company that you think other people should know about?
- What month would be better for you to do a customer showcase webinar, February or March?
I believe the value of sharing real world applied solutions is priceless and want to provide opportunities for users to teach other users the best practices they know and are using in their businesses every day.
The NAVUG makes it very easy to do and provides all the technology needed for you to share your story, but we need YOU to tell it. If you’re a little shy about public presentation, this is a great time to ask your partner to present this information along with you.
Really, just avoid the hassle of me asking you all those questions. Send me a message to tell me what you’re proud about doing with NAV at your company.
It Takes a Village to Collaborate
Posted: September 16, 2013 Filed under: Uncategorized Leave a commentThis article recently ran in the Fall 2013 NAVUG magazine. Find this article, and lots of other great NAVUG info, at this link.
Back when she was First Lady, former Senator and Secretary of State Hilary Rodham Clinton wrote a book titled “It Takes a Village”. The book was essentially about how it takes all people in a community, not just the core family, to raise a child. We see similar principles within our own NAVUG community, where it takes a village to continually support each other, nurture our networks, and improve our knowledge base as we all strive to provide our companies with the best possible business solutions using our ERP system of choice, Microsoft Dynamics NAV.
In the five years I’ve been actively involved in this community, I’ve seen some amazing examples of how this village of users collaborate to solve business problems for their companies.
I know two Controllers who met through NAVUG who have bartered knowledge back and forth every year. One year, one Controller taught the other how to use and enhance their account schedules. The next year, the other Controller traded information to the other about intercompany consolidation. The year after that, they exchanged information on budgeting. This tradition has continued every year, with these two users finding ways to enhance their use of NAV by trading information and brainstorming ideas.
Through some sessions at Forum, the annual user group conference held in October, a number of users voiced concerns they were having difficulty in coming up with a suitable business process for correctly using EFT (electronic funds transfer) to pay vendors. This group worked together over the year, exchanging information on how to get it done, and two of those users presented a Customer Showcase showing how they solved it for their companies at the next year’s conference.
Every year, over a hundred volunteers collaborate to provide webinars throughout the year to the user group at large. These webinars include presentations on specific topics as well as interactive discussion formats, allowing the participants multiple opportunities every month to assist each other with business challenges. Time and time again on these webinars I hear examples of users who help each other right then if they can, and if they can’t, they follow-up with each other through email or phone calls, helping the person to make connections until they get an answer to their question.
Recently, the NAVUG has been reaching out internationally, searching for ways to collaborate with users in other countries who use NAV. They made a foray into the international community for the first time in January of this year by going to Rome, Italy, and will be returning to another international event in November. This event will continue the work to expand the user group in other countries, expanding the village to the international community, and creating new ways for us all to exchange the information we need to help each other.
As an active blogger in the Dynamics community, I’m particularly excited to see the launch of the new NAVUG Collaborate tool which has recently been made available to the community. By incorporating social media into a platform that gives us a home base where we can update each other on educational events, answer each other’s questions, and connect and build our networks, the NAVUG has just one more place to make the work of the village possible.
Every person who participates makes the community stronger and with a stronger community, each participant benefits.
So why do they do it? What could possibly possess a group of people who all have full-time jobs of their own and families and lives to invest time to volunteer their time to help other users? I think there are a few reasons:
1) We’ve all been there. All the people who volunteer to help the user group can tell a story about when they were new to NAV and felt like they were alone.
2) We’ve all been helped by other users. Each one of those people can also tell a story about how they had business problems another user helped them with. Every time I hear one of these stories, I’m always so impressed by the heavy feeling of gratitude and relief that comes through in the telling, as people came to realize they didn’t always have to pay someone to help them and how empowered they felt to be able to solve it on their own.
3) We’ve realized the benefit of this community. Because we’ve been able to help each other out, each and every person has brought value back to their organizations in the form of solved problems, greater knowledge and understanding of our ERP systems, and the type of future preparedness that only comes through staying current on emerging technologies.
4) We want to give back. Each person who volunteers realizes the advantage this gift of support has been to them and wants to give back to others.
Think these stories don’t apply to you? Think again! If you were able to reach out to a group of informed people who aren’t invested in selling you anything, what would be the quality of information you would receive? These people have real world advice and real world experience with NAV. They use NAV in their job roles every day, just like you do. Whether you are looking for advice on best practices or just an honest opinion on what type of solution to choose, this is the group who can get that to you. If that doesn’t convince you, put together a return on investment analysis. What’s the benefit of being able to support yourself through the network you have developed?
Just this year another strong business leader, Sheryl Sandberg, who is Chief Operating Officer of Facebook, authored a book called “Lean In”. While this book focuses in on gender politics in the workplace, the message she conveys with equal strength is to get involved in what happens at your office and in your community. Don’t hold back. Bring your talents to the table. Speak up and participate.
If you feel the NAVUG has brought some benefit to you, get involved in collaborating, in whatever form may work for you. We are always looking for users to lead webinars, facilitate discussions, lead sessions at the annual conference, engage in social media, blog, and find ways to connect with each other in a meaningful way. I encourage you to set a goal for what you can do to contribute to the effort this community puts forward to continually grow this user group.
If you haven’t yet been actively involved with NAVUG or if you’re brand new to NAV, know that you don’t have to struggle coming up with a solution on your own for what you need. There are other NAV customers out there who have gone through what you’re going through and are ready and willing to help. There is a whole village available to you through NAVUG whose call to action is to support each other through the ability to collaborate.
Kerry Rosvold has been the Corporate Controller at Augsburg Fortress Publishers since 2008, and has been using Microsoft Dynamics NAV as her ERP of choice since 2004. Kerry has been an active member of NAVUG since 2009 and frequently conducts webinars, speaks, and teaches classes on NAV financial topics. She blogs regularly at www.dynamicsnavfinancials.com and also can be found on Twitter @krosvold.
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 Filed under: Uncategorized | Tags: Account Schedules, financial reporting, general ledger, learning, NAV 2013, NAVUG Academy, training Leave a comment
Looking 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
NAV users just “get” it
Posted: July 1, 2013 Filed under: Uncategorized | Tags: collaborate, community, learning, NAVUG, networking, training, user group Leave a comment
Don’t you love it when you’re talking to someone about something and you can immediately tell they “get” what you’re talking about? There’s that magical click in your conversation when you can both relax into the discussion and really geek out about the topic. That topic might be baseball, or marathon running, or gardening, or maybe even Microsoft Dynamics NAV.
If you ever wished there was someone out there who would really like to talk about inventory costing, or C/AL coding, or dimensions or other things, the NAV user group (NAVUG) is the place where you can find those people.
This amazing group of people have formed one big network of NAV users who are eager to connect with you, welcome you to the community, and help you solve business problems for your company.
There are a wealth of opportunities to connect with the members of NAVUG. There is not only the annual user conference, NAVUG Forum, held in October each year, but also many chances to engage with other users in webinars throughout the year, and now, last week, we’ve seen the launch of Collaborate. This online tool was built to give NAV users a virtual environment where we can gather regularly to have those kind of discussions and to keep up with all the things that are going within the community.
If you’ve been looking for more people who just “get” it, you’re here. Check out the new Collaborate site and get into a discussion today!
Why Build Community?
Posted: June 18, 2013 Filed under: Uncategorized | Tags: community, Dynamics, manuals, Microsoft, NAV, training, user group 1 CommentBack when I first recommended Microsoft Dynamics NAV to my company as an ERP solution, I was a lone voice in my universe. I had run the whole gauntlet of the request for proposal, partner screening, requirements planning, and final selection, and ultimately I was the person in charge and therefore responsible for where our company ended up because of my choice.
The first few years of using Microsoft Dynamics NAV were a little rough and I did many of the following things to solve problems:
- Spent hours on the internet searching for terms that might get me some results. Many of the searches ended up in programming and development forums that would show me the code behind what was happening, but wouldn’t help me, as an end user, figure out what steps I should take.
- Read the manuals I had gotten from my partner. I spend hours going through the manuals I had been given and trying to piece together how I could do more advanced tasks by cobbling together the simple examples I had.
- Brainstormed with my boss and my staff. We had quite a few long conversations about how to get things done. Some of these conversations actually solved the problem, many of them ended up with needing to go back to the manuals, or the internet, or to our partner.
- Just tried it in the live system to see if I could figure it out. Sometimes this was successful and sometimes it created more problems than where I had started. I was an inexperienced end user who didn’t even know having a test system was possible. When pressed, I took the risk (in small steps) to see if I could get it figured out.
- Called our partner for help. When all of the above failed, I would reach out to our partner for assistance and pay them to help us out.
What an incredible waste of time! I had spent hours and hours of time trying to solve simple problems. Why? Because I thought I was alone. Because I thought I was the only person who could solve what we had. Because I hadn’t built a network.
Eventually, I got smarter. I started to ask our partner, “Surely you have other customers who have this same problem. What do they do?”, and in return I got silence and an invoice for services. I went back to the internet and looked again, and this time, I learned about user groups and began to look for a user group for Microsoft Dynamics NAV, and I found one! I started small, lurking in webinars and listening and learning and applying all the things I learned back at the office.
Since then, I’ve gotten the opportunity to regularly attend the annual user group conference, and have built a robust network with other NAV users. While I do still go to the internet for answers, I know where to go and where not to go to get my answers. I know where to get the right manuals for what I really need. I don’t mess things up in my live system because I have an effective test system. I still pay my partner for help, but I get to pay them for things that really make a difference in improving things at my company instead of paying them to help with things I should be able to do myself. Most importantly, I have a whole network of Controllers and CFOs and other professionals from other companies who I can email or call to help solve a problem.
I’m no longer a lone voice, but a single voice in an entire chorus of knowledgeable NAV users who are making a difference at their companies because we’ve all chosen to build a community together.
If you haven’t found your community yet, find it here at www.navug.com .
These folks are ready for NAVUG Forum. Are you?
Posted: June 11, 2013 Filed under: Uncategorized | Tags: Forum, learning, NAVUG, Tampa, user group Leave a comment
I’ve been watching what people have been posting on social media about the upcoming NAVUG Forum conference held in Tampa this October, and it’s starting to get pretty exciting as plans are revealed about what’s being offered. Here are just a few:
From a press release issued by ArcherPoint on June 6th:
ArcherPoint, LLC, a Microsoft Dynamics ERP Gold Partner specializing in Microsoft Dynamics NAV solutions and upgrades, today announced that CEO Greg Kaupp and other key members of the ArcherPoint team will present at NAVUG Forum 2013 in Tampa, FL, October 21-24, 2013.
“We couldn’t be more excited about the 6th annual NAVUG Forum. Our largest planning team to date has already identified close to 100 dynamite sessions across 12 tracks,” said Mark Rhodes, NAVUG Interim Program Director. “I believe there is something for everyone this year, with a jam-packed schedule and 11 pre-conference training classes. With 400 fellow NAV users, it’s going to be a fantastic opportunity to learn, network, and share.”
NAV has a long track record for attracting international companies and we are excited about the program we’re putting together and the fantastic support we are receiving from the NAVUG committee as well as from the interest groups related to international activities. We have literally received input from all over the world. We are setting the bar high and we want to make this the best NAVUG Forum ever.
Take a look at the full schedule of sessions recently published on the NAVUG Forum site! New to NAV, Tips and Tricks, Warehousing and Distribution, and Service Management are four new never before offered tracks this year. Perennial favorites like Finance, BI and Reporting, Manufacturing and Supply Chain, and IT and Developers are looking good with foundational offerings as well as fresh new material including quite a few customer showcases. NAVUG continues to highlight the newly established Global track and the agenda is nicely rounded out with offerings in Business Leadership and an entire day of pre-conference optional training to help you maximize your learning at the conference.
I can see over 100 possibilities for learning at this quick three-day conference; plenty of ways to increase your knowledge about the ERP system you use every day at your company. If you need a few more reasons, check out this article from the Microsoft Dynamics Community. Early bird pricing allows you to save $200 if you register before June 30th.
See you in Tampa! I’m ready, are you?
Learning about NAV2013: Videos on the chart generator
Posted: May 29, 2013 Filed under: Uncategorized | Tags: chart generator, learning, NAV 2013, NAVUG Leave a comment
As a NAV super user at my company, I’m constantly learning new things about NAV and bringing that information back to my coworkers. Even after using NAV for quite a few years, I sure don’t know everything, and there is always some new thing to discover by attending NAVUG webinars, browsing blogs on the web, or just watching over someone’s shoulder as they do a task.
I’m focusing on learning about NAV2013 this year so I can be prepared for the next step in the NAV upgrade progression for my company. One of the things I’m really curious about is how to generate those nifty looking charts in NAV2013.
I found some great videos out there on YouTube done by Rick Baxter of Cost Control Software. Take a look!
How to use Dynamics NAV 2013 Chart Generator #1
How to use Dynamics NAV 2013 Chart Generator #2
How to use Dynamics NAV 2013 Query Tool
Learning about NAV2013: CustomerSource guide to resources
Posted: May 7, 2013 Filed under: Uncategorized | Tags: CustomerSource, Dynamics, learning, manuals, Microsoft, NAV 2013, training 1 Comment
If you are already a Microsoft Dynamics NAV customer and you’re current on your maintenance plan you need to go to CustomerSource to get access to NAV2013 training manuals that are just waiting for you to find them.
For versions prior to NAV2013, CustomerSource has published an Overview of Training Manuals as well as a Learning Plan for each version which made it easy to find all of the resources available for that version. For some reason, they have chosen not to do that with NAV2013 which does make the manuals a good deal more difficult to locate. I’ve found if you know the Course Number for the training materials you want to find you can get to them quickly by using the search box on the left hand navigation bar. Simply type in the course number, for example, 80534, and you’ll be taken directly to those training materials which you can immediately download.
Look up the following courses using the search box to get to more information about NAV2013:
Installation and Configuration
80438: Installation and Configuration in Microsoft Dynamics NAV 2013
80433: Reporting in Microsoft Dynamics NAV2013
80549: Data Upgrade and Code Upgrade to Microsoft Dynamics NAV2013
Finance Related
80434: Fixed Assets in Microsoft Dynamics NAV 2013
80435: Application Setup in Microsoft Dynamics NAV 2013
80439: Introduction to Microsoft Dynamics NAV 2013
80534: Finance Essentials in Microsoft Dynamics NAV 2013
80535: Finance Advanced in Microsoft Dynamics NAV 2013
Trade & Inventory
80257: Inventory Management in Microsoft Dynamics NAV 2009 *
80440: Trade in Microsoft Dynamics NAV 2013
Warehouse Management
80259: Warehouse Management in Microsoft Dynamics NAV 2009 *
Service Management
50224: Service Management in Microsoft Dynamics NAV 2009 *
Relationship Management
50223: Relationship Management in Microsoft Dynamics NAV 2009 *
Manufacturing
80550: Manufacturing in Microsoft Dynamics NAV2013
C/SIDE
80436: C/SIDE Introduction in Microsoft Dynamics NAV 2013
80437: C/SIDE Solution Development in Microsoft Dynamics NAV 2013
* not updated for NAV2013, only available in prior versions
nChannel lists Dynamics NAV Financials as a top Microsoft Dynamics NAV Blog
Posted: April 30, 2013 Filed under: Uncategorized | Tags: Account Schedules, budgets, Dynamics, financial reporting, Microsoft, NAV 1 Comment
nChannel gave Dynamics NAV Financials a really nice mention in their recent listing of top Microsoft Dynamics NAV blogs.
Here’s a blurb from the article:
About the Blog: Kerry uses her extensive experience in Dynamics NAV to give readers an in-depth look at account schedules, financial reporting, dimensions, budgets and more. Readers can also follow the blog on Facebook, follow Kerry on Twitter and subscribe via email in order to receive notifications of new posts (the blog is updated often, with some days generating multiple posts).
For the full article, listing twelve other really fantastic NAV blogs and communities, click here!



