CRM migration

Migrate from Amwork to Microsoft Dynamics 365 Sales

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

Amwork logo

Amwork

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

70%

7 of 10

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

Complexity

CModerate

Timeline

2-4 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Amwork to Microsoft Microsoft Dynamics 365 Sales is a structural migration, not a record copy. Amwork consolidates prospects and customers into a single Contact object with a lifecycle stage property; Microsoft Dynamics 365 Sales separates unqualified prospects into Leads and qualified contacts into Contacts attached to Accounts. We define the split rule during scoping based on your Amwork lifecycle stage matrix, create the matching Lead qualification criteria in D365, and preserve the original lifecycle stage as a custom field for audit. Amwork Deals-in-pipelines map to D365 Opportunities with pipeline stages translated to D365 Sales Process stage values. Custom fields migrate as D365 custom attributes; time entries attached to tasks become Notes on the parent record. Amwork BPMN automation rules do not migrate; we deliver a written inventory of every rule requiring rebuild in D365 Power Automate or Dynamics workflows.

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

Amwork logo

Amwork

What's pushing teams away

  • The import process fails when the uploaded spreadsheet does not match Amwork's expected field structure exactly, causing leads and contacts to drop silently during migration.
  • The sidebar lacks an expanded view mode, forcing users to hover repeatedly to see context, which creates friction during high-volume data entry sessions.
  • Drag-and-drop between deal pipeline stages is not supported — moving a record between stages requires opening a menu and selecting the destination, slowing down pipeline management.
  • Support is directed to WhatsApp rather than a built-in chat widget, which frustrates users expecting in-app ticket-based support for critical issues.

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

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

Amwork

Contact

maps to

Microsoft Dynamics 365 Sales

Lead or Contact (split required)

1:many
Fully supported

Amwork Contacts with lifecycle stage of lead, prospect, or unqualified map to Microsoft Dynamics 365 Sales Lead. Lifecycle stage of customer, active client, or evangelist map to D365 Contact tied to an Account. We compute the split at migration time using Amwork's lifecycle_stage property, and preserve the original value in a custom field amwork_original_lifecycle__c on both Lead and Contact for audit. If Amwork lifecycle stages do not cleanly distinguish qualification, we use the has_linked_company flag as a secondary signal: contacts with a linked company map to Contact, those without map to Lead.

Amwork

Company

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

Amwork Company records map directly to D365 Account. The Amwork company domain or website field becomes the Account's Website attribute and serves as a dedupe key during import. We create the Account record before any Contact import so that the CustomerId lookup is satisfied at the moment of Contact insert. Amwork's industry and address fields map to standard D365 Account attributes.

Amwork

Deal

maps to

Microsoft Dynamics 365 Sales

Opportunity

1:1
Fully supported

Amwork Deals map to Microsoft Dynamics 365 Sales Opportunity. The Amwork deal stage property maps to D365 StageName via a pre-configured Sales Process that we create before migration. Deal value maps to Amount, and the associated pipeline maps to a D365 Record Type. Closed-won and closed-lost reasons from Amwork custom fields become D365 custom fields for loss and win analysis.

Amwork

Deal Stage

maps to

Microsoft Dynamics 365 Sales

Opportunity Stage

lossy
Fully supported

Each Amwork pipeline stage becomes a D365 stage value within a Sales Process. We create a Sales Process matching your Amwork pipeline structure, set stage probability percentages, and configure the stage order before deal migration. Any Amwork stages that do not exist in D365 are created during the schema configuration phase.

Amwork

Lead (Amwork Deals and Leads section)

maps to

Microsoft Dynamics 365 Sales

Lead

1:1
Fully supported

Amwork's separate Leads section maps directly to D365 Lead if the contact has not yet been qualified or linked to a company. The Amwork lead_status property maps to D365 Lead Status. Any scoring value in Amwork migrates to a custom field amwork_lead_score__c on the D365 Lead.

Amwork

Custom Fields

maps to

Microsoft Dynamics 365 Sales

Custom Attributes

lossy
Mapping required

