CRM migration

Migrate from Legal Files to Microsoft Dynamics 365 Sales

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 logo

Legal Files

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

12 of 12

objects map 1:1 between Legal Files and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

48–72 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Legal Files logo

Legal Files

What's pushing teams away

  • Reviewer feedback consistently flags the UI as 'outdated' and notes the platform 'may work better with Windows than Mac' — modern Mac-first in-house teams find this friction-heavy.
  • Initial learning curve is described as tricky; onboarding new users takes more time than reviewers expect from a 2020s SaaS product.
  • Enterprise pricing model ($100/user/month + $49/month base fee, billed annually) becomes expensive at scale and lacks transparent lower tiers for smaller teams.
  • Modern integration ecosystem is narrower than newer competitors — packaged connectors to popular SaaS tools are limited compared to native cloud-first platforms.
  • Primary value proposition skews to centralized matter management rather than collaborative or AI-driven workflows, so teams chasing AI demand drafting or generative review features migrate away.

Choosing

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

What's pulling them in

  • Deep Microsoft 365, Teams, and Outlook integration makes Microsoft Dynamics 365 Sales a natural fit for Microsoft-first organizations already invested in that ecosystem
  • Sales Enterprise and Premium tiers offer unlimited custom tables and advanced AI-driven forecasting and predictive analytics not available in lower tiers
  • Professional tier pricing at $65 per user per month offers a lower entry cost than Salesforce for SMB teams with straightforward CRM needs
  • Flexible customization options allow businesses to build bespoke apps, tailor forms and views, and integrate with other Dynamics 365 modules
  • Microsoft Copilot AI tools are embedded directly into the sales workflow on Enterprise and Premium, automating routine tasks and providing deal intelligence

Object mapping

How Legal Files objects map to Microsoft Dynamics 365 Sales

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

maps to

Microsoft Dynamics 365 Sales

Case

1:1
Fully supported

Legal 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

maps to

Microsoft Dynamics 365 Sales

Custom Matter Table (Dataverse)

1:1
Fully supported

If 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)

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

Legal 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)

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

Legal 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)

maps to

Microsoft Dynamics 365 Sales

Custom Party Role Field

1:1
Fully supported

Legal 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

maps to

Microsoft Dynamics 365 Sales

SharePoint Document (via Dynamics 365)

1:1
Fully supported

Legal 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)

maps to

Microsoft Dynamics 365 Sales

Email (Activity) attached to Case

1:1
Fully supported

Legal 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

maps to

Microsoft Dynamics 365 Sales

Task (or custom Deadline entity)

1:1
Fully supported

Legal 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

maps to

Microsoft Dynamics 365 Sales

Custom Billing Fields or Dynamics 365 Finance

1:1
Fully supported

Legal 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)

maps to

Microsoft Dynamics 365 Sales

Custom Fields on Case or Matter Table

1:1
Fully supported

Legal 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

maps to

Microsoft Dynamics 365 Sales

SystemUser

1:1
Fully supported

Legal 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)

maps to

Microsoft Dynamics 365 Sales

SharePoint via Dynamics 365

1:1
Fully supported

Non-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.

Gotchas + challenges

What specifically takes care here

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 logo

Legal Files gotchas

High

No API — migration requires direct SQL Server database access

High

Document file transfer is separate from database migration

Medium

Email routing rules do not auto-migrate

Medium

Custom field discovery requires schema inspection

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales gotchas

High

Professional tier 15-table custom table limit blocks migrations

High

October 2024 pricing increase applies at renewal for all customers

Medium

Custom fields must be created in the UI before API writes

Medium

Power Platform request limits apply to bulk migrations

Medium

Activity records orphaned to inactive owners fail silently

