CRM migration

Migrate from MyCase to Microsoft Dynamics 365 Sales

Field-level mapping, validation, and rollback between MyCase and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .

MyCase logo

MyCase

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

12 of 12

objects map 1:1 between MyCase and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

2–4 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

MyCase stores law-firm data across contacts, client companies, case matters, time entries, invoices, documents, and custom fields — organized around legal workflow and billing cycles. Dynamics 365 Sales stores commercial CRM data across Account, Contact, Lead, and Opportunity tables built on Microsoft Dataverse, with Activity and Note entities for history. The structural gap between a practice-management system and a sales CRM means every migration requires deliberate design decisions rather than one-to-one field matching. We extract MyCase data via the Full Data Backup tool and CSV exports, resolve attorney and staff records to Dynamics 365 Sales users by email match, then migrate contacts and companies first to satisfy AccountId lookups before loading matters as Opportunities. Billing data — time entries and invoices — has no native Dynamics 365 Sales equivalent and is preserved as custom fields or handled via Dynamics 365 Business Central integration. MyCase workflows, templates, and automation rules do not migrate; we deliver a rebuild reference document and exported template assets so your team can reconstruct them in Dynamics 365 Sales and Power Automate. Our API pipeline respects MyCase's 25 requests-per-second limit and Dynamics 365's Dataverse service protection limits to avoid throttling. A delta-pickup window of 24–48 hours during cutover captures any matter or contact changes made during the final migration pass.

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

MyCase logo

MyCase

What's pushing teams away

  • QuickBooks integration syncs one direction only—deleting a transaction in MyCase does not remove it in QuickBooks, and the sync can get stuck, forcing manual reconciliation that solo practitioners find disruptive.
  • Users report missing billing features that mid-size firms require: inability to bulk-update rates on past time entries, limited flat-fee case management, and manual invoice adjustments across multiple sections.
  • UI changes between releases (especially around notifications and client message navigation) create friction for staff trained on earlier layouts, per Capterra and G2 reviews.
  • Advanced features including the open API are gated behind the $109/user/month Advanced tier, so growing firms hit feature ceilings on lower plans and face a pricing cliff.
  • Firms outgrowing the platform report that Clio's integration marketplace and enterprise features better support scaling case volume, which drives switchers toward larger legal CRMs.

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 MyCase objects map to Microsoft Dynamics 365 Sales

Each row shows how a MyCase 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.

MyCase

Contact

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

MyCase contacts (individuals at client firms) map directly to Dynamics 365 Sales Contact records. Each contact requires an AccountId lookup — the client company must be migrated first so the AccountId foreign key resolves at insert time. We also preserve the original MyCase contact ID in a custom Source_System_ID__c field for subsequent reconciliation.

MyCase

Client Company

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

MyCase company records (the client organization) map to Dynamics 365 Sales Account. Billing address, industry, and number of employees transfer as direct fields. Parent-company hierarchies in MyCase map to Account.ParentAccountId. We retain the original MyCase company identifier in new_companyid for traceability and delta re-sync.

MyCase

Case / Matter

maps to

Microsoft Dynamics 365 Sales

Opportunity

1:1
Fully supported

MyCase matters carry legal context — practice area, billing type, court information — that has no direct Dynamics 365 Sales equivalent. We map the matter name to Opportunity.Name, estimated value to Amount, and stage to a legal-specific opportunity stage value-map. Legal context fields become custom columns on the Opportunity table.

MyCase

Time Entry

maps to

Microsoft Dynamics 365 Sales

Custom Columns on Opportunity / Activity

1:1
Fully supported

MyCase time entries (attorney hours, rates, task descriptions) cannot be stored as native Dynamics 365 Sales activities because the platform lacks a billing engine. We create custom decimal and text columns on the Opportunity to hold total billed hours, blended rate, and a JSON-encoded time-entry log for audit purposes.

MyCase

Invoice

maps to

Microsoft Dynamics 365 Sales

Custom Column + Reference Note

1:1
Fully supported

MyCase invoices and outstanding balances have no Dynamics 365 Sales counterpart. We preserve invoice status, outstanding amount, and last-invoice date as custom fields on the Opportunity or Account. Firms that need billing continuity route this data to Dynamics 365 Business Central separately.

MyCase

Custom Field (Case)

maps to

Microsoft Dynamics 365 Sales

Custom Column on Opportunity

1:1
Fully supported

MyCase Advanced-tier custom fields on matters require new_ prefixed columns on the Opportunity table in Dynamics 365 Dataverse. Pick-list fields undergo value-by-value mapping; text fields map directly. We create the columns during the pre-migration schema build and validate with a sample run.

MyCase

Custom Field (Contact)

maps to

Microsoft Dynamics 365 Sales

Custom Column on Contact

1:1
Fully supported