Amwork custom fields (text, number, date, choice types activated at the project level) migrate to D365 custom attributes on the corresponding entity. We pre-create the attribute definitions in the target D365 environment during the schema configuration phase, matching Amwork's data types to D365 attribute types. Attributes that cannot map directly (for example, Amwork multi-select choice fields) are flagged for customer decision during scoping.

Amwork

Project

maps to

Microsoft Dynamics 365 Sales

Team or Note (no direct equivalent)

1:1
Fully supported

Amwork Projects are workspace containers that do not have a direct D365 equivalent in the Sales module. We migrate project name and description as a D365 Note attached to the primary Account or Opportunity. If the customer licenses D365 Project Service Automation, we map Projects to Projects in that module as a separate engagement scope.

Amwork

Task

maps to

Microsoft Dynamics 365 Sales

Task

1:1
Fully supported

Amwork Tasks map to D365 Task. Assignee maps via email-to-User resolution. Due date, priority, and status migrate directly. Checklist sub-items on Amwork tasks become D365 subtasks or are appended to the Task description as structured text. Parent-child task hierarchy is preserved where D365 task relationships support it.

Amwork

Time Entry

maps to

Microsoft Dynamics 365 Sales

Note (on parent record)

1:1
Fully supported

Amwork time entries attach to tasks and projects, not directly to contacts or companies. We preserve time entries as D365 Notes on the parent Task or (if project mapping is in scope) on the related Account. The Note body includes the original duration, date, description, and billable flag in a formatted structure. We flag this model difference so the customer's team understands that time entries do not appear as a separate CRM object post-migration.

Amwork

User

maps to

Microsoft Dynamics 365 Sales

User

1:1
Fully supported

Amwork Users map to D365 Users by email address match. We extract every distinct owner referenced on Contact, Company, Deal, and Task record and reconcile against the destination D365 User table. Users without a matching D365 account go to a reconciliation queue for the customer's admin to provision before record import resumes. Active and inactive status carries over from Amwork.

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.

Amwork logo

Amwork gotchas

High

Import requires exact CRM field structure match

Medium

Deal stage moves require menu selection, not drag-and-drop

Medium

Time entries attach to tasks, not directly to contacts

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

  • Lead vs Contact split requires planning before migration

    Amwork's single Contact object with lifecycle stage does not have a direct Microsoft Dynamics 365 Sales equivalent. D365 expects unqualified prospects to live as Leads and qualified contacts as Contacts attached to Accounts. We define the split rule during scoping based on your Amwork lifecycle stage matrix, run it as the first transform during migration, and preserve the original lifecycle stage in a custom field on both Lead and Contact for audit. Migrations that skip this design step end up with Contacts that have no Account lookup or Leads that should have been qualified on day one.

  • Amwork automation rules do not migrate to D365 workflows

    Amwork's BPMN automation engine and workflow sequences are configuration objects, not data records. Microsoft Dynamics 365 Sales workflows and Power Automate are separate systems with different trigger models, action types, and condition logic. We do not migrate automation rules. We deliver a written inventory of every active Amwork workflow with its trigger, conditions, actions, and a recommended Power Automate or Dynamics workflow equivalent, and the customer's admin or a Microsoft partner rebuilds them post-migration.

  • D365 field-level security and validation rules can block import

    Dynamics 365 environments commonly enforce validation rules (required formats, conditional requireds, option set whitelists) and field-level security that the migrating user must explicitly bypass during data load. We coordinate with the customer's D365 admin to grant the migration user the appropriate Dataverse security role and bulk import permissions, and we either temporarily disable validation rules during load or extend them with a migration-context exclusion. Skipping this step results in 5-25 percent record rejection on the first import attempt.

  • Time entries attach to tasks, not contacts, after migration

    Amwork's time tracking model logs hours against tasks and projects. Time cannot be attached directly to a Contact or Company record in Amwork, and D365 Sales has no native time tracking object at all. We preserve time entries as Notes on the parent Task or Account, preserving duration, date, description, and billable flag. We flag this model difference in the scoping document so the customer's team understands the workflow change and can evaluate D365 Project Service Automation or a third-party time tracking integration if native time tracking is required post-migration.

