Category Archives: implementation

Importance of Testing

Overview

So, you’ve decided to switch to Microsoft Dynamics 365 Business Central and finished the hard work of development, migration, and training. Now you’re ready to go live, right? 

But, I’ll bet there’s one thing you’ve unknowingly neglected. That’s testing the new software. After the implementer tells you that they’re done with the development and migration, the first thing you need to do is to run testing. 

Testing might sound simple, all you need to do is run through a couple of scenarios, and you’re good, right? I wish it were as simple as that, but often it isn’t. 

After the implementer hands you the keys to the software, testing is an investment you and your team need to take seriously. Doing that will set you up for future success.

Testing is essential because it allows the users to:

  • Get familiar with the new system
  • Find potential problems
  • Discover unknown features
  • Overcome the fear of change
  • Establish confidence in your team

Make Sure Users Understand the Importance of Testing

It’s no secret: people are much more likely to take advice from people they trust.

The first step to implement an effective testing process is to build trust with the people you work with – and more specifically, the ones who are going to use the new system.

Even though we always emphasize on the importance of testing, most users won’t follow through with proper testing, even if they promised they would.

Why? There are many reasons. Often, the users are not aware of how important testing is. More often, however, they are just busy dealing with daily challenges and crises at work. 

This is why building trust with the company is key, and also having a clear and easy process ready for them. You, as the implementer, should be the subject-matter expert, but you also should see yourself as a mentor to managers, to help them help their employees.

Again and again, you need to explain the benefits of testing and that testing will benefit the user and their team. More importantly, emphasize on the fact that it’s not to waste their time; but rather is an investment that pays long-term dividends.

Time is one of the biggest reasons users will avoid testing, but time is also one of the reasons testing is so important.

Some of the main benefits that come from testing are to save time. Becoming familiar with the new system, solving any problems, and discovering all of the features will save users time in the future.

It’s essential to explain that while testing requires time upfront, it will save them precious time in the future.

Work With The People in Charge

The first important way of implementing a successful testing operation is to know your place: You’re not the one in charge, but you’re there to make sure that those who are thrive.

As a consultant, you’re not an employee but an advisor. The key to success is communication. You need to make sure that managers understand that you’re here to support their success; not to do everything for them. You need to set the stage for them to have all the necessary keys in their pockets so that whenever a problem occurs, they know what to do.

As it is the manager’s responsibility to oversee the testing, your job is to make sure that the testing is done properly and more importantly, they don’t cut corners. You also need the manager to be aware of how important test runs are.

If the management team of the company asks you to manage their people as if you were their boss, one thing you need to do is to get the customer’s managers to take the lead.

In order to make sure you don’t get a phone call every day with questions, you should have a plan that includes milestones for the use to be complete – so the testing process is faster and easier because the users have clear directions to follow. A good and simple plan will also give the managers something to look for and help them communicate with their team.

Again, explain the benefits of testing to the managers, and make it clear that in the long term, the company is going to save time and money by making sure everything is running properly. Don’t forget: the best offense is a good defence. 

As with anything new, it will take time for everyone to grow comfortable with the new system. It won’t happen overnight, but if everything is done strategically and in an organized manner, the risks of encountering problems in the future are going to be reduced and your clients are going to save precious time. By doing so, your clients will be more likely to recommend the system to other companies.

Make Sure The Process Is Easy

As an implementer, part of your job is to make the customer test the system, and more importantly, make the testing easy.

You can’t, and shouldn’t, sit and look over their shoulder and watch them run through different tests. That would be a waste of your time because that’s not what you are being paid for, and you want the users to run tests in their natural environment.

The users often forget that testing requires a lot of extra time and effort, on top of their regular workload; which is why you need to ease the process for them as much as you can.

The implementers can’t just mandate training. That will only make people want you to leave faster. Instead, provide them a clear step-by-step testing process that they can implement.

To Sum It Up

If implementers don’t do their job correctly, the testing won’t be successful.

Proper testing will benefit the users for years to come and make the new system much more enjoyable to use.

If the user is running into error after error, or they aren’t able to find the features they need in the new system, it will cause frustration, and make the system – or worse, you – look bad.

When the implementer does his/her job correctly, the transition from implementation to testing and regular use should be smooth. The users will still need to build confidence in the system and may encounter some problems, but testing will help prevent many unnecessary struggles with the system.

Why the Idle Client Timeout Won’t Work

Overview

