Hands-on-Lab 2.2

Neil HaddleyNovember 22, 2023

Migrate master data to a new company

Hands-on-Lab 2.2: Migrate master data to a new company

"After completing the basic configuration, you can now start by uploading the company’s business data, such as customers, vendors, items and the chart of accounts.

In order to prepare the migration of this data, you will configure some configuration packages and provide these excel-files to Contoso’s super users, to complete the information.

You will start with the vendor list, including contact information. To make sure the users know how to complete the required information, you prepare the following example."

I used the search button to navigate to the Configuration Packages page

I used the search button to navigate to the Configuration Packages page

I clicked the + New button

I clicked the + New button

Dialog opened with new Configuration Package

Dialog opened with new Configuration Package

I entered a code, a name and clicked on the three dots button in the Table ID column

I entered a code, a name and clicked on the three dots button in the Table ID column

I selected the Vendor Table

I selected the Vendor Table

I clicked on the Table tab

I clicked on the Table tab

I clicked on the Fields button

I clicked on the Fields button

I clicked the No button

I clicked the No button

I clicked the Clear included button

I clicked the Clear included button

Only the No. field was still selected

Only the No. field was still selected

I clicked on the checkboxes to select the Name, Address, City, Phone No., Currency Code, Language Code, Country/Region Code and Post Code fields

I clicked on the checkboxes to select the Name, Address, City, Phone No., Currency Code, Language Code, Country/Region Code and Post Code fields

I clicked the Export to Excel button

I clicked the Export to Excel button

I clicked Yes

I clicked Yes

I opened the Configuration Package (the Excel Workbook)

I opened the Configuration Package (the Excel Workbook)

I added the vendor details

I added the vendor details

I used the search button to access the Currencies page

I used the search button to access the Currencies page

I clicked the + New button

I clicked the + New button

I added GBP details

I added GBP details

I set the Realized Gains and Realized Losses accounts

I set the Realized Gains and Realized Losses accounts

The GBP Currency had been added

The GBP Currency had been added

I used the search button to access the Counties/Regions page

I used the search button to access the Counties/Regions page

I added details for the (fictional) Island of Sodor

I added details for the (fictional) Island of Sodor

I used search to navigate back to the Configuration Packages page and selected the Import from Excel button

I used search to navigate back to the Configuration Packages page and selected the Import from Excel button

I selected the updated Excel Workbook

I selected the updated Excel Workbook

I clicked the Import button

I clicked the Import button

I scrolled to the right to review the number of tables, rows and errors. I clicked the Apply Package button

I scrolled to the right to review the number of tables, rows and errors. I clicked the Apply Package button

The dialog confirmed that 9 records were inserted

The dialog confirmed that 9 records were inserted

I clicked on the Vendors link to navigate to the Vendors page

I clicked on the Vendors link to navigate to the Vendors page

I reviewed the inserted Vendor records

I reviewed the inserted Vendor records