CRM migration

Migrate from Novo Work Order to Microsoft Dynamics 365 Sales

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

Novo Work Order logo

Novo Work Order

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

11 of 11

objects map 1:1 between Novo Work Order and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

48–96 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Novo Work Order is a cloud work-order and asset-management platform built for municipal and public-works teams — it organizes work orders, preventive maintenance schedules, assets, and labor/parts cost tracking in a single operational model. Dynamics 365 Sales is a CRM built on Microsoft Dataverse that organizes Accounts, Contacts, Leads, and Cases with a Power Platform extension layer underneath. The two platforms share no native object-level equivalence: Novo has no Lead/Opportunity concept; Dynamics 365 Sales has no native Asset or Preventive Maintenance entity. FlitStack AI handles the migration by (1) mapping Contact and Account records directly, (2) translating Work Order records into Case entities, (3) creating a custom Asset table in Dataverse for Novo asset records, and (4) surfacing Preventive Maintenance schedule data as Entitlement or custom fields for manual scheduling in Dynamics 365. Workflows, automations, and email/notification templates do not migrate — we export definitions as reference documents for rebuilding in Dynamics 365 Power Automate or Power Apps. The migration runs against Dynamics 365's OData / Dataverse API, using bulk-create batches for large record volumes with a 24–48 hour delta-pickup window at cutover.

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

Novo Work Order logo

Novo Work Order

What's pushing teams away

  • Search engine across the platform is described in reviews as 'horrible' — locating older work orders or asset records can require multiple filter passes.
  • Some features are not intuitive and require training; reviewers note a documented learning curve.
  • Report writing is difficult to use according to reviewer feedback — operations needing rich custom reporting often supplement with external BI.
  • Public pricing is limited to the ShareNet Basic Edition at $25/user/month (annual, 3-user minimum); higher tiers are quoted by sales.
  • Vendor scale is small relative to FSM / CMMS leaders like Fiix, UpKeep, or ServiceChannel — partner ecosystem and community resources are thinner.

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 Novo Work Order objects map to Microsoft Dynamics 365 Sales

Each row shows how a Novo Work Order 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.

Novo Work Order

Contact

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

Novo contact records migrate directly to Dynamics 365 Contact entities on a one-to-one basis. Full name, email address, phone number, physical address, and any custom contact properties map directly to their corresponding Dataverse columns. Contacts in Novo that do not have an associated company link will be created as standalone Contact records in Dynamics 365 without a ParentCustomerId reference.

Novo Work Order

Company

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

Novo company records map directly to Dynamics 365 Account entities. Address information, industry classification, and employee-count fields have direct counterparts in Dataverse. Parent-child company hierarchies in Novo are translated to Account.ParentId lookups in Dataverse — any circular references are flagged during validation and resolved before the migration batch commits.

Novo Work Order

Work Order

maps to

Microsoft Dynamics 365 Sales

Incident (Case)

1:1
Fully supported

Novo Work Order translates to Dynamics 365 Case (Incident). Work order number becomes TicketNumber; title becomes Title; description becomes Description; status and priority map via value-mapping to StatusCode and PriorityCode. The original created-on timestamp is preserved as a custom field since Dynamics 365 sets CreatedOn at insert time.

Novo Work Order

Asset / Equipment

maps to

Microsoft Dynamics 365 Sales

Custom Asset Table

1:1
Fully supported

Dynamics 365 Sales Professional has no native asset entity. We create a custom Asset table (msdyn_asset or named Asset__c) in Dataverse with fields for asset name, location, condition code, and linked work-order history. Enterprise and Premium tiers support more complex asset schemas via the Field Service attachment.

Novo Work Order

Preventive Maintenance Schedule

maps to

Microsoft Dynamics 365 Sales

Entitlement / Custom Schedule Table

1:1
Fully supported

Novo PM schedules (frequency, interval, technician assignment) have no native Dynamics 365 equivalent. We migrate the schedule definition as a custom Entitlement record or as fields on the custom Asset table, leaving the recurring-trigger logic to be rebuilt in Power Automate or Dynamics 365 Field Service.

Novo Work Order

Work Order Activity

maps to

Microsoft Dynamics 365 Sales

Task / Phone Call / Email activity

1:1
Fully supported