Just a friendly reminder (or reminder for myself) that in order to get the Idle Client Time to work properly.

Make sure you change the Keep Alive Interval to something greater than Idle Client Timeout.

If you set the Idle Client Timeout to something LESS THAN Keep Alive Interval, the client will not disconnect automatically if they’re idle.

The Default

When you install Dynamics 365 Business Central (aka Dynamics NAV), this setting will be defaulted to 2 minutes. So if you want to kick people off if they’re idle for 5 minutes, make sure you remember to change this default setting.

Conclusion

Another one of those GOTCHA things when setting up the software…

Addressing Inefficient Business Processes

Overview

Addressing inefficiencies in any company is a crap shoot.

Often times, the management of a company will have a discussion with us to discuss their challenges. The conversation in these meeting usually leads to how can they address their “mess”. For example, their inventory quantities are always wrong.

It’s not like the managers have nothing better to do than to discuss these issues with consultants. These types discussion are usually forced on their company because their business environment is changing.

Their competitors are offering things like same day delivery, integrated e-commerce, real-time shipping notifications, inventory availability, customer self-service, etc. All in an effort to entice their customers away from them. These managers feel like they have to do something or they will be left behind.

The Lie

Most companies believe (or are sold) that if they upgrade or move to a new ERP or CRM software, their efficiency problems will magically go away (it’s a lie).

The analogy I like to use is visiting someone’s home. If the person is messy, the house will be a mess. It doesn’t matter whether they live in a small apartment or a large mansion.

The common belief is that if they live in a house that’s a mess, if they move into a larger home, it’ll be magically be not-messy. Unfortunately, that’s never the case. If you live in a small apartment and it’s a mess, moving to a larger space, it will still be a mess; but in a larger space.

The Cost

The technology portion is always where misunderstanding occurs. One of the justifications for a company that stays with inefficient processes are because they thought those type of systems are only for large companies. They do not have the budget for these expensive and complicated systems.

For example, one of the common problems that plagues every company is inventory. To resolve negative inventory in their system, the topic about using wireless scanners will come up.

The goal is the warehouse employees can be on top of inventory quantities and report discrepancies immediately as they see fit. The common rebuke will typically be “that’s for bigger companies, not a small company like us”. In reality, it’s not… It’s really not just for big businesses.

Back in the 90s and the early 2000’s, the technologies used by larger corporation had a high price tag. This means if you’re not a large corporation, you wouldn’t be able to enjoy a full ERP software without spending a chunk of your money.

For a large company with deep pockets, they can withstand these expenses, even if it doesn’t work out well. For a smaller or medium sized company, that may be a big risk.

Now, the functionalities enjoyed by large corporation are pretty well replicated for the small and the mid-market. This means you can be a micro-business and can still use the same functionality that large corporations uses.

In fact, the functionalities difference offered to large corporations and small companies are getting more narrow with every release. Case in point, Dynamics 365. You can be a 5 user company or a 500 user corporation, they can all use Dynamics 365. They can all use warehouse/shipping automation tools, they can all use dashboards, they can all integrate e-commerce to their system.

The Real Cost

The real cost of addressing the mess is the management of the company.

Of course, me being the terrible salesperson, pointing this out to them usually gets me in all sorts of troubles… But I digress…

In our example, if there is not a culture or process in place to have accurate inventory, then it’s not a priority. Doesn’t matter what system is in place, in the inventory will be a mess.

Just by implementing a warehouse system in place will not magically make your inventory accurate. It requires people to be on top of recording their work using scanners.

If there’s a culture of “I’ll just move this item here and record it later cause, you know, we’re busy”, your warehouse management system will ultimately fail.

That’s the funny thing about technology and automation is that if your process is efficient, it will make you a lot more efficient. But if you’re process is not efficient, technology and automation will make your operation a lot more inefficient, faster.

Conclusion

In the end, technology will only faciliate your existing process. What I always recommend people to do is to get their house in order before they consider automating it.

Don’t get me wrong, switching new systems is a perfect time to reorganize your process, but if you’re not fully onboard and get the key player’s buy in, it will turn into a nightmare really quickly.

Why You Should Set Automatic Cost Adjustment to Never in Dynamics 365 Business Central

Overview

This was one of the topics that came up frequently while working with users at the last NAV/BC User Group Summit at Phoenix.

Many people have different opinion to setup their inventory so costing is done properly. Naturally, knowing a few things on how Dynamics 365 Business Central (aka Dynamics NAV) inventory and how inventory costing works, I participated as much of these inventory costing discussions as I could.

