CRM migration
Field-level mapping, validation, and rollback between Legal Files and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .
Legal Files
Source
Microsoft Dynamics 365 Sales
Destination
Compatibility
12 of 12
objects map 1:1 between Legal Files and Microsoft Dynamics 365 Sales .
Complexity
BStandard
Timeline
48–72 hours
Overview
Legal Files organizes legal work around matters, parties, documents, and deadlines in a purpose-built case management environment. Microsoft Dynamics 365 Sales is a cloud-native CRM that uses Accounts, Contacts, Leads, and Opportunities as its primary objects, with Dataverse as the underlying data layer and Power Platform as its extension surface. The migration challenge is translating a matter-centric legal model into Dynamics 365's relationship-centric CRM model — matters become Cases (or custom Matter entities), parties become Contacts and Accounts, and documents attach via SharePoint integration. We map Legal Files matters to Dynamics 365 Cases using the Case entity, preserving filing date, case number, matter type, and responsible attorney as custom fields. Parties resolve to Contacts (individuals) and Accounts (organizations) based on party type. Time entries and billing data migrate as custom fields or to the Dynamics 365 Finance and Operations module if invoicing is required. Documents export from Legal Files and re-upload to SharePoint with links back to the related Case record. What does not migrate: Legal Files workflows, automated reminders, and rule-based calendaring must be rebuilt in Dynamics 365 using Power Automate. Custom document templates, clause libraries, and matter-specific email rules have no Dynamics equivalent and require manual reconstruction. The migration uses Legal Files' database export (SQL Server or file-based backup) and maps the extracted schema to Dataverse tables via our bulk API loader.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Source platform
Legal Files platform overview
Scorecard, SWOT, gotchas, and pricing for Legal Files.
Destination platform
Microsoft Dynamics 365 Sales platform overview
Scorecard, SWOT, gotchas, and pricing for Microsoft Dynamics 365 Sales .
Data migration guide
The complete Microsoft Dynamics 365 Sales migration guide
Data model, import mechanisms, field mapping strategy, pitfalls, and cutover — by the engineers running it.
Destination checklist
Microsoft Dynamics 365 Sales migration checklist
Pre- and post-cutover tasks for moving onto Microsoft Dynamics 365 Sales .
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a Legal Files object lands in Microsoft Dynamics 365 Sales , including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
Legal Files
Matter
Microsoft Dynamics 365 Sales
Case
1:1Legal Files matters map directly to Dynamics 365 Cases. Matter number, filing date, status, and matter type translate to Case ID, Created On, Status, and a new_MatterType custom picklist. Attorneys assigned to matters resolve to Dynamics 365 users by email match. Closed matters migrate with historical status preserved.
Legal Files
Matter
Microsoft Dynamics 365 Sales
Custom Matter Table (Dataverse)
1:1If the firm's legal workflow requires matter-specific fields that don't fit the standard Case entity (e.g., opposing counsel, litigation phase, jurisdiction, statute of limitations), we create a custom Matter table in Dataverse linked to the Case via a lookup relationship. This is the most common extension for legal-matter migrations.
Legal Files
Party (Individual)
Microsoft Dynamics 365 Sales
Contact
1:1Legal Files parties of type 'Individual' map to Dynamics 365 Contacts. Full name splits into First Name and Last Name fields. Email address, phone, and address fields map directly. Party notes and role within matter (e.g., plaintiff, defendant, witness) become custom fields on the Contact record.
Legal Files
Party (Organization)
Microsoft Dynamics 365 Sales
Account
1:1Legal Files parties of type 'Organization' map to Dynamics 365 Accounts. Organization name becomes Account Name. Website, industry, and address fields map directly where present. Multi-office organizations create multiple Account records with a parent-child hierarchy preserved via the Parent Account field.
Legal Files
Party Role (within Matter)
Microsoft Dynamics 365 Sales
Custom Party Role Field
1:1Legal Files captures party roles per matter (e.g., Opposing Counsel, Insurance Carrier, Expert Witness). Dynamics 365 has no native party-role-per-case concept. We create a custom multi-select picklist field (new_PartyRole) on the Contact-to-Case relationship or a custom junction entity linking Contacts to Cases with a role designation.
Legal Files
Document
Microsoft Dynamics 365 Sales
SharePoint Document (via Dynamics 365)
1:1Legal Files documents export to the local filesystem. We re-upload them to SharePoint Online using Dynamics 365's native SharePoint document management integration. Each document set attaches to the corresponding Case record. Original file names, create dates, and author metadata are preserved. SharePoint folder structure mirrors Legal Files' matter/subject hierarchy.
Legal Files
Email (Linked to Matter)
Microsoft Dynamics 365 Sales
Email (Activity) attached to Case
1:1Legal Files emails linked to matters migrate as Dynamics 365 Email activities attached to the Case. Sender, recipient, subject, body, and sent date map directly. Email attachments migrate with the email as SharePoint documents linked to the same Case record.
Legal Files
Calendar / Deadline
Microsoft Dynamics 365 Sales
Task (or custom Deadline entity)
1:1Legal Files calendared deadlines become Dynamics 365 Tasks attached to the Case with a due date. Critical dates (statute of limitations, discovery cutoffs, trial dates) map as Task records with Subject and Due Date fields. Recurring deadline rules require manual rebuild in Power Automate, as Legal Files' recurring calendar logic has no direct equivalent.
Legal Files
Time Entry / Billing
Microsoft Dynamics 365 Sales
Custom Billing Fields or Dynamics 365 Finance
1:1Legal Files time entries (date, attorney, hours, billing rate, description) map to a custom TimeEntry table in Dataverse linked to the Case and Contact. If the firm uses Dynamics 365 Finance and Operations or Business Central for billing, time entries can route to the ERP module for invoice generation. We identify the best path during the migration audit.
Legal Files
Custom Fields (Matter-level)
Microsoft Dynamics 365 Sales
Custom Fields on Case or Matter Table
1:1Legal Files allows unlimited custom fields per matter. Each custom field is evaluated for type (text, date, picklist, numeric) and mapped to a corresponding Dataverse column with the new_ prefix. Picklist fields require value-by-value mapping where source picklist values differ from Dynamics 365 defaults. We create a field mapping matrix during the audit phase.
Legal Files
User / Attorney
Microsoft Dynamics 365 Sales
SystemUser
1:1Legal Files users and assigned attorneys resolve to Dynamics 365 SystemUser records by email address match. Unmatched users are flagged before migration so the firm can either create their Dynamics 365 user record or assign their cases to a fallback attorney. OwnerId on migrated Case records must reference a valid SystemUser.
Legal Files
Attachment / File (General)
Microsoft Dynamics 365 Sales
SharePoint via Dynamics 365
1:1Non-document attachments in Legal Files (images, PDFs, spreadsheets linked to matters) re-upload to SharePoint and linked to the corresponding Case. File size limits follow SharePoint Online constraints (250MB per file by default). We verify SharePoint storage quotas before migration to estimate document migration scope.
| Legal Files | Microsoft Dynamics 365 Sales | Compatibility | |
|---|---|---|---|
| Matter | Case1:1 | Fully supported | |
| Matter | Custom Matter Table (Dataverse)1:1 | Fully supported | |
| Party (Individual) | Contact1:1 | Fully supported | |
| Party (Organization) | Account1:1 | Fully supported | |
| Party Role (within Matter) | Custom Party Role Field1:1 | Fully supported | |
| Document | SharePoint Document (via Dynamics 365)1:1 | Fully supported | |
| Email (Linked to Matter) | Email (Activity) attached to Case1:1 | Fully supported | |
| Calendar / Deadline | Task (or custom Deadline entity)1:1 | Fully supported | |
| Time Entry / Billing | Custom Billing Fields or Dynamics 365 Finance1:1 | Fully supported | |
| Custom Fields (Matter-level) | Custom Fields on Case or Matter Table1:1 | Fully supported | |
| User / Attorney | SystemUser1:1 | Fully supported | |
| Attachment / File (General) | SharePoint via Dynamics 3651:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
Legal Files gotchas
No API — migration requires direct SQL Server database access
Document file transfer is separate from database migration
Email routing rules do not auto-migrate
Custom field discovery requires schema inspection
Microsoft Dynamics 365 Sales gotchas
Professional tier 15-table custom table limit blocks migrations
October 2024 pricing increase applies at renewal for all customers
Custom fields must be created in the UI before API writes
Power Platform request limits apply to bulk migrations
Activity records orphaned to inactive owners fail silently
Pair-specific challenges
Migration approach
Audit Legal Files database schema and data inventory
FlitStack AI connects to the Legal Files SQL Server database (or receives a database backup) to catalog the full schema: all standard and custom tables, field types, relationships, and record counts. We identify matter hierarchies, custom field definitions, document storage paths, and time entry structures. The audit output is a data inventory document that identifies which objects will map cleanly to Dynamics 365, which require custom fields, and which require schema extensions. This step also identifies data quality issues — duplicate parties, missing email addresses, and null required fields — that should be corrected before migration to avoid Dynamics 365 validation errors.
Design Dynamics 365 schema and SharePoint document structure
Based on the audit, FlitStack AI delivers a Dynamics 365 schema design document: custom field definitions with the new_ prefix, data types, picklist value mappings, and the configuration of the custom Matter table or PartyInMatter junction entity if needed. We specify the SharePoint document library and folder structure that mirrors Legal Files' matter hierarchy. Your Dynamics 365 admin or our team creates the custom fields, configures the Case form layout, and enables SharePoint integration before the data migration runs. The schema must be in place before we begin loading data.
Map parties, resolve users, and build migration staging tables
FlitStack AI builds a staging layer that maps Legal Files parties to Dynamics 365 Contacts and Accounts. Organizations route to Accounts; individuals route to Contacts. We perform email-based user resolution — Legal Files attorneys and users matched to Dynamics 365 SystemUser records by email. Unmatched users are flagged so the firm can create their Dynamics 365 accounts before migration. For each matter, we build a Case staging record with all mapped fields. Documents are staged for SharePoint upload with their target folder paths computed from the matter hierarchy. Time entries are staged in the custom TimeEntry table structure.
Run sample migration with field-level diff
A representative sample migrates first — typically 100–500 matters spanning different matter types, statuses, and document volumes. We load data into Dynamics 365 Dataverse using the bulk API and upload the first batch of SharePoint documents. A field-level diff report compares source values against destination values for every mapped field, flagging any truncation, formatting changes, or missing data. You review the sample in Dynamics 365 before we proceed to the full migration. This step catches picklist value mismatches, SharePoint folder permission issues, and custom field label discrepancies before they affect the full dataset.
Execute full migration with delta-pickup cutover
The full Legal Files dataset loads into Dynamics 365: Accounts and Contacts first (to resolve foreign keys on Cases), then Cases with owner assignments, then activities and documents. A delta-pickup window (24–48 hours) captures any new matters, updated party records, or documents added in Legal Files during the cutover window. FlitStack AI generates an audit log of every record created and every field value written. One-click rollback reverts the Dynamics 365 environment to its pre-migration state if reconciliation fails. After cutover, we deliver a migration summary report showing record counts, error rates, and any records that could not be migrated due to data quality issues.
Platform deep dives
Legal Files
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Sales
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 2 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Legal Files and Microsoft Dynamics 365 Sales .
Object compatibility
2 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
Legal Files: Not applicable — no public API exposed.
Data volume sensitivity
Legal Files doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during Legal Files to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.
Walk through your Legal Files to Microsoft Dynamics 365 Sales migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave Legal Files
Other ways to arrive at Microsoft Dynamics 365 Sales
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.