Work order notes, comments, and communication logs in Novo map directly to Dynamics 365 Activities such as Task or Email records. Each activity is linked to the corresponding Case record via the regarding_objectid lookup field. Original timestamps from Novo and the assigned technician name are preserved on the migrated activity record for full audit continuity.

Novo Work Order

Labor Hours / Parts Cost

maps to

Microsoft Dynamics 365 Sales

Custom Fields on Case / Annotation

1:1
Fully supported

Labor hours and parts cost tracked on Novo work orders migrate as custom decimal and currency fields on the Case record. Line-item parts detail is stored as an Annotation attachment or as custom sub-grid rows if your Dynamics schema supports product-line linking on Cases.

Novo Work Order

User / Technician

maps to

Microsoft Dynamics 365 Sales

SystemUser

1:1
Fully supported

Novo technicians and staff members map to Dynamics 365 SystemUser records. Owner resolution occurs via email matching: each Novo owner or technician email is matched against existing Dynamics 365 users. Any technicians that remain unmatched after the email lookup are flagged and held for admin review before the full migration batch commits to the destination system.

Novo Work Order

Custom Fields (all objects)

maps to

Microsoft Dynamics 365 Sales

Custom Columns

1:1
Fully supported

Any custom fields created in the Novo platform migrate as custom columns in Dataverse. The original field data type is preserved during migration including text strings, numeric values, date fields, and pick-list enumerations. Dynamics 365 Professional tier enforces a strict 15-custom-table limit that may require schema optimization — Enterprise and Premium tiers remove this ceiling entirely.

Novo Work Order

Attachment / File

maps to

Microsoft Dynamics 365 Sales

Annotation / SharePoint (connected)

1:1
Fully supported

Files attached to work orders in Novo are downloaded and re-attached to the corresponding Case record as Annotation records. If your Dynamics tenant has SharePoint integration enabled, files are migrated to SharePoint Document Libraries with the case record as the folder parent.

Novo Work Order

Workflow / Automation

maps to

Microsoft Dynamics 365 Sales

Not Migrated

1:1
Fully supported

Novo workflow rules, email templates, and notification triggers do not have a migration path to Dynamics 365. We export a JSON/YAML representation of every Novo workflow definition as a reference document for your Dynamics admin to rebuild in Power Automate.

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.

Novo Work Order logo

Novo Work Order gotchas

High

No public API forces migration via built-in exports

Medium

Pricing opacity complicates budget planning

Medium

Municipal-specific custom fields need careful schema mapping

Low

Preventative maintenance recurrence rules vary by configuration

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

  • No native asset entity in Dynamics 365 Sales Professional

    Dynamics 365 Sales Professional ships without a native asset or equipment table. Novo work orders frequently reference asset records — those references break if migrated to a bare Case entity. We handle this by creating a custom Asset table (msdyn_asset) in Dataverse before the migration runs, then wiring the PrimaryAssetId lookup on each Case record. If you are on the Professional tier, be aware of the 15-custom-table limit: large asset datasets with multiple custom fields per asset may push you toward the Enterprise or Premium tier to avoid hitting the ceiling during migration or post-go-live customisation.

  • Preventive maintenance recurrence logic does not migrate

    Novo's preventive maintenance schedules include a recurrence engine (frequency in days, interval, and technician assignment) that has no equivalent in Dynamics 365 Sales. Dynamics 365 implements SLA response windows through the SLA entity and recurring work orders through Field Service Bookable Resources — neither is active by default in Sales Professional. We preserve the PM definition (frequency, last-run date, next-run date) as custom fields on the Asset table and deliver a Power Automate flow template for schedule regeneration, but the scheduling automation itself must be rebuilt after go-live.

  • Novo workflows and email templates are not transferable

    Novo automations — status-change notifications, assignment routing rules, and email templates — live in Novo's workflow engine and cannot be exported in a format that maps to Dynamics 365 Power Automate or classic workflows. We deliver a workflow-definition export (JSON) listing every Novo rule, its trigger, condition, and action. Your Dynamics admin uses this as a rebuild specification for Power Automate cloud flows. Missing this step means your team loses automatic escalation and notification behaviour that they rely on in Novo.

  • Dataverse API rate limits require batch throttling on large imports

    Dynamics 365 Dataverse enforces request-queue limits that vary by tenant type and assigned Power Platform capacity. Large Novo databases with 100,000 or more work order records require chunked batch inserts with built-in retry logic to handle transient failures. The migration runs in configurable batch sizes and continuously monitors HTTP 429 responses from Dataverse to self-throttle the ingestion rate. This approach extends wall-clock time on large datasets but prevents partial-failure scenarios where some records insert successfully while others time out mid-run.

  • Labor-hours and parts-cost tracking requires custom fields on Case

    Novo tracks granular labor line items and parts costs per work order. Dynamics 365 Sales does not store line-item cost data on the Case entity out of the box — product-cost tracking lives in the Order and Invoice entities. We store aggregated labor hours and parts cost as custom currency and decimal fields on the Case record. If your team needs per-line-parts detail, we surface it as an Annotation attachment or as product-line rows on a related Order record, depending on your post-migration process design.