Pair-specific challenges

  • Matter-to-Case 1:1 mapping creates a schema design decision before migration

    Legal Files matters are the top-level record in a legal case management system, but Dynamics 365 Cases are primarily designed for customer service issue tracking. Firms with high-volume litigation or matters spanning multiple parties and documents may need a custom Matter table in Dataverse rather than relying on the standard Case entity. If you use the standard Case entity, fields like statute of limitations, opposing counsel, and litigation phase have nowhere native to live and must become custom fields — which requires the migration to know which fields exist before the schema is finalized. We deliver a schema design document before data lands so the Dynamics 365 admin can pre-create custom fields and add them to forms.

  • Document migration requires SharePoint licensing and folder structure planning

    Legal Files stores documents in a native file management system tied to each matter. Dynamics 365 does not have native document storage — it relies on SharePoint Online integration via the Document Management settings. Firms without existing SharePoint licensing will need to add it, and the SharePoint folder hierarchy must be planned to match Legal Files' matter/subject structure. Large document sets (hundreds of files per matter) also risk hitting SharePoint batch upload limits and storage quotas. We assess SharePoint readiness during the migration audit, configure the SharePoint-to-Case document location mapping, and handle the re-upload with original file metadata preserved. File version history in Legal Files does not migrate automatically.

  • Legal Files workflows and automated reminders do not transfer

    Legal Files supports matter-specific workflow automation including deadline reminders, status change notifications, and task generation rules. Dynamics 365 Sales has no built-in legal workflow engine. Power Automate can replicate some automation logic, but Legal Files' rule-based workflow definitions must be manually rebuilt from scratch. We export a detailed workflow inventory from Legal Files (as a structured reference document) to help the firm's Power Platform admin or consultant rebuild the automations in Power Automate. The rebuild work is out of scope for the data migration engagement.

  • Billing and time tracking data requires a destination decision

    Legal Files includes time entry and billing tracking as part of its matter management functionality. Dynamics 365 Sales does not include billing or time tracking natively. Firms have two paths: create a custom TimeEntry table in Dataverse (linked to Cases) to preserve historical billing records for reporting, or route time entries to Dynamics 365 Finance and Operations or Business Central if the firm already runs those ERP modules. We cannot automatically decide which path is correct — it depends on whether the firm uses Dynamics 365 for invoicing. We migrate time entry data to a staging table and flag this decision for the firm before the full migration runs.

  • Party roles per matter require a custom junction entity

    Legal Files captures party roles that are specific to each matter — the same contact can be opposing counsel on one matter and expert witness on another. Dynamics 365 Contact records do not store matter-specific role designations. The standard Contact-to-Case relationship has no role field. We address this by creating a custom PartyInMatter junction entity that links Contacts to Cases with a new_PartyRole picklist field. This is a schema extension that requires a Power Platform admin or consultant to configure before migration data loads. Without this, party role information is lost or flattened to a generic contact note.

Migration approach

Six steps for a successful Legal Files to Microsoft Dynamics 365 Sales data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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

Context on both ends of the pair

Legal Files logo

Legal Files

Source

Strengths

  • Fully on-premise with data stored directly in Microsoft SQL Server, giving firms complete control over their database
  • Highly customizable by firm administrators without requiring developer assistance
  • Direct Microsoft Outlook email saving into case files is a workflow feature praised across reviews
  • iPad app available for attorneys working outside the office
  • Supports complex litigation case structures with deep matter hierarchies

Weaknesses

  • No public REST API — all data access requires direct SQL Server database queries
  • Desktop-first architecture means no native cloud sync or SaaS deployment model
  • Limited modern integrations compared to cloud-first competitors like Clio
  • Legacy UI is cited less favorably than newer alternatives on modern review platforms
  • Pricing is opaque and requires direct vendor contact, suggesting enterprise-level cost
Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

Destination

Strengths

  • Native integration with Microsoft 365, Teams, Outlook, and SharePoint for unified productivity workflow
  • Unlimited custom tables and complex workflows on Enterprise tier enable deep customization for complex sales processes
  • AI-driven predictive analytics and deal intelligence on Enterprise and Premium tiers help sales teams prioritize pipeline
  • Dataverse unified data layer provides a consistent API and data model across all Dynamics 365 and Power Platform apps
  • Strong security model with Field-Level Security and Record Ownership rules for governance-conscious enterprises

Weaknesses

  • Sales Professional tier caps custom tables at 15, creating a migration ceiling for highly customized SMB environments
  • October 2024 pricing increases of $15 per user across all tiers apply to existing customers upon renewal
  • Implementation typically requires costly certified partners, adding 30–50% to total project cost
  • Updates and platform releases can disrupt customizations and plugins, requiring regression testing after each wave
  • Non-Microsoft integrations require additional configuration or middleware, limiting flexibility for heterogeneous tech stacks

Complexity grading

How hard is this migration?

Standard CRM migration. 2 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Legal Files and Microsoft Dynamics 365 Sales .

  • Object compatibility

    B

    2 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Legal Files: Not applicable — no public API exposed.

  • Data volume sensitivity

    B

    Legal Files doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Legal Files to Microsoft Dynamics 365 Sales migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Legal Files to Microsoft Dynamics 365 Sales data migrations

Answers to the questions buyers ask most during Legal Files to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Most Legal Files to Dynamics 365 Sales migrations complete in 48–72 hours for under 25,000 matters. Firms with over 100,000 records, extensive custom field sets, or large document repositories requiring SharePoint re-hosting extend to 5–10 days. The longest planning step is designing the custom Matter table or PartyInMatter junction entity if your matters have legal-specific fields that don't fit the standard Case entity — this schema work should be done before data lands. SharePoint configuration and licensing can add another 1–2 weeks if not already in place.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Legal Files.
Land in Microsoft Dynamics 365 Sales , intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day