CRM migration
Field-level mapping, validation, and rollback between Payaca and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .
Payaca
Source
Microsoft Dynamics 365 Sales
Destination
Compatibility
4 of 8
objects map 1:1 between Payaca and Microsoft Dynamics 365 Sales .
Complexity
BStandard
Timeline
4-6 weeks
Overview
Payaca structures its data around Projects linked to Customers in a vertical-specific lifecycle model, while Microsoft Microsoft Dynamics 365 Sales uses the standard CRM triad of Account, Contact, Lead, and Opportunity. Each Payaca Project must be decomposed and mapped to a Dynamics Opportunity with the linked Customer becoming an Account-Contact pair. Payaca's native CSV export captures only contact fields; project records, invoices, and custom field data require API queries, which we execute during scoping to build a complete migration dataset. Payaca's fixed pipeline stages (Lead, Survey, Quote, Install, Complete) map to a custom Sales Process in Dynamics that we configure before migration. We preserve custom fields tracking compliance, permits, and AHJ requirements as custom Opportunity fields. Service reminders and document references transfer as Notes and SharePoint location records. Workflows, automation rules, and the customer portal do not migrate; we deliver a written inventory of these configurations for your Dynamics admin to rebuild post-migration.
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
Payaca platform overview
Scorecard, SWOT, gotchas, and pricing for Payaca.
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 Payaca 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.
Payaca
Customer
Microsoft Dynamics 365 Sales
Account + Contact
1:manyPayaca Customers map to a Dynamics 365 Account with a primary Contact record. The Account holds company-level information (name, address, site location) while the Contact holds the individual contact details. We extract all contact fields from Payaca's CSV export and enrich with any additional contact data from API queries. Multiple Payaca Customers with the same company name are reviewed for deduplication before Account creation.
Payaca
Project
Microsoft Dynamics 365 Sales
Opportunity
1:1Payaca Projects are the central migration object, mapping to Dynamics 365 Opportunities. Each Project's linked Customer becomes the parent Account (via AccountId on Opportunity). The Payaca project stage (Lead, Survey, Quote, Install, Complete) maps to a custom Sales Process that we configure in Dynamics before migration, preserving the original stage values as StageName entries with matching probability percentages.
Payaca
Pipeline Stage
Microsoft Dynamics 365 Sales
Sales Process + Stage
lossyPayaca's five fixed stages (Lead, Survey, Quote, Install, Complete) become a custom Dynamics Sales Process. We create StageName entries matching Payaca's stage labels and assign probability percentages. The Sales Process is associated with a Record Type that we create for clean tech installation projects so that stage values remain scoped to this workflow.
Payaca
Item
Microsoft Dynamics 365 Sales
Product2 + PricebookEntry
1:1Payaca Items (panel configurations, battery sizes, labor rates, equipment SKUs) map to Dynamics Product2 records. Standard Pricebook entries are created during import so that Products can be added to Opportunities. ProductCode maps from Payaca SKU data. Custom pricing per project that deviates from standard rates is preserved as Opportunity Line Item overrides.
Payaca
Invoice
Microsoft Dynamics 365 Sales
Opportunity (custom invoice fields) + Note
1:manyPayaca Invoices are linked to Projects and carry line items, payment status, and Stripe transaction references. We map invoice status as custom Opportunity fields (invoice_sent_date, invoice_paid_date, stripe_transaction_id) and attach the invoice PDF as a SharePoint document location reference via Note. Full invoice PDF binaries are delivered as file attachments where Payaca provides download access.
Payaca
Custom Field
Microsoft Dynamics 365 Sales
Custom Opportunity Field
lossyPayaca custom fields tracking compliance documentation, permit numbers, AHJ (Authority Having Jurisdiction) requirements, and inspection results map to custom fields on the Dynamics Opportunity object. We preserve field type information (text, date, dropdown) and populate values during the Project-to-Opportunity migration. Customers should review whether all custom fields remain relevant in Dynamics before migration scope is finalized.
Payaca
Document
Microsoft Dynamics 365 Sales
SharePoint Document Location + Note
1:1Payaca documents attach to Projects and Customers. We migrate document references as SharePoint Document Location records linked to the parent Dynamics Account or Opportunity. The actual document binaries are downloaded from Payaca via API where accessible and uploaded to the associated SharePoint document library. We flag documents that require manual re-upload from local sources if Payaca's API does not support binary download.
Payaca
Service Reminder
Microsoft Dynamics 365 Sales
Task
1:1Payaca Service Reminders associated with Customers or Projects map to Dynamics Task records. The reminder subject, description, and scheduled date migrate as Task Subject, Description, and ActivityDate. Tasks are linked to the parent Account or Opportunity via WhatId. Completed versus pending status is preserved as Task Status (Completed or Not Started).
| Payaca | Microsoft Dynamics 365 Sales | Compatibility | |
|---|---|---|---|
| Customer | Account + Contact1:many | Fully supported | |
| Project | Opportunity1:1 | Fully supported | |
| Pipeline Stage | Sales Process + Stagelossy | Fully supported | |
| Item | Product2 + PricebookEntry1:1 | Fully supported | |
| Invoice | Opportunity (custom invoice fields) + Note1:many | Fully supported | |
| Custom Field | Custom Opportunity Fieldlossy | Fully supported | |
| Document | SharePoint Document Location + Note1:1 | Fully supported | |
| Service Reminder | Task1: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.
Payaca gotchas
CSV export only captures customer contact records
Project imports require pre-existing customer IDs
Automation rule portability is limited to templates
Stripe transaction fees are external to Payaca billing
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
Discovery and data audit
We extract Payaca customer contacts from the native CSV export and run API queries against projects, invoices, items, documents, custom field definitions, and service reminders. We capture pipeline stage values, active automation rule templates, and integration configuration references (QuickBooks, Xero, Stripe, OpenSolar). The discovery output is a written data inventory, a record count per object, and a Payaca-specific extraction plan that accounts for the CSV-plus-API extraction model.
Dynamics schema design
We design the destination Microsoft Dynamics 365 Sales schema in a Sandbox org. This includes provisioning the Account and Contact fields, creating a custom Opportunity Record Type and Sales Process for clean tech installations (with stage names matching Payaca's Lead, Survey, Quote, Install, Complete labels), creating custom fields for invoice status and Stripe transaction IDs, and creating custom fields for compliance and AHJ data extracted from Payaca custom fields. SharePoint document libraries are provisioned for attachment migration. Schema is validated in Sandbox before production migration begins.
Sandbox migration and reconciliation
We run a full migration into the Sandbox using production-like data volume. The customer's operations lead reconciles record counts (Accounts, Contacts, Opportunities), spot-checks 25-50 records against the Payaca source, and reviews the Sales Process stage mapping. Custom field values are validated for completeness. The customer signs off on the sandbox migration before production cutover is scheduled.
Stripe and integration record extraction
We coordinate a Stripe API export in parallel with the Payaca migration. This captures historical transaction IDs, amounts, dates, and customer references. The Stripe export is merged into the migration dataset to populate stripe_transaction_id on invoice records. QuickBooks and Xero integration configuration is captured as a written reference document; API credentials and OAuth tokens cannot be transferred and require re-authentication in the new system.
Production migration in dependency order
We run production migration in this sequence: Accounts (from Payaca Customers), Contacts (linked to Accounts), Products and Pricebook entries (from Payaca Items), Opportunities (with AccountId, Pricebook2Id, and custom stage process assigned), Opportunity Line Items (with Product2Id and PricebookEntryId resolved), Invoice custom fields (with Stripe transaction IDs merged), Tasks (service reminders), and SharePoint document references. Each phase emits a row-count reconciliation report. We use Dynamics Data Import or the Dataverse API with batch chunking and backoff on rate-limit responses.
Cutover, validation, and automation rebuild handoff
We freeze Payaca writes during cutover, run a final delta migration of any records modified during the migration window, then enable Microsoft Dynamics 365 Sales as the system of record. We deliver the automation rule inventory document and integration reconfiguration checklist to the customer's admin team. We support a one-week hypercare window for reconciliation issues. We do not rebuild Payaca automations as Power Automate flows or Sales Insight rules inside the migration scope; that is a separate engagement.
Platform deep dives
Payaca
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Sales
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 1 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 Payaca and Microsoft Dynamics 365 Sales .
Object compatibility
1 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
Payaca: Not publicly documented in available help resources.
Data volume sensitivity
Payaca 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 Payaca to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.
Walk through your Payaca 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 Payaca
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.