Migration approach

Six steps for a successful Novo Work Order to Microsoft Dynamics 365 Sales data migration

  1. Stand up the Dataverse schema before data moves

    Before any record moves, we create the custom Asset table, custom fields on the Case entity, and any custom pick-list values needed for Work Order Type and Priority value-mapping. We deliver a schema-setup checklist specifying the exact Dataverse column names, data types, and pick-list values so your Dynamics admin can pre-create the structure. Professional-tier customers receive a table-count audit to confirm the migration stays within the 15-table limit.

  2. Resolve Novo technicians and users against Dynamics 365 SystemUser by email

    Every work order owner and technician in Novo is matched to a corresponding Dynamics 365 user record by email address lookup. We generate a comprehensive pre-migration owner-resolution report listing all matched users, unmatched Novo owners, and a recommended fallback owner for each unmatched record. Your team must resolve all open items before the migration run commits — the rule is that no record lands in Dynamics 365 without an owner assignment.

  3. Migrate Accounts and Contacts before Cases to resolve foreign-key lookups

    Dynamics 365 requires Account records to exist before Contact records can be linked (ParentCustomerId lookup), and it requires Contact records to exist before Cases can use the CustomerId field. We sequence the migration: Accounts → Contacts → Assets (custom table) → Cases. Within each entity type, records with the most cross-references are prioritised so that lookup resolution succeeds at insert time without post-hoc remediation.

  4. Run a sample migration with field-level diff across a representative slice

    A sample run migrates 200–500 records spanning Contacts, Accounts, Work Orders, and Assets. We generate a field-level diff comparing source values against destination field contents, flagging mismatches in pick-list values, date precision, and owner resolution. You review the diff before the full run — this is the moment to catch a Work Order Type that has no matching CaseTypeCode value or a Priority value that sits outside the Dynamics 365 pick-list range.

  5. Full migration run with delta-pickup and audit log

    The full migration commits all validated records to Dynamics 365 using bulk API operations. A delta-pickup window lasting 24–48 hours captures any work orders created or modified in Novo during the cutover window so the destination reflects Novo's final state at go-live. Every insert, update, and error is recorded in a detailed audit trail, and a one-click rollback mechanism reverts all migrated records if post-run reconciliation identifies any data integrity issues that require reversal.

Platform deep dives

Context on both ends of the pair

Novo Work Order logo

Novo Work Order

Source

Strengths

  • Links work orders directly to physical assets and equipment for full maintenance history
  • Multi-department routing handles municipal organizational structures out of the box
  • Preventative maintenance scheduling reduces reactive repairs on infrastructure
  • Custom fields, forms, and workflows adapt to municipal compliance and reporting requirements
  • Mobile app allows field technicians to update work order status and log labor from the job site

Weaknesses

  • No public API documented — migration depends on built-in export functions and support coordination
  • Pricing is opaque — no self-service quotes, free tier, or published per-seat cost
  • Designed for municipal government use cases — lacks commercial field service contract and SLA features
  • Limited third-party integrations compared to modern FSM platforms
  • Reporting and analytics are built-in dashboards rather than a queryable data warehouse
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 Novo Work Order 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

    Novo Work Order: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

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

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

Can't find your answer?

Walk through your Novo Work Order 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 Novo Work Order to Dynamics 365 migrations complete within 48–96 hours of wall-clock time for datasets under 10,000 records. Larger setups with 100,000+ work order records, a custom Asset table, and preventive-maintenance translation extend to 10–15 business days. The longest single step is Dataverse custom-table and field creation — we handle that in parallel with data extraction from Novo. The migration runs in batches against the Dataverse API, self-throttling to avoid HTTP 429 rate-limit errors.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Novo Work Order.
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