Why Build Community?

Back 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 .

?????????????????????????????????????????????????????????????????


Learning about NAV2013: CustomerSource guide to resources

customer source searchIf 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.

Custsourceexample

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


View Convergence 2013 session on Microsoft Dynamics NAV dimensions here

If you’ve enjoyed this month’s 15 days of NAV dimensions series, and would like to hear me speaking about dimensions, there is now a recording out on the Convergence website as well as on the Virtual Convergence website.

If you were a registered Microsoft Dynamics Convergence 2013 attendee, log in to the Convergence site and bring up the Schedule Builder. From here you can view a recording of any session that was listed as a concurrent or deep dive session, and you can even re watch the keynote and general sessions! You can search by any number of methods for my session, which was called Tips & tricks for working with dimensions in Microsoft Dynamics NAV, and ran on Thursday, March 21st at 2:30. Click the link to watch the session video.

virtualconvIf you were not able to attend Convergence this year, there is a Virtual Convergence that is available to the public. You’ll need to log in to register, but once there, you’ll have the same access as Convergence attendees to concurrent, deep dive, keynote, and general sessions. In order to find my session, search under the sessions menu, then Microsoft Dynamics NAV, then scroll down until you see the box that contains Tips & tricks for working with dimensions in Micro . . .dims virtual

There are a lot of great sessions out there available for one year past the close of Convergence 2013, so I bet these will only be out there until the end of February 2014. Take some time to explore what else is out there and share with your coworkers! This is a great way to get information into your company about the ERP you have all chosen to run your businesses.

Enjoy!


Resolving NAV dimensions errors (part 10 of 15)

Error messages related to dimensions can be the bane of a dimension-using NAV user’s existence unless you know how to properly deal with them. The number one thing I tell my end users is, “if the error message has the word dimension in it, the error is generally something you can resolve yourself”. Let’s go through three dimension errors from my system; we’ll resolve each one as we go.

derr1This message says the end-user needs to select a dimension code for team on the first line of this invoice, where they’ve entered general ledger account number 51320. For whatever reason, NAV counts lines by the 10,000, so 10000=line 1, 20000=line 2, etc. The rest of the error message is pretty self-explanatory, but is presented in an “out-of-order” way that doesn’t quite read as well as plain English. This error has occurred because we’ve set a control on the general ledger account 51320 of code mandatory for team. The end-user needs to enter a team code for every transaction that posts against this account number.

derr2

The dimension value of 522120 on the list of dimensions for project has been blocked. You can’t use it/you don’t want to use it/you shouldn’t use it. Our company goes through annually and blocks project numbers that have not been given any budget money. If I block a project, I mean it – I really don’t want anybody posting anything against it. For this error, either the person made a typo, or they were given bad coding so the solution is to either fix the typo or get a correct project number.

derr3

This is an example of a team and project combination that has been blocked for use. We do this on purpose in order to keep from making errors and to avoid needing to make reclassifying entries. For this error, the person entering the information either needs to correct a typo or get a correct project number (or team number).

Keep reading this month as we continue our series, 15 Days of NAV Dimensions.


NAV dimension priorities (part 9 of 15)

Here’s the deal with dimension priorities. Depending on what you’ve chosen for your dimension strategy, an entry could have more than one dimension proposed at the time you post it. When this happens, NAV needs a way to break the tie, and that way is dimension priorities.

dim priorities

This handy-dandy table allows you to be in control by choosing which table will take priority over the other if NAV is forced to choose. What happens if you don’t define the priority? This is where NAV’s built-in tie-breaker comes in. If you don’t define the priority, NAV will choose the table with the lowest Table ID number.

One sure way to avoid needing to do this at all is to think through your dimension strategy really carefully before you commit to it. If you define team as a dimension on both your customer master data and your item master data, and you give a customer and item different default dimensions, what’s going to happen when you post a sales order? You’re going to get a conflict where the system has to choose. Think through your strategy and I bet you can find a way to make sure that team only corresponds to customer and you could give a different dimension designation to item. By doing so, you’ve automatically designed your system not to have a conflict in the first place.

Keep reading this month as we continue our series, 15 Days of NAV Dimensions.


NAV dimension combinations for additional accuracy (part 8 of 15)

One way to get additional accuracy out of your NAV dimensions is to assign dimension combinations. Dimension combinations are really good for two things:  1) to keep you from posting something that simply doesn’t belong where you’re putting it, and 2) to keep you from posting a combination of dimensions together that don’t belong together. Let’s go through a couple of examples.

Say that, according to your dimension strategy, you’ve designated the dimension team to go with customer master data, and the dimension edition to go with item master data. If you don’t want team to ever be allowable together with edition, set a dimension combination of blocked on the grid where the two dimensions intersect.

Another example is something we do at my company. We rely very heavily on budgeted information and budget all of our product development expenses with two dimensions assigned: team and project. Each team has their own list of assigned projects and no team should ever share a project. In order to keep ourselves from having a lot of reclassification entries, we assign a dimension combination of limited on the grid where team and project intersect. dimcomboThis setting allows us to further drill down and define which projects belong to which team. If we receive bad coding or even just enter a project number incorrectly, if that project number is not one on the “approved” list of project dimensions assigned to that team, we’ll get a message that lets us know we’ve made an invalid choice before we post it into our system permanently.

Keep reading this month as we continue our series, 15 Days of NAV Dimensions.