Use Templates to Prepare Customer Data for Migration

After you import and apply setup data in the new database, you can start migrating the customer’s existing master data, such as item and customer numbers and names. To make sure that this data is created quickly and accurately in the new company, you should use templates to structure the data.

Typically, you create data templates for the following master data tables:

  • Contact

  • Customer

  • Item

  • Vendor

However, you can create a template structure for and apply it to any table in Microsoft Dynamics NAV.

Tip

You can also use data templates for daily operations to create new records that are based on templates. These data templates only work for the supported master data tables. For more information, see How to: Create Cards by Using Data Templates.

When you import customer data, such as for items, from a file, the mandatory field data that you have specified is taken from the linked data template. When you create a new item, you only enter general information such as item name, description, and price and then collect the rest of the mandatory field data from a selected data template.

When you create a new master data record, such as a customer card, some fields are mandatory and must be filled in. You can group most mandatory fields, such as posting groups and payment terms, to make creating master data records easier and more stable. For example, you can group mandatory fields for table 18, Customer, as Domestic, Foreign, or Export types.

The following table describes the sequence of tasks with links to topics that describe them. These tasks are listed in the order in which you generally perform them.

To See

Evaluate configuration data templates and determine whether they meet the customer's needs.

How to: Select a Configuration Template

Create new customized templates if the default templates do not meet the customer's needs.

How to: Create a Configuration Template

Create a record that is based on a configuration data template.

How to: Create a Record from a Configuration Template

Use a configuration data template on a record.

How to: Use a Configuration Template on a Record

See Also

Concepts

Migrate Customer Data
Set Up a Company With RapidStart Services for Microsoft Dynamics NAV