CRM migration
Field-level mapping, validation, and rollback between PANDA Perio and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .
PANDA Perio
Source
Microsoft Dynamics 365 Sales
Destination
Compatibility
12 of 12
objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .
Complexity
BStandard
Timeline
1–3 weeks
Overview
PANDA Perio stores periodontal charting records, patient demographics, treatment plans, clinical notes, and provider assignments in a dental-specific data model. Microsoft Dynamics 365 Sales uses the Dataverse-backed CRM schema with Accounts, Contacts, Leads, and Opportunities as core entities. This migration maps PANDA Perio patient records to Dynamics 365 Contacts with Account linkage, preserves treatment plan and clinical note history in custom fields, and maintains provider-to-owner relationships via email-based user resolution. The PANDA Perio REST API enables structured data extraction; Dynamics 365 Sales accepts data via the Web API or Bulk Import. Clinical periodontal findings that have no CRM equivalent are stored as custom fields or attachments. Workflows, automated letters, and perio-charting templates do not migrate — those require manual reconstruction in Dynamics 365 or Power Automate. FlitStack AI sequences the migration to preserve referential integrity: patients before accounts, accounts before contacts, contacts before opportunity linkages. Custom Dataverse tables are created for TreatmentPlan and PerioVisit entities to handle clinical data without native CRM equivalents, ensuring all critical patient information transfers to your Microsoft environment.
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
PANDA Perio platform overview
Scorecard, SWOT, gotchas, and pricing for PANDA Perio.
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 PANDA Perio 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.
PANDA Perio
Patient Record
Microsoft Dynamics 365 Sales
Contact
1:1PANDA Perio patient records map directly to Dynamics 365 Contacts. Patient demographics including name, date of birth, contact information, address, and phone numbers translate directly to Contact standard fields. Primary provider assignment resolves to Contact OwnerId via email match against Dynamics system users. Chart numbers and billing types from PANDA Perio migrate to custom fields on the Contact record for clinical reference and practice management integration.
PANDA Perio
Patient Record (business entity)
Microsoft Dynamics 365 Sales
Account
1:1When PANDA Perio stores referring dental practice or employer information, those entities map to Dynamics 365 Accounts. The referring practice name, address, and contact details populate Account standard fields. Personal patients map to Contacts without an Account link; business-referred patients create an Account record representing the referring practice with a lookup relationship from the patient Contact record.
PANDA Perio
Guarantor / Billing Contact
Microsoft Dynamics 365 Sales
Contact (parent relationship)
1:1PANDA Perio stores guarantor information per patient for billing responsibility tracking. The guarantor maps to the same Contact record structure, with a parent-contact relationship established in Dynamics 365 when multiple family members are migrated together. This preserves family billing hierarchies while maintaining individual Contact records for each family member.
PANDA Perio
Treatment Plan
Microsoft Dynamics 365 Sales
Custom Entity (TreatmentPlan)
1:1PANDA Perio treatment plans contain procedure codes, phases, clinical notes, and status tracking. Dynamics 365 has no native treatment plan entity. We create a custom TreatmentPlan table in Dataverse to store plan headers including plan number, date, status, and provider assignment. Procedure line items map as child records in a linked TreatmentPlanProcedure table with procedure codes, tooth-site references using universal numbering, and fee information.
PANDA Perio
Periodontal Charting Visit
Microsoft Dynamics 365 Sales
Custom Entity (PerioVisit)
1:1Each PANDA Perio visit containing periodontal charting (pocket depths, BOP, furcation, mobility) maps to a custom PerioVisit table linked to the Contact via a lookup relationship. Charting data for each tooth-site stores as JSON or delimited custom fields since Dynamics 365 does not support dental chart grid structures natively. Visit dates, provider assignments, and clinical findings are preserved for historical reference and treatment outcome tracking.
PANDA Perio
Progress Notes / SOAP Notes
Microsoft Dynamics 365 Sales
Annotation (Notes)
1:1PANDA Perio clinical progress notes and SOAP notes migrate to Dynamics 365 Annotations attached to the Contact record. Note dates become Annotation Subject lines for chronological organization, while note body content populates the Annotation Body field. Rich-text formatting is preserved where possible; complex formatting converts to plain text with HTML markup retained for readability and reference purposes.
PANDA Perio
Referral Letter Template
Microsoft Dynamics 365 Sales
Template (Word/Email) + Note
1:1PANDA Perio's dynamic letter templates with provider-specific phrasing and conditional logic cannot migrate directly to Dynamics 365. We export template definitions as reference documentation including field names, conditional logic patterns, provider signature blocks, and procedure code references. This documentation accelerates rebuilding via Dynamics 365 Word Templates or Power Automate. Existing sent letters are preserved as PDF attachments on the Contact record.
PANDA Perio
Clinical Workflow Manager flags
Microsoft Dynamics 365 Sales
Task + Custom field on Contact
1:1PANDA Perio chart flags including recare needed, treatment incomplete, and referral pending statuses map to Dynamics 365 Tasks with appropriate category and due date assignments. The original flag type is preserved in a custom Contact field (Workflow_Flag__c) for filtering, reporting, and bulk operations. Task subjects reference the flag type and patient name for clear identification in the Dynamics 365 timeline view.
PANDA Perio
Patient Attachments / X-rays
Microsoft Dynamics 365 Sales
SharePoint / Dataverse File Attachment
1:1PANDA Perio file attachments including images, X-rays, consent forms, and clinical photographs re-upload to Dynamics 365 SharePoint integration or Dataverse file columns attached to the Contact record. SharePoint document libraries provide scalable storage for large attachment volumes with folder structures mapped to match PANDA Perio organization. File size limits of 125 MB per file apply in Dataverse native storage; SharePoint integration bypasses this limitation for very large imaging files.
PANDA Perio
Provider / Doctor Record
Microsoft Dynamics 365 Sales
SystemUser (Owner resolution)
1:1PANDA Perio providers and doctor records resolve to Dynamics 365 system users via email address matching. This OwnerId assignment links patient records to their responsible provider in Dynamics 365. Unmatched providers are flagged in a resolution report for manual user creation or reassignment to a default provider Contact record. Proper owner resolution ensures record visibility, task assignment, and accountability tracking in Dynamics 365.
PANDA Perio
Appointment / Visit History
Microsoft Dynamics 365 Sales
Custom Entity (Appointment) + Activity
1:1PANDA Perio visit dates, providers, procedure codes, and visit types map to a custom Appointment entity linked to Contact. The custom entity stores structured visit metadata while maintaining relationship context. Visit-level activities including examinations, surgeries, and consultations also create Dynamics 365 Activity records for timeline visibility and workflow automation triggers. Historical appointments are preserved for recall reminders and treatment history review.
PANDA Perio
Insurance / Billing Information
Microsoft Dynamics 365 Sales
Custom Entity (InsuranceInfo) + Account
1:1PANDA Perio insurance carrier names, policy numbers, group numbers, and coverage details map to a custom InsuranceInfo table linked to Contact. Insurance company names create or link to Account records for carrier reporting and communication tracking. The custom entity stores complete policy details while the Account link provides carrier-level aggregation for claims reporting, coverage analysis, and provider network verification within Dynamics 365.
| PANDA Perio | Microsoft Dynamics 365 Sales | Compatibility | |
|---|---|---|---|
| Patient Record | Contact1:1 | Fully supported | |
| Patient Record (business entity) | Account1:1 | Fully supported | |
| Guarantor / Billing Contact | Contact (parent relationship)1:1 | Fully supported | |
| Treatment Plan | Custom Entity (TreatmentPlan)1:1 | Fully supported | |
| Periodontal Charting Visit | Custom Entity (PerioVisit)1:1 | Fully supported | |
| Progress Notes / SOAP Notes | Annotation (Notes)1:1 | Fully supported | |
| Referral Letter Template | Template (Word/Email) + Note1:1 | Fully supported | |
| Clinical Workflow Manager flags | Task + Custom field on Contact1:1 | Fully supported | |
| Patient Attachments / X-rays | SharePoint / Dataverse File Attachment1:1 | Fully supported | |
| Provider / Doctor Record | SystemUser (Owner resolution)1:1 | Fully supported | |
| Appointment / Visit History | Custom Entity (Appointment) + Activity1:1 | Fully supported | |
| Insurance / Billing Information | Custom Entity (InsuranceInfo) + Account1: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.
PANDA Perio gotchas
No public API — database extraction requires SQL Server access
SQL Server Express 10GB limit can be migration-blocking
Open Dental bridge passes IDs only, not clinical data
Treatment plan PMS codes differ from clinical letter descriptions
Custom periodontal findings are practice-specific
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
Discover PANDA Perio data structure and licensing tier
We extract PANDA Perio data via the REST API using provided credentials, identifying patient count, custom field inventory, treatment plan volume, and attachment file sizes. We simultaneously assess your Dynamics 365 Sales licensing tier (Professional vs. Enterprise) to confirm custom table capacity. The discovery output includes a record-count matrix by entity type and a custom field inventory spreadsheet for your review before field mapping begins.
Design Dataverse custom tables and column schema
For practices with periodontal charting, treatment plans, or insurance data, we design custom Dataverse tables (TreatmentPlan__c, PerioVisit__c, InsuranceInfo__c) before data lands. This includes field naming, data type selection (text, datetime, picklist, JSON), and relationship definitions between custom tables and the Contact record. Your Dynamics admin approves the schema; we publish custom tables to your sandbox environment for validation before production migration.
Resolve providers to Dynamics users and flag unlinked records
PANDA Perio provider records are matched against Dynamics 365 system users by email address. Unmatched providers are listed in a resolution report with the provider name, role, and any contact information from PANDA Perio. Your team creates Dynamics users for each unmatched provider or designates a fallback owner. No patient records migrate without a confirmed owner assignment — this prevents Dynamics validation errors at load time.
Run sample migration with field-level diff
A representative slice of 100–500 patient records migrates to your Dynamics 365 sandbox, including patients with treatment plans, perio visits, progress notes, and attachments. We generate a field-level diff comparing source values against Dynamics field values so you can verify name formatting, date preservation, provider ownership, and custom field population. Sample results are reviewed with your team before the full migration is scheduled.
Execute full migration with delta-pickup window
The full migration loads to Dynamics 365 Production. A delta-pickup window (24–48 hours after migration start) captures any PANDA Perio records modified during the cutover period — new appointments, updated treatment plans, or modified patient information. All operations are logged to an audit trail. If reconciliation identifies missing or misaligned records, one-click rollback reverts the Dynamics environment to pre-migration state while we investigate and re-run.
Platform deep dives
PANDA Perio
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Sales
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. All 8 core objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across PANDA Perio and Microsoft Dynamics 365 Sales .
Object compatibility
All 8 core objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .
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
PANDA Perio: Not publicly documented.
Data volume sensitivity
PANDA Perio 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 PANDA Perio to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.
Walk through your PANDA Perio 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 PANDA Perio
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.