Migration approach

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

  1. Discovery and scoping

    We audit the source Amwork workspace across Contacts, Companies, Deals, Leads, Projects, Tasks, custom field definitions, and time entry volume. We pair this with a target D365 environment assessment: Microsoft Dynamics 365 Sales Professional ($95/user/mo) covers most standard migrations; Sales Enterprise ($210/user/mo) is required if the customer needs AI-powered insights, advanced forecasting, or sales acceleration features. The discovery output is a written migration scope document with record counts, custom field inventory, pipeline stage mapping table, and D365 edition recommendation.

  2. Schema design and split rule definition

    We design the destination schema in D365. This includes provisioning custom attributes (with attribute types matched to Amwork field types), creating Sales Processes for each Amwork pipeline, configuring Record Types for multi-pipeline scenarios, and defining the Lead-Contact split rule based on the Amwork lifecycle stage matrix. Schema is deployed via the D365 Dataverse web API or solution package into a Sandbox environment first for validation.

  3. Sandbox migration and reconciliation

    We run a full migration into a D365 Sandbox environment using production-like data volume. The customer's RevOps lead reconciles record counts (Leads in, Contacts in, Accounts in, Opportunities in), spot-checks 20-40 random records against the Amwork source, and signs off the schema and mapping before production migration begins. Any mapping corrections happen here, not in production.

  4. Owner reconciliation and User provisioning

    We extract every distinct Amwork user referenced on Contact, Company, Deal, and Task records and match by email against the destination D365 User table. Users without a matching D365 account go to a reconciliation queue. The customer's D365 admin provisions any missing Users before record import resumes. Migration cannot proceed past this step because OwnerId and Owner (Delegate) lookups are required on most standard entities.

  5. Production migration in dependency order

    We run production migration in record-dependency order: Accounts (from Amwork Companies), Leads (with lifecycle-stage split applied), Contacts (with AccountId resolved), Opportunities (with AccountId, OwnerId, and RecordTypeId resolved), Tasks (with OwnerId resolved), Time entries (as Notes on parent Task or Account), and Custom Attributes (with attribute resolution per entity). Each phase emits a row-count reconciliation report before the next phase begins.

  6. Cutover, validation, and automation rebuild handoff

    We freeze writes to Amwork during cutover, run a final delta migration of any records modified during the migration window, then enable D365 as the system of record. We deliver the Automation Inventory document to the customer's admin team listing every Amwork BPMN workflow with its trigger, conditions, actions, and a recommended Power Automate equivalent. We support a one-week hypercare window where we resolve any reconciliation issues raised by the customer's sales team. We do not rebuild Amwork workflows as Power Automate flows inside the migration scope; that is a separate engagement or an internal admin task.

Platform deep dives

Context on both ends of the pair

Amwork logo

Amwork

Source

Strengths

  • All-in-one CRM, telephony, and automation under a single subscription
  • Built-in time tracking with Lexoffice accounting integration
  • Customizable sales pipelines and card-based record layouts
  • BPMN automation engine for workflow sequences
  • Workspace builder approach keeps CRM and project tasks in one environment

Weaknesses

  • Import requires exact field matching or records are silently dropped
  • No drag-and-drop for moving deals between pipeline stages
  • No direct time-tracking attachment to contacts or companies
  • Mobile interface is limited compared to desktop feature set
  • Support routed through WhatsApp rather than in-app ticketing
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?

Moderate CRM migration. 3 of 8 objects need a mapping; the rest are 1:1.

C

Overall complexity

Moderate migration

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

  • Object compatibility

    B

    3 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

    C

    Amwork: Not publicly documented. We assume typical SaaS tenant limits and tune extraction concurrency against the customer's plan during scoping..

  • Data volume sensitivity

    B

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

Estimator

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

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

Can't find your answer?

Walk through your Amwork 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 migrations land between two and four weeks for accounts under 10,000 Contacts and 3,000 Deals with no custom objects and a clean lifecycle stage matrix. Migrations with custom field definitions, multiple pipeline stages, large task or time entry volumes (over 200,000 records), or custom object schemas move to six to ten weeks because of schema pre-creation, lifecycle-stage split transform, and Dataverse bulk API chunking.

Adjacent paths

Related migrations to explore

Ready when you are

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