MyCase custom properties on contacts — intake sources, referral channels, billing contact flags — become new_ prefixed custom columns on the Contact table. We extract the full custom-field schema from MyCase during discovery and pre-create every target column in Dataverse.

MyCase

Document / File Attachment

maps to

Microsoft Dynamics 365 Sales

SharePoint / OneDrive for Business (via Dataverse)

1:1
Fully supported

MyCase documents attached to matters are downloaded and re-uploaded to the SharePoint or OneDrive location that Dataverse manages for the Account or Opportunity. We preserve the original folder path hierarchy and file names. Inline images in notes are downloaded and rehosted in the Dynamics 365 document storage.

MyCase

Calendar Event / Task

maps to

Microsoft Dynamics 365 Sales

Task / Appointment

1:1
Fully supported

MyCase calendar events (court dates, depositions, deadlines) and tasks map to Dynamics 365 Sales Task and Appointment entities. Original start/end times, assigned attorney or staff user, and parent record links are preserved. Task priority and status map value-by-value. We also keep the MyCase event ID in new_eventid for future reference and audit trails.

MyCase

Attorney / Staff User

maps to

Microsoft Dynamics 365 Sales

SystemUser

1:1
Fully supported

MyCase users (attorneys, paralegals, staff) are resolved against Dynamics 365 Sales SystemUser records by email address match. Unmatched users are flagged before migration so the firm can invite them to Dynamics 365 or assign a fallback owner before records land.

MyCase

Workflow / Automation (MyCase)

maps to

Microsoft Dynamics 365 Sales

Not migratable

1:1
Fully supported

MyCase workflow tasks, automated deadline triggers, and intake form logic have no Dynamics 365 Sales equivalent. We export workflow definitions as a structured reference document and deliver template assets so your Dynamics admin can rebuild them in Power Automate and Dynamics 365 Sales automated flows.

MyCase

Document Template / Mail Merge

maps to

Microsoft Dynamics 365 Sales

Not migratable

1:1
Fully supported

MyCase Advanced Document Automation templates and clause library are Word-based assets tied to MyCase's ADA add-in. We export the template files and field-mapping documents so they can be uploaded to Dynamics 365 Sales document templates or Power Automate document-generation flows.

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.

MyCase logo

MyCase gotchas

High

QuickBooks sync is strictly one-directional

High

Advanced API access is tier-gated

Medium

Document migration requires offline file transfer

Medium

Bulk rate updates on historical time entries are not supported

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

  • Billing data has no native Dynamics 365 Sales home

    MyCase time entries, invoices, IOLTA trust balances, and flat-fee billing records are core legal data with no direct equivalent in Dynamics 365 Sales. The platform lacks a native billing engine — invoices and payment tracking require Dynamics 365 Business Central or a third-party legal billing add-on. We preserve outstanding balances, last invoice dates, and total billed hours as custom fields on the Opportunity, but the financial workflow must be rebuilt outside the CRM. Firms that rely heavily on MyCase billing should scope Business Central integration before committing to a cutover date.

  • MyCase custom fields require Dataverse column pre-creation

    MyCase Advanced tier exposes custom fields on contacts, companies, and cases via API, but each field must be explicitly created as a new_ prefixed column in Dynamics 365 Dataverse before migration runs. Dynamics 365 Sales Professional caps custom tables at 15, while Sales Enterprise allows unlimited custom columns. Firms on the Professional tier who exceed the table limit will need an Enterprise upgrade or a selective custom-field audit before migration. We deliver the full custom-field manifest and Dataverse schema plan as part of the pre-migration discovery phase so there are no surprises at insert time.

  • MyCase API rate limit constrains export throughput

    MyCase's REST API enforces a 25 requests-per-second rate limit per client, which governs how quickly we can pull records during extraction. Large document-heavy firms will see longer export windows because each file attachment requires a separate API call. We batch and pace requests to remain under the limit, but the cumulative effect on firms with 100,000+ documents can extend the extraction phase by 2–4 days beyond initial estimates. We surface this in the discovery report and plan the extraction window accordingly.

  • Dynamics 365 Dataverse service protection limits apply to insert operations

    Dynamics 365 Sales runs on Microsoft Dataverse, which enforces service protection limits — approximately 6,000 Dataverse API requests per five-minute window per user, with a concurrency limit of 52 concurrent calls per organization. Our migration pipeline distributes load across retry-safe batch operations to avoid throttling. However, configurations with very high custom-column counts per record can cause individual record inserts to exceed the execution-time threshold. We run a pre-migration load test against a sandbox environment to calibrate the optimal batch size before the production migration window opens.

  • QuickBooks sync relationships do not carry forward

    MyCase integrates bidirectionally with QuickBooks for accounting reconciliation — invoices created in MyCase sync back to QuickBooks and voiding a transaction in MyCase removes it from QuickBooks. Dynamics 365 Sales has no native QuickBooks connector without a third-party integration tool such as SyncApps or a custom Power Automate flow. Firms that depend on the MyCase–QuickBooks link for accounts receivable management will need to rebuild that integration path, either through a dedicated connector or by routing billing to Dynamics 365 Business Central. We document the current sync scope and flag the integration gap in the pre-migration report.