One of the features that I always get in an intense discussion on is how the Automatic Cost Adjustment on the Inventory Setup should be done.

Arguments for Setting Automatic Cost Adjustment to Always

I do understand the desire to want to set this property to Always. And why not? Instead of running the Adjust Cost – Item Entries manually, why not let the system run the process every time? And I do mean Every. Single. Time.

Setting the Automatic Cost Adjustment to Always allows for you to have updated and accurate cost at all times. This sounds great!

Arguments Against setting the Automatic Cost Adjustment

It’s great if we can just talk about all the benefits and call it a day. But that’s now we work. Setting this property will come at a cost.

  • Performance – During posting, your users will experience delays. How significant this is will depend on how large your database is.
  • Locking issues – Dynamics Business Central will lock the ledger entry tables during posting of orders. In addition, it will lock tables when it runs the adjust cost process. Because of the stress on the performance above, the users will experience more locking problems throughout the day as people are posting. If you’re experiencing this now, try setting the Automatic Cost Adjustment to Never.
  • Allow Posting From Error – There are some instances where the adjust cost will want to post adjustments into prior periods. Depending on what you setup for your Allow Posting From on the General Ledger Setup and/or on the User Setup, you’ll run into these errors.

If you’re running a micro business with few inventory transactions, setting it to Always will make sense.

However, for a manufacturer or a high transactional volume distributor, you will cause more harm to your environment than not.

This is exponentiated if you’re using reservation or serial/lot tracking.

The Alternative

Instead of running the Adjust Cost – Item Entries process during every single transaction posting. Why not have the process run during off hours?

One of the first things we do for our client after explaining the importance of Adjust Cost – Item Entries is to setup the adjust cost process as job queue to be ran at night when the load on the system is light.

This will prevent locking up users as well as give the system a faster response when they’re doing their daily task. Who doesn’t want a system that’s responsive and allow you to do as much as possible within a shorter amount of time?

Conclusion

In every instance, I will set the Adjust Cost process to be ran automatically on the job queue. I want to give the user the best possible experience working with the system. Every delay causes frustration and we can all use less frustration in our lives.

Game Changing Concept for Cloud ERP with Dynamics 365 Business Central

Overview

One of my personal complaints about any cloud based ERP software the inability to make customizations that your business needs to maintain a competitive edge.

The assumption of a cloud ERP software is that every business should be able to fully utilize the software as the software developers intended. But as we all know in the real world, this is NEVER the case.

The Cloud ERP Problem

As much as software developers tries to develop functions that covers all basis for the users of their software, there will be nuance for each individual businesses and how they operate. This is exponentiated by the fact that their customers will throw out weird curveballs that the user will have to comply, no matter what.

What do you do in these instances? You have make changes to the system or keep track of the changes manually.

In this day and age where products are expected to be ordered in the morning and shipped in the afternoon, there’s no way in hell you can expect the user to keep track of data manually. Worst, the company may have to buy or develop a whole different software just to supplement what the original ERP can’t handle.

Either way, it’s a recipe for disaster.

So now you have a problem, you have a software that is not robust enough to meet your customer’s demands without major workarounds and you have data and processes you have to comply with.

Yeah… It’s not a very good situation…

What Makes Dynamics 365 Business Central Different

One of the main selling points for the old Dynamics NAV (aka Navision) was the ability the user can customize anything they want. Because of this, some very beautiful industry specific and horizontal solutions have been developed without additional integration software. Why? Because it’s built INTO the software.

The ability to modify anything you want is both good and bad and is subject to debate, but at least it’s available should you need it.

When Microsoft announced they’re moving Dynamics NAV to the full cloud and renaming it to Dynamics 365 Business Central, a lot of people kind of assumed we’d be taking away the core essences of what makes NAV great, it’s flexibility.

Then when the product launched, I see this little surprise in the Extension Management screen. The Extension Management screen basically allows you to add/remove any features you want that’s available:

What?! I almost wet my pants when I saw this!

This allows you and/or your NAV partner to make custom extension modifications to your specific Dynamics 365 Business Central deployment!

Not only can you enjoy the great infrastructure of Microsoft cloud, but you’re also able to make customizations to your specific needs?! Microsoft, specifically the Dynamics NAV product team, really hit this thing out of the park.

Still Work to Do

