ERP migration

Migrate from Ridder iQ to Microsoft Dynamics 365 Business Central

Field-level mapping, validation, and rollback between Ridder iQ and Microsoft Dynamics 365 Business Central. We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Business Central.

Ridder iQ logo

Ridder iQ

Source

Microsoft Dynamics 365 Business Central

Destination

Microsoft Dynamics 365 Business Central logo

Compatibility

58%

7 of 12

objects map 1:1 between Ridder iQ and Microsoft Dynamics 365 Business Central.

Complexity

BStandard

Timeline

8-14 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Ridder iQ is a manufacturing-specific ERP that coordinates R&D, engineering, purchasing, production, and service teams from quote to delivery, with unusually flexible BOM management that allows components to be produced or purchased interchangeably at any level. Microsoft Dynamics 365 Business Central is a modular cloud ERP that handles manufacturing through production BOMs, routings, and an optional Jobs module for project-centric ETO workflows. Because Ridder iQ has no publicly documented REST API, we work with the customer's IT team to obtain direct database read access or scheduled export files before beginning any mapping. We resolve BOM variant complexity (each distinct make-or-buy path becomes a separate master item with its own BOM in Business Central), preserve margin data at the order line level in custom fields, and map ETO project phases to the appropriate Business Central Jobs structure or a documented configuration plan. Workflows, automations, and reporting definitions do not migrate as code; we deliver a written inventory for the customer's admin team to rebuild post-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

Ridder iQ logo

Ridder iQ

What's pushing teams away

  • Reviewer concerns about service-module fixed-price settings — 'fixed price settings for parts list in service is not possible' was flagged in TrustRadius reviews.
  • Engineering CAD integration with Autodesk packages was called 'expensive and too simple' — engineering-heavy shops may need additional tooling.
  • Pricing is sales-led with no published rate card — buyers face per-engagement negotiation through ECI or local partners.
  • Smaller third-party developer/partner ecosystem outside Benelux — overseas customers find limited consultant network.
  • Customers scaling into multi-entity, multi-currency global operations typically migrate to SAP S/4HANA or Microsoft Dynamics 365 F&SCM.

Choosing

Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central

What's pulling them in

  • Deep integration with Microsoft 365, Power BI, and Power Platform means organizations already on the Microsoft stack get identity, reporting, and workflow continuity out of the box.
  • Unified financials, sales, service, and operations replace multiple disconnected systems — users report that data entered once flows through purchase orders, invoicing, and approvals without manual re-entry.
  • Copilot AI features (predictive analytics, embedded business intelligence) are included in both Essentials and Premium tiers, addressing demand for AI without separate module purchases.
  • Named-user licensing with no concurrent model appeals to organizations that want predictable per-seat costs even if some users access the system infrequently.
  • Strong partner ecosystem with certified NAV-to-Business Central migration specialists gives mid-market companies confidence the cutover from legacy Navision can be executed reliably.

Object mapping

How Ridder iQ objects map to Microsoft Dynamics 365 Business Central

Each row shows how a Ridder iQ object lands in Microsoft Dynamics 365 Business Central, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Ridder iQ

Customer and Prospect

maps to

Microsoft Dynamics 365 Business Central

Customer and Contact

1:1
Fully supported

Ridder iQ CRM records for customers and prospects map to Business Central Customer and Contact entities, or to the Account and Contact entities if the Microsoft Dynamics 365 Sales CRM module is activated. Ridder iQ's Outlook integration for email and calendar is replaced by the native Microsoft 365 integration in Dynamics 365. We preserve customer credit limits, payment terms, and any CRM-specific fields (industry classification, customer since date) in mapped Business Central Customer fields or custom fields if no standard equivalent exists.

Ridder iQ

Supplier

maps to

Microsoft Dynamics 365 Business Central

Vendor

1:1
Fully supported

