ERP migration
Field-level mapping, validation, and rollback between Herbst Insight ERP and Microsoft Dynamics 365 Business Central. We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Business Central.
Herbst Insight ERP
Source
Microsoft Dynamics 365 Business Central
Destination
Compatibility
9 of 12
objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.
Complexity
BStandard
Timeline
6-10 weeks
Overview
Herbst Insight ERP and Microsoft Dynamics 365 are structurally different ERP platforms that share a small set of master data entity names but diverge significantly in schema design, API availability, and module granularity. Herbst Insight ERP holds Customers, Suppliers, Items, Chart of Accounts, and transactional history in a single-tenant SaaS environment with no published REST API — migrations must be scoped around direct database access or module-scoped CSV exports from the Herbst Web Portal. Microsoft Dynamics 365 ships in two ERP variants that require an early architecture decision: Business Central (SMB and mid-market, built on the former NAV codebase) and Finance and Operations (enterprise-scale, built on the former AX codebase). We confirm the destination variant during discovery based on the customer's user count, industry complexity, and module requirements. We sequence the migration of master data before transactional history, with the Chart of Accounts loaded first, followed by Customers and Suppliers, then Open AP/AR balances as balanced header-level records with line detail. Payroll data migrates as approved summaries under Irish employment law compliance. We do not migrate workflows, automations, or custom report definitions as code — we deliver a written inventory of these for the customer's 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
Herbst Insight ERP platform overview
Scorecard, SWOT, gotchas, and pricing for Herbst Insight ERP.
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 Herbst Insight ERP 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.
Herbst Insight ERP
Chart of Accounts
Microsoft Dynamics 365 Business Central
General Ledger Account (D365)
lossyThe Herbst COA is fully exportable and maps to D365 G/L Account Master in Business Central or the LedgerAccount table in Finance and Operations. We preserve account codes, names, account type (P&L vs Balance Sheet), and posting-level flags. Tax codes in Herbst map to Tax Groups in D365, and the customer finance lead must confirm the VAT scheme (standard rate, flat-rate, or ROS-compatible) before we load the tax mapping table. Financial dimensions in Finance and Operations require a separate dimension set configuration before the COA is activated — we create a default dimension set during schema design and flag any multi-dimensional reporting requirements for the customer's D365 admin.
Herbst Insight ERP
Customers
Microsoft Dynamics 365 Business Central
Customer (Business Central) or CustTable (Finance and Operations)
1:1Herbst Customer records carry billing address, shipping address, payment terms, and credit limit in a single master record. We map directly to D365 Customer, preserving the account code as the Customer Number. Customer dimensions from Herbst (if any exist) map to D365 Default Dimensions. In Finance and Operations, the customer address structure requires a primary address designation — we handle multi-address records by setting the primary address and logging secondary addresses in a Customer Address extension table for the customer's admin to confirm.
Herbst Insight ERP
Suppliers
Microsoft Dynamics 365 Business Central
Vendor (Business Central) or VendTable (Finance and Operations)
1:1Herbst Supplier records store address, banking details, and purchasing terms. We map to D365 Vendor with the same account-code-as-number convention used for Customers. In Business Central, Vendor records require a posting group assignment; in Finance and Operations, they require a Vendor Group. We set the default posting group from the supplier type identified during discovery and flag any supplier-specific terms for manual confirmation before vendor records go live.
Herbst Insight ERP
Items
Microsoft Dynamics 365 Business Central
Item (Business Central) or Released Product (Finance and Operations)
1:1Herbst Items carry SKU, description, unit of measure, costing method, and BOM data for manufactured variants. We map to D365 Item with the costing method preserved (Standard, FIFO, Average). BOM data from Herbst migrates as D365 Bill of Materials; we map the BOM lines to D365 Production BOM lines. In Finance and Operations, Item is a master entity and requires a Released Product activation step before transactions can be posted — we handle this as part of the schema deployment sequence.
Herbst Insight ERP
Open AP / Open AR
Microsoft Dynamics 365 Business Central
Vendor Ledger Entries and Customer Ledger Entries (Business Central); VendTransOpen and CustTransOpen (Finance and Operations)
1:1Open payables and receivables must be migrated as balanced header-level records with line-item detail to maintain referential integrity in D365. We extract open Herbst AP and AR records, preserve the original invoice number and due date, and create D365 open ledger entries with the correct remaining-amount and fully-invoiced flags. Any open AP tied to a specific Herbst Purchase Order maps to a corresponding D365 Purchase Order if the order is still open, or to a vendor ledger entry if the order is closed but an invoice remains outstanding. Orphaned lines — AP or AR records with no matching supplier or customer — are flagged for the customer's finance lead before we load.
Herbst Insight ERP
Sales Orders and Purchase Orders
Microsoft Dynamics 365 Business Central
Sales Order / Purchase Order (Business Central); SalesTable / PurchTable (Finance and Operations)
1:1Herbst order history is exportable but complex. We extract header status, line items, and fulfillment links. Partial or voided orders require value-mapping decisions during scoping — the customer finance lead confirms whether partial orders should be created as open orders in D365 or suppressed from migration. Completed and closed orders migrate as posted invoice history rather than order records. The order-date cutoff for migrating open orders versus historical orders is confirmed during the discovery scoping call.
Herbst Insight ERP
Inventory (Stock)
Microsoft Dynamics 365 Business Central
Item Ledger Entry and Warehouse Entry (Business Central); InventSum and InventTrans (Finance and Operations)
1:1Herbst stock records include location, batch, and serial number fields that vary by warehouse configuration. We harmonize multi-warehouse stock records and validate bin-level data against the destination warehouse configuration during sandbox migration. In Business Central, inventory is posted through item journals; in Finance and Operations, it is posted through the inventory posting profile. We recommend a go-live stock snapshot migration on the cutover date rather than a full historical stock movement migration, to avoid posting thousands of historical adjustment entries into the live D365 environment.
Herbst Insight ERP
Payroll Records
Microsoft Dynamics 365 Business Central
Employee (D365 Human Resources) or Payroll Summary (External)
1:1Herbst payroll module stores effective-dated compensation, deduction codes, and payroll run history subject to Irish employment law compliance. Due to jurisdiction-specific requirements, we migrate payroll as summarised records (annual pay, statutory leave balances, current deduction codes) rather than granular timesheet lines. The customer's HR lead and finance lead must jointly approve the payroll schema before we proceed with any compensation data load. If the destination is Finance and Operations with the Human Resources module, we map employee records to the D365 HCM Worker entity. If the destination is Business Central without HR, we migrate summaries to a custom payroll summary table that the customer's admin provisions.
Herbst Insight ERP
Users and Owner Assignment
Microsoft Dynamics 365 Business Central
User (D365)
1:1Herbst user records include role assignments and access permissions that do not map one-to-one to D365 security roles. We extract the full user list and map role names to the nearest D365 security role equivalents identified during discovery. Permissions requiring manual reconfiguration are flagged in a User Mapping Document delivered alongside the migration. The customer's D365 admin provisions the actual D365 user accounts (or assigns from Azure Active Directory) before records referencing those owners are loaded.
Herbst Insight ERP
Custom Fields and Properties
Microsoft Dynamics 365 Business Central
Custom Fields or Extension Fields (D365)
lossyHerbst Insight ERP allows custom fields within modules. We catalog every custom field definition during discovery, identify whether an equivalent D365 field already exists, and create extension fields for any remaining custom data. Custom field values migrate as part of the parent record import. In Finance and Operations, extension fields require a developer extension or a data entity that includes the extension field; we flag any Finance and Operations custom field requirements for the customer's implementation partner.
Herbst Insight ERP
Documents and Attachments
Microsoft Dynamics 365 Business Central
SharePoint / Dataverse Document Management
lossyBinary document storage in Herbst (invoice PDFs, images, scanned documents) is not accessible via standard export tools. We export document metadata and references separately and document the SharePoint or Dataverse document management setup the customer should configure in D365 before the cutover window. The actual binary files require a separate file transfer process managed by the customer's IT team using the Herbst access grant. We do not migrate documents as part of the standard migration scope.
Herbst Insight ERP
Time and Attendance
Microsoft Dynamics 365 Business Central
Worker (D365 Human Resources) or Project Timesheet
1:1Herbst time entries and attendance logs are stored separately from HR records. We map timesheet summary data to D365 Human Resources worker time-off balances or to a Project Service timesheet structure if the customer uses D365 Project Operations. Detailed timesheet lines are flagged as requiring manual entry or a separate time and attendance integration setup because granular timesheet migration across jurisdiction-specific attendance rules introduces compliance risk. The customer's HR lead confirms the timesheet scope during discovery.
| Herbst Insight ERP | Microsoft Dynamics 365 Business Central | Compatibility | |
|---|---|---|---|
| Chart of Accounts | General Ledger Account (D365)lossy | Fully supported | |
| Customers | Customer (Business Central) or CustTable (Finance and Operations)1:1 | Fully supported | |
| Suppliers | Vendor (Business Central) or VendTable (Finance and Operations)1:1 | Fully supported | |
| Items | Item (Business Central) or Released Product (Finance and Operations)1:1 | Fully supported | |
| Open AP / Open AR | Vendor Ledger Entries and Customer Ledger Entries (Business Central); VendTransOpen and CustTransOpen (Finance and Operations)1:1 | Mapping required | |
| Sales Orders and Purchase Orders | Sales Order / Purchase Order (Business Central); SalesTable / PurchTable (Finance and Operations)1:1 | Mapping required | |
| Inventory (Stock) | Item Ledger Entry and Warehouse Entry (Business Central); InventSum and InventTrans (Finance and Operations)1:1 | Mapping required | |
| Payroll Records | Employee (D365 Human Resources) or Payroll Summary (External)1:1 | Mapping required | |
| Users and Owner Assignment | User (D365)1:1 | Mapping required | |
| Custom Fields and Properties | Custom Fields or Extension Fields (D365)lossy | Mapping required | |
| Documents and Attachments | SharePoint / Dataverse Document Managementlossy | Not supported | |
| Time and Attendance | Worker (D365 Human Resources) or Project Timesheet1:1 | Mapping required |
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.
Herbst Insight ERP gotchas
Herbst does not publish public API documentation or rate limits
Herbst Web Portal exports are module-scoped, not transactional graphs
SaaS hosting means migration windows depend on vendor co-operation
Payroll module migration requires jurisdiction-specific sign-off
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
Discovery and D365 variant confirmation
We audit the source Herbst Insight ERP environment across modules in use (accounting, CRM, HR, payroll, distribution), custom field definitions, COA structure and account count, open AP and AR volume, order and inventory history depth, and the user count requiring D365 licensing. We confirm whether the destination is Business Central or Finance and Operations based on the customer's employee count, industry complexity, and module requirements. We also engage Herbst directly to establish the data extraction method (direct database access, partner export tooling, or Web Portal scoped exports) and confirm the customer's data extraction entitlements under their current Herbst contract. The discovery output is a written migration scope document with entity list, record counts, and access method confirmed.
Schema design and COA configuration
We design the destination D365 schema based on the confirmed variant. For Business Central, we configure the COA with account numbers matched to Herbst codes, tax group mappings, and posting groups. For Finance and Operations, we configure the COA with financial dimensions and the dimension set hierarchy. We pre-create any custom fields (extension fields in Business Central, extension entities in Finance and Operations) for Herbst custom field data. The Chart of Accounts must be validated by the customer's finance lead before we proceed to data extraction. We deploy the initial schema to a D365 sandbox for validation against the first Herbst data extract.
Data extraction under Herbst access method
We extract data from Herbst using the method confirmed during discovery: direct SQL query against the hosted database, partner export tool output, or staged CSV exports from the Herbst Web Portal. For Web Portal exports, we run module-by-module exports with foreign key fields preserved in every extract so that we can reconstruct relational links during transformation. We validate the extract completeness against the discovery record counts and flag any gaps before transformation begins. If direct database access is available, we run a full relational snapshot export that includes linked transactional records.
Relational reconstruction and data cleansing
We reconstruct the relational graph from Herbst's flat or module-scoped exports by matching foreign key fields (Customer ID on Orders, Supplier ID on Purchase Orders, Item No. on Order Lines) and building lookup resolution tables for D365 load. We cleanse duplicate records, fix referential integrity issues (orphaned lines, mismatched currency codes, invalid date ranges), and validate tax code mappings against the ROS-compatible tax scheme confirmed during discovery. We produce a Data Quality Report listing every flagged record with the corrective action taken, for the customer's finance lead to review before load.
Sandbox migration and sign-off
We run a full migration into a D365 sandbox environment using production data volumes. The customer's finance, operations, and HR leads reconciles record counts (Accounts, Vendors, Items, Open AP/AR, Orders, Inventory, Payroll summaries), spot-checks 25-50 representative records against the Herbst source, and signs off the schema, mapping, and data quality report. Any mapping corrections — including address restructuring, account code alignment, or payroll field scope adjustments — are applied before production migration begins.
Production migration in dependency order
We run production migration in the sequence that respects D365 referential integrity: COA (G/L Account Master first), then Vendors, then Customers, then Items, then Open AP and AR balances as balanced header-level records, then posted invoice history, then order history, then inventory snapshot, then payroll summaries (after HR sign-off), then user and custom field data. Each phase emits a row-count reconciliation report before the next phase begins. We freeze Herbst writes during the cutover window and run a final delta migration of any records modified during the migration window.
Cutover, validation, and automation rebuild handoff
We enable D365 as the system of record after the delta migration completes and the final reconciliation report shows record counts matching discovery estimates within tolerance. We deliver a written inventory of Herbst workflows, automations, and custom report definitions for the customer's admin to rebuild in D365 using the appropriate tools (Power Automate, Business Central workflows, or Finance and Operations workflow designer). We support a one-week hypercare window for reconciliation issues. We do not rebuild Herbst automations or report definitions inside the migration scope; that is a separate engagement or an internal admin task.
Platform deep dives
Herbst Insight ERP
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Business Central
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. All 8 core objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Herbst Insight ERP and Microsoft Dynamics 365 Business Central.
Object compatibility
All 8 core objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.
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
Herbst Insight ERP: Not publicly documented — typical SaaS limits assumed and confirmed during scoping.
Data volume sensitivity
Herbst Insight ERP 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 Herbst Insight ERP to Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.
Walk through your Herbst Insight ERP 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 Herbst Insight ERP
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.