ERP migration
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
Source
Microsoft Dynamics 365 Business Central
Destination
Compatibility
7 of 12
objects map 1:1 between Ridder iQ and Microsoft Dynamics 365 Business Central.
Complexity
BStandard
Timeline
8-14 weeks
Overview
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.
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
Ridder iQ platform overview
Scorecard, SWOT, gotchas, and pricing for Ridder iQ.
Destination platform
Microsoft Dynamics 365 Business Central platform overview
Scorecard, SWOT, gotchas, and pricing for Microsoft Dynamics 365 Business Central.
Data migration guide
The complete Dynamics 365 Business Central migration guide
Data model, import mechanisms, field mapping strategy, pitfalls, and cutover — by the engineers running it.
Destination checklist
Dynamics 365 Business Central migration checklist
Pre- and post-cutover tasks for moving onto Microsoft Dynamics 365 Business Central.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
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
Microsoft Dynamics 365 Business Central
Customer and Contact
1:1Ridder 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
Microsoft Dynamics 365 Business Central
Vendor
1:1Supplier 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)
Microsoft Dynamics 365 Business Central
Item (Item Card)
1:1Ridder 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)
Microsoft Dynamics 365 Business Central
Production BOM + Assembly BOM
1:manyThis 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
Microsoft Dynamics 365 Business Central
Work Center + Routing
lossyRidder 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
Microsoft Dynamics 365 Business Central
Production Order
1:1Ridder 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
Microsoft Dynamics 365 Business Central
Sales Order + Sales Line
1:1Ridder 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
Microsoft Dynamics 365 Business Central
Purchase Order
1:1Ridder 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)
Microsoft Dynamics 365 Business Central
Job (Jobs module) or PSA Project
lossyRidder 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
Microsoft Dynamics 365 Business Central
Sales Invoice + Cust. Ledger Entry
1:1Ridder 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)
Microsoft Dynamics 365 Business Central
Document Attachment or SharePoint
lossyRidder 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
Microsoft Dynamics 365 Business Central
Workflow, Configuration
lossyWe 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.
| Ridder iQ | Microsoft Dynamics 365 Business Central | Compatibility | |
|---|---|---|---|
| Customer and Prospect | Customer and Contact1:1 | Fully supported | |
| Supplier | Vendor1:1 | Fully supported | |
| Item (Products and Materials) | Item (Item Card)1:1 | Fully supported | |
| Bill of Materials (BOM) | Production BOM + Assembly BOM1:many | Fully supported | |
| Routing | Work Center + Routinglossy | Fully supported | |
| Production Order | Production Order1:1 | Fully supported | |
| Sales Order | Sales Order + Sales Line1:1 | Fully supported | |
| Purchase Order | Purchase Order1:1 | Fully supported | |
| Project (ETO Workflow) | Job (Jobs module) or PSA Projectlossy | Fully supported | |
| Invoice and Payment | Sales Invoice + Cust. Ledger Entry1:1 | Fully supported | |
| Document (Attachments) | Document Attachment or SharePointlossy | Fully supported | |
| Workflow, Automation, Report Definition | Workflow, Configurationlossy | 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.
Ridder iQ gotchas
Data migration costs are not included in the base subscription
BOM flexibility creates multi-path migration complexity
No publicly documented API forces manual or file-based export
Microsoft Dynamics 365 Business Central gotchas
Named-user licensing has no concurrent-use relief
API rate limits throttle large-volume migrations
Historical posted transactions require selective migration scoping
NAV-to-Business Central cloud migration requires partner coordination
Custom fields and AL extensions require separate migration handling
Pair-specific challenges
Migration approach
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.
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.
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.
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.
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.
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
Ridder iQ
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Business Central
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP 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 Ridder iQ and Microsoft Dynamics 365 Business Central.
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
Ridder iQ: Not publicly documented.
Data volume sensitivity
Ridder iQ 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 Ridder iQ to Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.
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 consultationAdjacent paths
Other ways to leave Ridder iQ
Other ways to arrive at Microsoft Dynamics 365 Business Central
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.