Create a Test Company in Microsoft Dynamics NAV

Create a Test Company in Microsoft Dynamics NAV

There are some very good reasons why you would want to have a test company setup for Dynamics NAV, including new employee training, exploring process changes, or before adding new, or updating existing, functionality. Having a test company allows you to examine the cause and effect of making changes to your master data (customers, items, vendors, etc.) without impacting your production data.

When creating a test company for Dynamics NAV, you need to make a couple of decisions first.

  1. Where will it reside? Will the testing company be in the production database or in a test database?  Either way, it is good practice to create and update your test company monthly.
  2. How will you copy your production data into the test company?

In this blog, we will create a test company and explore the options for the best location to place the test company. Let’s first walk through the differences between the options. These instructions are for Microsoft Dynamics NAV 2017.

Deciding Where to Setup the Testing Environment

When you think about how you want to setup your testing environment, you have two main choices: creating the test company in the production database or in a test database. The best practice is to create the test company in a test database. The main reason is to allow you to test different development changes and not affect your production environment. If you determine you don’t want to have changes or new development, ask yourself  the following questions to help facilitate your decision on where to place the test company:

  • What will be easier for users to open and use?
  • What will be easier for users to determine which company they are in?
  • What is easier for the department that needs to create the test company?
  • How long does it take to create?

Based on your answers, you will be able to make a decision on the best location for your test company. If in doubt, go with the decision of creating a test database where you can put the test company.

Making a Copy of Production Data

The next step is to make a copy of your production data. There are several ways to create the environment:

  1. Backup your Database and Restore the Database in Test Environment

Make sure you understand the process first so that your production database is not accidentally changed.

  1. Export Production Data and Import into Test Company

Do the objects/development customizations match between the two systems? If they do, follow the steps below. If they don’t match, you will need to get them in sync before you start.

  1. Copy the Production Company
  1. Open the NAV production database
  2. Search “Companies”
  3. Place your cursor on the line of the company you want to copy
  4. In the ribbon select copy
  5. Fill in the test company name
  6. Once the process is complete, you will see the test company on the list

For option 2 above, export your production data into a test company, follow these steps:


Figure 1 – Database Search

  1. From the list, select “Export to a data file”
  2. Check which companies you want to export
  3. Fill in the Description
  4. Select which companies you would like to sync between test and production and pick the smallest company, so sync doesn’t take too much time
    Exporting the data field in Dynamics NAV 2017
    Figure 2 – Export Data Field
  5. Select OK
  6. Save the file
  7. Open Test while the data is exporting
  8. Search Companies, You have two options
    1. Delete the company you want to replace
    2. Rename the company to a – old
  9. When the export is done, from the test database
  10. Search “Import from”
    Import the data field in Dynamics NAV 2017
    Figure 3 – Import Data Field
  11. Find where you saved the exported data
  12. Select OK
  13. After the import, you will want to verify the data came in and you have no issues.

Knowing how to create a test company in Dynamics NAV will give you a tool to grow and expand the use of the system.

If you would like to learn more about creating a test company, contact ArcherPoint.

Read more “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV. 

    Trending Posts

    Stay Informed

    Choose Your Preferences
    First Name
    Last Name
    Subscription Options
    Your Privacy is Guaranteed