4 Jan’19

D365 GeneralMigrating Activities Of Type ‘Case Resolution’ Between Two Microsoft Dynamics CRM Environments

Introduction:

While migrating Cases, the migration of activities of type ‘Case Resolution’ is necessary. However, the complexity in migrating this increases due to the fact that when the status of a case is updated, a blank case resolution activity is created automatically by the system. This system-generated case resolution needs to be deleted as this would result in each case having two case resolution activities after migration – one system-generated and one with the correct migrated data from the source.

Solution:

To tackle this issue, one must follow the following steps during migration:
1. Send all Cases (no matter what the status in the source environment) to the target with their status as ‘Open’.
2. Send all related activities to the target environment.
3. Update the case status in the target environment to its status as in the source environment.
4. For cases with status ‘Resolved’, a system-generated case resolution activity will be created.
5. In your case resolution migration map, first add a step to delete the existing case resolution in the target and then insert the case resolution from the source environment.
6. Now your case with status ‘Resolved’ will have only one case resolution and that will be the one migrated from the source environment with the correct data.

Conclusion:

Above steps shed some light on how to preserve the integrity of case resolution activity data in your target environment during data migration.

Written by

Simran Monteiro

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • 3 Biggest all-time ERP Myths

    17 January’ 2019

    Introduction: In my personal experience over the years, whenever I dealt with business owners, directors, and CTOs in t...

    Read more
  • Create a Customer, Vendor, or Bank Account from a Contact

    16 January’ 2019

    Introduction: Companies want to record some of contacts as customers, vendors, or bank accounts. Creating a customer, v...

    Read more
  • Creating an Email activity in MS CRM through WebApi

    16 January’ 2019

    Introduction: This blog explains how to Create an Email activity in MS CRM through WebApi Request: Post URL:  <yo...

    Read more
  • Time entry using model driven PowerApps

    10 January’ 2019

    Introduction: Managers and employees need a good time entry application to record worked hours for billing, payroll, or...

    Read more
  • Formatting Address Data separated by delimiter in the single field

    10 January’ 2019

    Introduction: Whenever the a single field in NAV contains Name, Address and other values seperated by delimiter such as...

    Read more