Migration approach

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

  1. Extract MyCase data and audit schema

    FlitStack AI uses MyCase's Full Data Backup tool and contact/case CSV exports to pull all standard objects, custom field definitions, and attachment metadata. We audit the schema against the MyCase API to capture every Advanced-tier custom property and document link. The result is a schema manifest that lists every source field, its type, and its target Dynamics 365 Dataverse column — including the new_ prefix convention and pick-list value maps. This manifest drives the Dataverse column pre-creation step.

  2. Build Dynamics 365 Dataverse schema

    Before any data moves, we create every required custom column in Dataverse — custom pick-lists for practice areas and case types, text fields for attorney IDs and billing metadata, and datetime fields for original create dates. For firms on Dynamics 365 Sales Professional, we audit the custom-column count against the 15-table cap and flag any that need an Enterprise license upgrade. This step also includes mapping MyCase opportunity stage values to Dynamics 365 Sales process stage names so the pipeline view renders correctly after migration.

  3. Resolve users and owners by email

    MyCase attorneys, paralegals, and staff are matched to Dynamics 365 Sales SystemUser records by email address lookup. Unmatched users are flagged with a pre-migration exception report so the firm can invite them to Dynamics 365 or assign a fallback owner before records are inserted. No contact, company, or opportunity lands in Dynamics without a valid OwnerId — this prevents orphaned records that would break reporting continuity.

  4. Migrate accounts and contacts first

    Dynamics 365 Sales requires AccountId on Contact records before Contacts can be saved. We sequence the migration as Accounts → Contacts → Opportunities so foreign-key lookups resolve correctly. MyCase client companies land as Accounts, MyCase contacts land as Contacts with their ParentCustomerId pointing to the correct Account, and the mycase_user_id is preserved as Source_System_ID__c on each record for traceability. All foreign keys are validated in Dataverse before insert to prevent orphaned records.

  5. Run sample migration with field-level diff

    A representative slice — typically 200–500 records spanning contacts, companies, matters, and a few time entries — migrates to a Dynamics 365 sandbox first. We generate a field-level diff comparing source values against destination values for every mapped column, including custom fields and the billing metadata preserved in Opportunity new_ fields. You verify that practice-area pick-lists, billing types, and custom matter properties render correctly before we commit to the full run.

  6. Execute full migration with delta-pickup cutover

    The full migration commits records in the sequenced order — Accounts, Contacts, Opportunities with custom billing columns, then Activities and Documents. A 24–48 hour delta-pickup window runs after the initial pass to capture any matter updates or new contacts created in MyCase during the cutover. All operations are logged in an audit trail. If reconciliation reveals missing or mismatched records, one-click rollback reverts the Dynamics 365 environment to its pre-migration state while we re-run the affected batches.

Platform deep dives

Context on both ends of the pair

MyCase logo

MyCase

Source

Strengths

  • All-in-one practice management combines case files, client comms, billing, and docs in a single platform.
  • Client portal with secure document sharing reduces reliance on third-party file-sharing tools.
  • Built-in texting and e-signature are included at all tiers, avoiding per-transaction fees.
  • Workflow automation auto-generates tasks and calendared deadlines on new case creation.
  • AffiniPay parentage ties payments tightly to practice management through LawPay integration.

Weaknesses

  • Open API and advanced document management require the Advanced tier at $109/user/month.
  • One-way QuickBooks sync means billing deletions in MyCase must be manually voided in QuickBooks.
  • Cannot bulk-update rates on past time entries—each record requires individual editing.
  • UI changes between releases have caused navigation friction, especially around notifications.
  • Document automation templates are tied to the original creator's machine and cannot be exported.
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. 1 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 MyCase and Microsoft Dynamics 365 Sales .

  • Object compatibility

    B

    1 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

    MyCase: 25 requests per second per client.

  • Data volume sensitivity

    B

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

Estimator

Estimate your MyCase 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 MyCase to Microsoft Dynamics 365 Sales data migrations

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

Can't find your answer?

Walk through your MyCase to Microsoft Dynamics 365 Sales migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Small firm migrations with under 5,000 records and under 10 custom fields typically complete in 2–4 weeks of clock time — discovery and schema build in the first week, sample migration and full run in weeks two and three. Larger firms with 50,000+ matters, document-heavy archives, or 20+ custom fields on cases extend to 6–10 weeks. The delta-pickup window adds 24–48 hours at the end regardless of size. MyCase API rate limiting (25 requests per second) and Dataverse service protection limits are the primary technical constraints that govern throughput during extraction and insert phases.

Adjacent paths

Related migrations to explore

Ready when you are

Move from MyCase.
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