Being able to upload extensions to modify your deployment still has it’s limits.

You will only be able to “extend” on the base application, but you will not be able to actually modify the base code. For example, you will not be able to change how Reservation system works in base NAV, you can only modify around it.

But still, it’s a GREAT first step!

Conclusion

Welp… I’m excited. Cautious, but excited.  Naaa.. I’m just excited…

Going Live with Dynamics NAV (Dynamics 365) is the Easy Part

Overview

After doing ERP implementations with Dynamics NAV (aka Dynamics 365) for almost 2 decades (18 years to be exact…), you kind of know how to get things done.

Usually, when you prepare for a go-live during a software conversion, there are certain tasks and steps that absolutely have to be accomplished in a certain manner. There are certain things that you will also postpone until after you go live with the new system. Balancing what are absolulte musts and what can wait are what every legitimate project manager should do.

Another pitfall is spending countless hours talking about the exceptions and the wrong business process that ensues. Again, a legitimate NAV project leader should not take you down that path. From my experience one of the guarantee failures of taking a customer live is trying to “do too much”. Focusing on things that does not really matter to the business. As a legitimate Dynamics NAV (Dynamics 365) project manager, you should be well aware of what to be done and what shouldn’t be done when going live. On this subject, this is probably a separate article.

The Go-Live

A week prior to, you begin to feel the nervousness about switching to a new system. Despite my assurance on how everything will be fine because we followed the plan, they will still feel very anxious. The anxiety in the air is so thick you can scoop it with a spoon.

When the live date approaches, we do our thing to do the final cut over to their legacy system to Dynamics NAV. Run through our check-list and have the customers go through their check-list.

The next day when people come in for work, you can tell they were ready. They were ready for this because that’s what they’ve prepared for.

About a few days after the customer is live with the new system, the most frequent response I get is:

“That’s it?”

The Real Challenge

“Yes, that’s it. You’re live with Dynamics NAV.” That’s the response I typically give in response with a smile. As I mentioned, going live with Dynamics NAV is the easy part.

This is the point where my anxiety begins to increase, little by little.

Why?

If the customer just transacts with their normal business process and their customers and vendors behaves the same way, then everything would be okay. But it never happens that way.

There are always new problems and challenges as time progresses. Businesses do not stand still.

A couple of of these issues after go live that will begin to raises my blood pressure are, but not limited to the following:

– Exception problems or problems that are just weird and unusual
– Things that were allowed from their old system that are no longer allowed in the new system (i.e. just deleting a posted transaction)
– People circumventing the agreed upon process
– Wanting to turn on new features
– The “I didn’t mention because it’s not that important” processes. Well… It’s important now.

The toughest portion for the end user is after they go live for about 2-3 weeks. This is when all of the weird processes and exceptions start occurring and they have to deal with problems using the new environment and new thinking. Problems where they could just change a few numbers or transactions in the old system quickly, but they can’t do that anymore.

This is the part where the problems gets interest, and quite frankly, more fun. This is also the part where most solution center do not focus on because it’s not as lucrative.

Good Business Practice is a Lifestyle

What you resolved with your NAV partner during a new implementation is what you’re currently doing and where you want to go. These are known problems that has been brought up and addressed during the design of the software.

What challenges you going to face in the future are what we haven’t spoken about. It’s tough to plan and have a solution for something that you don’t even know about.

Dynamics NAV is a very good system. It’s also a very strict system. When you have an accurate system, sometimes problems come up where it was not apparent before or been swept under the rug. The reason is because it’s not important enough to deal with on a daily basis. i.e. inventory inaccuracies on the bins or returns processing.

With an accurate system, all of these normal process that no one wants to deal with will become apparent and will require a correct process and procedure for. Sometimes, when addressing these annoyance, owners will be surprised that they need additional resources to manage those processes.

Most of the time, when left unaddressed, those problem will blow up like a huge volcano. Implementing Dynamics NAV prevents these volcano type problems because it needs to be tracked.

Conclusion

Compound to real problems arising after 2-3 weeks is that implementation consultants will have already left by then, patting themselves on the back on a job well done.

As much as I advise on budgeting enough time and money for post implementation support, they always go unheard. Most of the quote that they receive for new software implementation are only enough to take them live, not to address these more interesting problems after they’re live.

Going live with Dynamics NAV (aka Dynamics 365) is the easy part. What comes after will be the core of the challenge during the implementation lifecycle.

Types of Training in Dynamics NAV