Supplier master records from Ridder iQ map directly to Business Central Vendor. We preserve payment terms, lead times, and any associated purchase history as line-item records in the destination. Supplier-specific contact fields map to Vendor Contact information in Business Central. If the customer uses 3-way matching for purchase invoices, we flag the Vendor posting group assignment for the customer's finance team to configure.

Ridder iQ

Item (Products and Materials)

maps to

Microsoft Dynamics 365 Business Central

Item (Item Card)

1:1
Fully supported

Ridder iQ items covering raw materials, components, and finished goods map to Business Central Item records with the Item Type field set to Inventory, Non-Inventory, or Service based on usage context. Unit of measure, cost, and supplier-link data transfer to the respective Business Central Item Card fields. We flag any items with multiple active unit-of-measure conversions for Business Central's UoM handling review and any items flagged as both manufactured and purchased for BOM variant analysis.

Ridder iQ

Bill of Materials (BOM)

maps to

Microsoft Dynamics 365 Business Central

Production BOM + Assembly BOM

1:many
Fully supported

This is the highest-complexity mapping in the migration. Ridder iQ allows each BOM component to be produced or purchased interchangeably, creating multiple valid production paths for the same finished item. Business Central separates production BOMs (manufactured items) from assembly BOMs (kits). We represent each distinct make-or-buy production path as a separate master item with its own Production BOM in Business Central. Items with more than one active BOM variant are flagged for the customer's engineering team to review and confirm the intended production path before the BOM hierarchy is committed. Phantom assemblies in Ridder iQ map to Business Central phantom BOM lines.

Ridder iQ

Routing

maps to

Microsoft Dynamics 365 Business Central

Work Center + Routing

lossy
Fully supported

Ridder iQ production routings map to Business Central Work Centers and Machine Centers, which combine into Routing records attached to production BOM versions. Each routing step in Ridder iQ becomes a Work Center Operation in Business Central with the same sequence, setup time, and run time values. We validate that the work center capacity unit in Business Central matches the time-tracking unit in Ridder iQ (hours, minutes, or fractions thereof) before committing the routing.

Ridder iQ

Production Order

maps to

Microsoft Dynamics 365 Business Central

Production Order

1:1
Fully supported

Ridder iQ production orders reference a BOM and routing with scheduled start and end dates, work center assignments, and component allocations. We map production order status (Released, Finished, Cancelled) directly to Business Central Production Order Status. BOM linkage and scheduled quantities transfer to the Production Order Components and Operations lines respectively. Open production orders migrate as Firm Planned or Released in Business Central; closed orders migrate as Finished. Component allocation records in Ridder iQ generate from the BOM at migration time rather than preserving the pre-allocated quantities, which Business Central recalculates on release.

Ridder iQ

Sales Order

maps to

Microsoft Dynamics 365 Business Central

Sales Order + Sales Line

1:1
Fully supported

Ridder iQ sales orders spanning the quote-to-invoice lifecycle map to Business Central Sales Order and Sales Line. Customer reference, order dates, and pricing transfer directly. Pre- and post-calculation margin data per line has no standard Business Central equivalent at the line level; we preserve margin values in a custom decimal field on the Sales Line and discuss with the customer whether margin analysis is handled via the Jobs module, Power BI, or a custom extension post-migration. Open orders migrate as open; closed orders migrate as invoiced or as read-only records at the customer's choice.

Ridder iQ

Purchase Order

maps to

Microsoft Dynamics 365 Business Central

Purchase Order

1:1
Fully supported

Ridder iQ purchase orders linking Suppliers and Items map to Business Central Purchase Order. Order quantities, due dates, and supplier references transfer to Purchase Header and Lines. Open POs migrate as open in Business Central and can continue to receive against in the new system. Closed POs migrate as historical records with received quantities preserved if the customer elects to carry historical purchase data. We flag any POs with line items referencing BOM components that have not yet been migrated to prevent orphan references.

Ridder iQ

Project (ETO Workflow)

maps to

Microsoft Dynamics 365 Business Central

Job (Jobs module) or PSA Project

lossy
Fully supported

