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.

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.

See Also

Concepts

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