Overview

Often, we get calls from companies that asks us to help with their Dynamics NAV implementation. The conversation would usually start off about a little history of their implementation, the problems they’re running into, and what they’re looking to resolve.

Inevitably, the request will lead to training the users on how to better use Dynamics NAV.

This is a tough question to respond to.

With every release of Dynamics NAV, the software has become more intuitive and easy to use. In addition, Microsoft has released the full manual on their MSDN site. In addition, there are great step by step examples on how to process, for example, a sales order. So whenever I hear this request, my sense immediately goes into overdrive.

Of course, the customer will want an estimate on how long that will take.

Tough Question

What makes the subject of training a tough question is that the training, in itself, is not what the customer is looking for. What the customer is really looking for is, by the end of our task (whatever that may be), their users will have thorough understanding of their job responsibilities within the company and how Dynamics NAV can better their ability within their job roles.

They’re looking for their users to have an A-ha basically saying “Wow! I fully understand my job and can do my job 300% faster now!”.

The Response

Being a terrible salesperson, instead of giving them some numbers and try to close the deal, will naturally ask a ton of questions on their request. I will even question their question because I just find this request (although challenging) very fascinating.

Most of the time, the people that are reaching out are not the managers or the people that are responsible for the task. They’re just “forced” into it by their boss or owners. Instead of a number so they can create a list to find the cheapest one, they get more questions.

On a side note, the calls we get where the person has to hang up and ask their boss or other people for more information ususally never calls us back. Subsequent follow up calls are ususally unreturned as well.

Not All Training Are the Same

There are many aspects when we talk about training. To keep things simple, we’ll just talk about 2 types of training. One is just learning how to use Dynamics NAV, the other is learning how to use Dynamics NAV in conjunction with your job roles within your organization.

In my opinion, training just how to use NAV is not worth to company to spend their money on. The reason is, as mentioned above, there are plenty of resources (such as MSDN site mentioned above) that are free for the user to learn how to navigate around Dynamics NAV.

The training that I would always recommend is the implementation type of training is where the training covers the details of their job on how Dynamics NAV can help them do their specific job. The training would be how to better do their job with Dynamics NAV, instead of just using NAV.

The Challenge

The challenge is how to explain this to the customer who is tasked by their supervisor to “get more training”.

They would need to understanding their internal business process for each department and how NAV will fit into each part of the business process. They will need to fill the consultants in on how things work for the consultants to devise a training plan.

If the customer does not do , they will need to spend the money to have someone else to do so. Very much like an implementation.

Conclusion

Of course if the users do not have time to learn the product or they prefer to learn in a classroom environment, consultants like us would step in and help out. Even then, the training shouldn’t be just how to use NAV. Rather, it should incorporate what their job functions are within NAV.

Sometimes the training should just consist of a big Q&A session where the users can bring up what they’re doing and how to better utilize their job function in the system.

Understanding what type of training you require will save you a ton of time and unnecessary costs from consultants like ourselves. It does require some work on the end user to determine what kind of training is needed.

Better to put the work up front than having to pay, a lot, later.

Dynamics 365 for Financials will include Full Functionality of Dynamics NAV

Announcement

Microsoft Dynamics 365 for Financials will offer the full functionality of the regular Dynamics NAV by the end of the year!

Dynamics365 for Financials will now cover all functionalities in Dynamics NAV

Overview

Until the functionality update take effect, if you signed up for Dynamics 365 for Financials you will only receive limited functionalities for within the Dynamics NAV product. The area available are mainly in the finance and order fulfillment areas.

After the update, which is promised to be by the end of the year, you will receive the full functionality as if you purchased Dynamics NAV. This includes manufacturing and WMS functionalities.

What Will be the Difference?

This is the first question that everyone will ask. Why does my company want to purchase a full Dynamics NAV license instead of just signing up for Dynamics 365 for Financials?

The answer is Customization.

For Dynamics 365, the way to “customize” what’s available out of the box is to implement extensions available from the Microsoft Appsource. This means that if you need a one-off change because you provide a differentiating service than your competitors, you will need a work around.

Whereas if you purchased Dynamics NAV product, you will be able to make these types of changes.

The Future

Extensions for Dynamics NAV (and Dynamics 365 for Financials) is ever changing. With each release, Microsoft introduces new features and expanding on the previous release. So it’s tough to say whether the paths for Dynamics 365 for Financials and Dynamics NAV will truly converge.