Ridder iQ Projects coordinating multi-department ETO workflows (R&D, engineering, purchasing, production phases) with budget, milestone, and cost-tracking data require a scoping decision before mapping. If the customer uses Business Central Jobs, we map project phases to Job Task lines with WIP tracking, milestone dates to Job Planning Lines, and budget data to Job Budget Lines. If the customer's ETO workflow includes resource planning, billing, and advanced project accounting, we recommend evaluating Dynamics 365 Project Operations and document the mapping accordingly rather than forcing ETO complexity into the base Jobs module. Budget and milestone data are preserved in custom Job Task fields or as a documented import specification for the customer's implementation team.

Ridder iQ

Invoice and Payment

maps to

Microsoft Dynamics 365 Business Central

Sales Invoice + Cust. Ledger Entry

1:1
Fully supported

Ridder iQ invoices linked to Sales Orders with payment status tracking map to Business Central Sales Invoice and the corresponding Customer Ledger Entries in the General Ledger. Invoice headers, line items, amounts, and payment reconciliation data transfer to posted invoices or to open entries as appropriate. Historical closed invoices are mapped as read-only posted records in Business Central. We do not re-open or re-post closed invoices; they retain their original posting dates and GL impact as closed periods.

Ridder iQ

Document (Attachments)

maps to

Microsoft Dynamics 365 Business Central

Document Attachment or SharePoint

lossy
Fully supported

Ridder iQ documents attached to Orders, Projects, Items, and other entities with version history map to Business Central Document Attachments (the standard record-level file attachment feature) or to SharePoint Document Libraries if the customer already uses Microsoft 365 SharePoint. We export file attachments and metadata from Ridder iQ during the file-based export phase. We do not migrate version-diff data or previous revision history; the current revision attaches as the active document. If the customer uses IXON Cloud or IXON Apps for machine data integration, we flag this as an external system that requires a separate integration plan post-migration.

Ridder iQ

Workflow, Automation, Report Definition

maps to

Microsoft Dynamics 365 Business Central

Workflow, Configuration

lossy
Fully supported

We do not migrate workflows, production scheduling rules, reporting definitions, or document management automations as code. These are platform-specific configuration objects that do not survive direct export between different ERP architectures. We deliver a written inventory of every active Ridder iQ workflow, automation rule, and custom report with its trigger, conditions, actions, and a recommended Business Central equivalent (Job Queue, Workflow, or Report redesign). The customer's admin or a Microsoft partner rebuilds them post-migration as part of the Business Central configuration phase.

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.

Ridder iQ logo

Ridder iQ gotchas

High

Data migration costs are not included in the base subscription

Medium

BOM flexibility creates multi-path migration complexity

Medium

No publicly documented API forces manual or file-based export

Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central gotchas

High

Named-user licensing has no concurrent-use relief

High

API rate limits throttle large-volume migrations

Medium

Historical posted transactions require selective migration scoping

Medium

NAV-to-Business Central cloud migration requires partner coordination

Low

Custom fields and AL extensions require separate migration handling

