Set up and apply configuration data in the Common Data Service

Applies To: Project Operations for resource/non-stocked based scenarios

Prerequisites

Before you begin to configure data in the Microsoft Dataverse, the following prerequisites must be met:

  1. Provision a Dataverse environment and a Dynamics 365 Finance environment for Project Operations.
  2. Legal entity information from Dynamics 365 Finance is shared to the Dataverse environment. This means that the Company entity in Dataverse has the following company records:
  • THPM
  • USPM
  • GBPM

Install setup and configuration data

  1. Download, unblock, and unzip the Setup and Configuration Data Package.
  2. Navigate to the unzipped folder and run the executable file, DataMigrationUtility.
  3. On page 1 of the Common Data Service Configuration Migration (CMT) Wizard, select Import Data and then select Continue.

Configuration Migration.

  1. On Page 2 of the CMT Wizard, select Microsoft 365 as the Deployment Type.
  2. Select the Display a list of available organizations and Show Advanced check boxes.
  3. Select the region of your tenant, enter your credentials, and select Login.

Configuration Sign in.

  1. On page 3, from the list of organizations on the tenant, select the organization you want to import the demo data into and select Login.
  2. On page 4, select the zip file, SampleSetupAndConfigData from the unpacked folder.

Zip File Selection.

Select a file.

  1. After the zip file is selected, select Import Data.

Import Data.

  1. Import will run for approximately two-ten minutes depending on your network speed. After import completes, exit the CMT Wizard.
  2. Check your organization for data in the following 26 entities:
  • Currency
  • Chart of Accounts
  • Fiscal Calendar
  • Currency Exchange Rate Types
  • Payment Day
  • Payment Schedule
  • Payment Term
  • Organizational Unit
  • Contact
  • Tax Group
  • Customer Group
  • Vendor Group
  • Unit
  • Unit Group
  • Price List
  • Project Parameter Price List
  • Invoice Frequency
  • Bookable Resource Category
  • Transaction Category
  • Expense Category
  • Role Price
  • Transaction Category Price
  • Characteristic
  • Bookable Resource
  • Bookable resource category Assn
  • Bookable Resource Characteristic

Complete Import.

Update Project Operations configurations

  1. Navigate to the CE environment. You can find it by opening the Power Platform Admin Center, selecting the environment, and then selecting Open Environment.

Open Environment.

  1. Go to Projects > Resources and then select New to create a bookable resource for your user.

Bookable Resources.

  1. On the General tab, select your admin user. Verify that the time zone matches the one you are in.

New Bookable Resource.

  1. On the Scheduling tab, in the Company field, pick the USPM company, and then select Save.

Scheduling Tab.

  1. Select the Work hours tab.

Work Hours.

  1. Double-click on any value in the calendar and select Edit > All events in the series.

Work Calendar.

  1. Change work hours to an eight (8) hour work day, mark weekends as non-work days, and make sure time zone matches yours.
  2. Select Save and close.

Update Calendar.

  1. Go to Settings > Calendar templates and select New.

Calendar Templates.

  1. Enter a name, select the template resource you created, and then select Save.

Save Calendar Template.

  1. Go to Parameters and double-click the record.

Project Parameters.

  1. Update the following fields:
  • Default company: USPM
  • Default Organizational Unit: Contoso Robotics Global
  • Invoice Frequency: Seventh and Last day
  • Work hour template: Change to the template you created.
  1. Select Save.

Updated Project Parameters.