I’m just glad the customers do not have to sign up for the complex Azure infrastructure if they want their solution to be truly on the cloud.

The Story of Our Dynamics NAV Implementation in Taiwan

This is a story of our Dynamics NAV implementation in Taiwan.

One of the things that I’m most proud of is the people that choose to work with me and the company that we built.

I am proud that everyone shares the same vision on what software implementations should be. That we care about doing the right things, even if it hurts our own bottom line.

That pride is none more so apparent than our team in Taiwan. A little background, our Taiwan branch began operation in 2014. In the relative short amount of time, they developed the Chinese Language Pack for Dynamics NAV. During this time, they’re also involved in a tough implementation in Taiwan for a licensed toy distributor.

Fast-forward today, the customer in Taiwan is so happy with how their Dynamics NAV implementation went, they agreed to speak on behalf of us with Microsoft on one of the most popular IT magazines in Taiwan.

In case you can read Chinese, here’s the link:
http://www.ithome.com.tw/pr/111319

Also in PDF version:

Dynamics NAV_麗嬰國際

Here are the highlights of the article:

– Origially had a 5 year plan to move out of the HEAVILY customized UNIX based system. We only utilized 1.5 years to implement Dynamics NAV. (According to the article, 6 months for analysis and 9 months for implementation)
– Reduce their inventory return amount up to tens of millions in local currency.
– Redesign the inventory put and pick process and increased the accuracy by at least 100%.
– Implement wireless handheld device and doubled the warehouse shipping efficiency
– Improve order process efficiency. Now it only takes one fifth of the time to proces an order (500% increase).

The Challenge

This implementation in Taiwan was indeed one of the most complicated that I’ve been involved in. Not only has their UNIX system insanely customized, but there were virtually no documentation on the operation.

Because of the type of business they’re in, they add between 10,000 to 20,000 items every month. That’s right! over 10k new items every month. You can see why order entry and communicating those new items with their large distribution network is a nightmare. In addition, think about how the warehouse will go about fulfilling these orders.

When we did our first analysis, I was personally shocked at how they were able to manage such a large volume of business with their current setup. Basically, our job was to go from no documented business process to having Dynamics NAV fully functional. The fact that our team did it in 1.5 years is nothing short of amazing.

There were countless fierce meetings and conversation both internally and with the client to better their existing business process. Even though these discussion were fierce, the client really appreciated that we did not just go with the status quo and replicate their existing business process.

Conclusion

Having the right people in the right place really makes all the difference in the world. This project wouldn’t be a success without their involvement. The people that works with me, quite honestly, can work anywhere else and any company; but they choose to work with me. That really gets me in the feels…

Performance Problem in VM Environment for NAV 2016 and Beyond

Overview

This is a story of upgrading one of our clients from Microsoft Dynamics NAV 2013 to Microsoft Dynamics NAV 2016 (we recommended going to NAV 2017, but they didn’t want to be guinea pigs).

The upgrade itself was done on the customer’s live server, which was a brand new powerful server on VM (virtual) environment. During the upgrade, our developers complained that the performance on the live server was extremely slow. Initially, we thought it may have been the large amount of data (100 GB) that are being upgrade so we brushed it off.

When we went live, that’s when the performance on NAV got worst.

The Problem

Researching on Google and the Dynamics NAV forums on performance issues with Dynamics NAV 2016 came up with nothing. Of all the researches, NAV 2016 should perform a lot faster, not slower.

We’ve tried reindexing, changing the settings on the Dynamics NAV service tier, changing the CPU cores, SQL tuning. Nothing worked.

The problem in the end was how the VM hosts were setup. It matters which host SQL Server and Dynamics NAV server were setup. The following VM configuration was how the server was setup:

virtualenvironmentdynamicsnav

The Solution

The internal IT director put the Dynamics NAV server and the SQL Server on the same host on the VM and *poof*… All the performance problems went away. NAV was back running in blazing speed.

What was strange was that for NAV 2013, the SQL Server and the Dynamics NAV Server was running on different host and there were no performance issues.

Conclusion

When you’re in an VM environment, put the SQL Server and the Dynamics NAV server on the same host machine.

Upgrading to Dynamics NAV 2016 is nothing new for us. We’ve done quite a bit of the upgrades for companies but this issue baffled me a bit. The same structure used on NAV2013 did not work well on NAV2016.

Hopefully, if you read this, it will save you from some headaches that I’ve gone through.