Pair-specific challenges

  • No REST API forces database or file-based export

    Ridder iQ has no publicly documented REST API, confirmed across Capterra, TrustRadius, SoftwareSuggest, and IXON Marketplace reviews. All data extraction requires either direct SQL read access to the Ridder iQ database (coordinated with the customer's IT and legal teams for a read-only connection) or scheduled file exports from the application. We scope the export mechanism during discovery, validate record counts against in-system totals, and handle all schema mapping without relying on a live API feed. This constraint extends the discovery phase by one to two weeks compared to API-based migrations.

  • Multi-variant BOMs require engineering review before migration

    Ridder iQ's flexibility in allowing the same component to be produced or purchased with different BOMs for the same finished item creates a structural mismatch with Business Central's rigid production BOM model. When multiple BOM variants exist for a single item, we represent each variant as a separate master item with its own Production BOM, but this requires the customer's engineering team to confirm which production path is active per item before BOM hierarchies are committed to Business Central. Items with more than two active BOM variants are flagged as high-priority review items that can hold up the BOM migration phase if not resolved early.

  • Ridder iQ margin data has no standard Business Central field

    Ridder iQ stores pre-calculation and post-calculation margin data per sales order line. Business Central does not expose margin fields at the sales line level as a standard feature. We preserve margin values in a custom decimal field on the Sales Line during migration, but margin analysis in Business Central requires either a custom extension, a Power BI report, or the use of the Jobs module for WIP and billing margin tracking. We discuss the customer's preferred margin reporting approach during scoping and configure the custom field accordingly.

  • ETO project structure maps to Jobs but may require extension

    Ridder iQ ETO projects with phases spanning R&D, engineering, purchasing, and production require a scoping decision during discovery. Business Central's Jobs module handles basic project costing and WIP tracking but does not natively replicate the phase-gated ETO workflow structure. If the customer's ETO process requires resource planning, advanced billing schedules, or cross-project capacity planning, we recommend evaluating Dynamics 365 Project Operations or a manufacturing-specific ISV extension, and we document the full mapping specification for that evaluation rather than forcing the migration into a mismatched Jobs structure.

  • Data quality issues compound without pre-migration profiling

    Manufacturing ERPs accumulate years of data inconsistencies: duplicate vendors created under different names, items with inactive BOMs still referenced by production orders, supplier lead times not synchronized with current vendor agreements, and posting groups changed historically without documentation. Business Central's required field validation and dimension architecture will reject or misclassify records that appear valid in Ridder iQ. We treat data profiling as a distinct workstream, produce an exception report against Business Central's required fields, and deliver cleansing scripts for the customer's data team to address before the migration load begins.

Migration approach

Six steps for a successful Ridder iQ to Microsoft Dynamics 365 Business Central data migration

  1. Export mechanism coordination and discovery

    We coordinate with the customer's IT team to establish the Ridder iQ data export method: either direct SQL read-only access to the database or scheduled export files generated by the application. We scope the full record inventory across Customers, Suppliers, Items, BOMs, Production Orders, Sales Orders, Purchase Orders, Projects, Invoices, and Documents, profiling record counts and identifying BOM complexity (items with multiple active BOM variants). We also assess ETO project structure complexity and any document management volume. The discovery output is a written scope document with record counts, export timeline, and the BOM variant flagging plan.

  2. BOM complexity resolution and engineering review

    We extract the full BOM tree from Ridder iQ and identify every finished item with more than one active BOM variant, every component with a make-or-buy flag that differs between BOM versions, and every phantom assembly. We deliver a BOM variant report to the customer's engineering team for review and confirmation of the intended production path per item. This review must be completed before the BOM migration phase begins. Items without a confirmed production path are held in a pending BOM queue and do not block other migration phases.

  3. Schema design in Business Central

    We design the Business Central destination schema based on the discovery scope. This includes G/L Account structure and posting groups, Location codes for multi-site inventory, dimension architecture (department, product line, cost center) aligned with Ridder iQ's existing cost center model, custom fields for margin data on Sales Lines and BOM variant flags on Item Cards, Work Center and Machine Center configuration for production routing, and the Jobs module configuration or Project Operations integration plan for ETO projects. Schema is deployed to a Business Central Sandbox via the administration interface or through a partner's deployment tooling for validation before any data moves.

  4. Sandbox migration and data quality profiling

    We run a full migration into the Business Central Sandbox using production-like data volumes. The customer reconciles record counts (Customers in, Vendors in, Items in, BOMs in, Production Orders in, Sales Orders in) against the Ridder iQ system totals and spot-checks twenty-five to fifty records per entity type for data accuracy. We produce a data quality exception report against Business Central's required field and dimension constraints, flagging any records that will fail or require transformation during production load. Data cleansing tasks are assigned to the customer's team as a parallel workstream.

  5. Production migration in dependency order

    We run production migration in record-dependency order: Vendors and Customers first (satisfying the primary lookups required by all transactional records), then Items (without BOM assignments), then Production BOMs and Routings (resolving component items already in the system), then Production Orders (with BOM and Routing references resolved), then Sales Orders and Purchase Orders (with customer, vendor, and item lookups satisfied), then ETO Projects and Job data (with phase dependencies mapped), then Invoice and payment history, and finally Document attachments and file metadata. Each phase emits a row-count reconciliation report and a sample validation report before the next phase begins.

  6. Cutover, validation, and configuration rebuild handoff

    We freeze writes in Ridder iQ during a defined cutover window, run a delta migration of any records created or modified during the window, then enable Business Central as the system of record. We deliver the Workflow and Automation Inventory document and the Custom Report specification to the customer's admin team. We support a one-week hypercare window where we resolve any reconciliation discrepancies reported by the customer's operations or finance team. We do not rebuild Ridder iQ workflows, production scheduling rules, or custom reports inside the migration scope; that work is a separate Business Central configuration engagement or an internal admin task.

Platform deep dives

Context on both ends of the pair

Ridder iQ logo

Ridder iQ

Source

Strengths

  • Established Benelux SMB manufacturing footprint with Dutch documentation.
  • Bundled ERP + CRM + shop-floor execution in one product.
  • Strong price/functionality reputation versus SAP/Infor in reviewer feedback.
  • Tablet-based shop-floor module supports floor data capture out of the box.
  • ECI ownership adds global infrastructure and roadmap visibility.

Weaknesses

  • Service-module fixed-price settings limitations flagged by reviewers.
  • Autodesk integration is expensive and basic per reviewer feedback.
  • Pricing is opaque — sales-led only.
  • Limited consultant ecosystem outside Benelux.
  • Not a fit for multi-entity global enterprises.
Microsoft Dynamics 365 Business Central logo

Microsoft Dynamics 365 Business Central

Destination

Strengths

  • Tight integration with Microsoft 365 (Outlook, Teams, SharePoint) for users already in the Microsoft ecosystem.
  • Includes Copilot AI, predictive analytics, and embedded Power BI dashboards at no additional cost in both license tiers.
  • Supports multiple companies within a single tenant for holding-company or multi-entity organizational structures.
  • Open REST API v2.0 with OAuth 2.0 authentication and data entity abstraction layer for developer-friendly integrations.
  • Strong partner ecosystem specializing in NAV-to-Business Central migrations provides implementation confidence for legacy upgrades.

Weaknesses

  • Named-user licensing model means every active user account requires a paid license — no concurrent access model to reduce costs for occasional users.
  • SaaS-only deployment means no on-premises option; organizations requiring full data residency control may not have viable alternatives within Microsoft's stack.
  • Manufacturing module (Production Orders, routing, work centers) is only available on Premium tier, pushing cost-sensitive manufacturers to higher-priced plans.
  • Customization and extension development requires AL language knowledge and developer licenses, limiting what power users can do without a partner engagement.
  • Global pricing increases effective October 2024 and again October 2025 after five years of stable pricing, creating budget uncertainty for existing customers.

Complexity grading

How hard is this migration?

Standard ERP 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 Ridder iQ and Microsoft Dynamics 365 Business Central.

  • 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

    Ridder iQ: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

Estimate your Ridder iQ to Microsoft Dynamics 365 Business Central 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 Ridder iQ to Microsoft Dynamics 365 Business Central data migrations

Answers to the questions buyers ask most during Ridder iQ to Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Ridder iQ to Microsoft Dynamics 365 Business Central migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Migrations land between eight and fourteen weeks for accounts with fewer than 30,000 items, fewer than 200 BOMs, no multi-variant BOM complexity, and straightforward ETO project structures. Migrations with active ETO project portfolios, more than two BOM variants per finished item, large purchase and production order histories, or substantial document attachment volumes move to fourteen to twenty-four weeks because of BOM engineering review time, ETO phase mapping complexity, and document export handling.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Ridder iQ.
Land in Microsoft Dynamics 365 Business Central, 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