Migrate from Goodlegal to Microsoft Dynamics 365 Sales

Goodlegal matter records (name, status, responsible attorney, billable amount, currency, matter type) have no direct Dynamics 365 Sales equivalent. We create a custom Matter Dataverse table with all matter fields as columns, linked to the primary Account or Contact record via a lookup relationship.

Goodlegal party contacts map directly to Dynamics 365 Contact records in a one-to-one relationship. The primary email address on each Goodlegal contact resolves to Contact.Emailaddress1 in Dynamics 365. A Matter lookup field on each Contact links back to the corresponding Goodlegal matter, preserving the association between the client party and their related legal matter throughout migration.

Goodlegal organization records map directly to Dynamics 365 Account records. Company name maps to Account.Name, website maps to Account.Website, and industry maps to Account.Industry. Multiple contacts belonging to the same company in Goodlegal collapse into a single AccountId lookup on each Contact record, ensuring a clean hierarchical structure in Dynamics 365.

Goodlegal document metadata (file name, document type, matter association, URL) migrates to a SharePoint document library folder scoped to the Matter Dataverse record. The original document URL is stored as a SharePoint Document Location record linked to the Matter; actual file blobs are re-uploaded into SharePoint as part of the migration.

Goodlegal clause-library entries (clause name, clause text, category, usage count) have no native Dynamics 365 Sales equivalent, so we create a custom Clause Dataverse table. Each clause record includes a lookup to the Matter table, enabling clauses to be associated with specific matter records after migration is complete.

Goodlegal document templates (with field placeholders and clause insertion logic) are platform-native rendering rules. They do not export as data. We export template metadata (name, description, last-used date) as a custom Power Automate reference record, and your legal-ops team rebuilds the rendering logic in Power Automate using the exported template definitions as a specification.

Goodlegal matter status values (Active, Pending Review, Closed, On Hold) map to a custom Status__c picklist on the Matter custom Dataverse table. Each status value maps explicitly to the corresponding Dynamics 365 custom picklist value so reporting continuity is preserved.

Goodlegal billable_amount and currency_code map to two custom fields on the Matter table: Billable_Amount__c (decimal) and Currency__c (picklist). For matters linked to a sales opportunity, the billable amount can optionally populate the Dynamics 365 Opportunity.Amount field to surface legal revenue inside the pipeline.

Goodlegal attorney owner is resolved by email match to a corresponding Dynamics 365 user. Unmatched attorneys are flagged before migration so your admin can invite them to Dynamics 365 or assign their matters to a fallback owner. The OwnerId field on the Matter table carries the resolved Dynamics 365 user reference.

Goodlegal's original create_date and last_modified_date are preserved as custom datetime fields on the Matter table named Matter_Create_Date__c and Matter_Modified_Date__c respectively. Dynamics 365's native CreatedOn and ModifiedOn fields are set to the migration execution timestamp, while the custom fields retain the source system timestamps to maintain full audit continuity and historical reporting accuracy.

Goodlegal counterparty records on a matter — opposing counsel, co-counsel, or third-party contacts — migrate as additional Contact records linked to the Matter via a secondary N:1 relationship. This lets Dynamics 365 Contact records represent both primary clients and matter-side counterparties.

Every migrated record — including Matter, Contact, Account, and Document entities — carries its original Goodlegal internal identifier in a Goodlegal_Source_ID__c custom field. This cross-reference field enables delta-run de-duplication, supports cross-system lookups between Goodlegal and Dynamics 365, and provides complete audit traceability back to the source system for compliance and reconciliation purposes.