ERP migration

Migrate from Herbst Insight ERP to Microsoft Dynamics 365 Business Central

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 logo

Herbst Insight ERP

Source

Microsoft Dynamics 365 Business Central

Destination

Microsoft Dynamics 365 Business Central logo

Compatibility

75%

9 of 12

objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.

Complexity

BStandard

Timeline

6-10 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

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

Herbst Insight ERP logo

Herbst Insight ERP

What's pushing teams away

  • No public pricing — quotes are sales-led through Herbst Software or its reseller network.
  • Ireland-centric — multinational SMEs operating outside Ireland may find international support and localisation thinner than NetSuite or Sage Intacct.
  • Limited public API documentation — extraction requires reseller or vendor engagement.
  • Smaller third-party developer/integrator ecosystem compared to mainstream cloud ERPs.
  • Companies scaling beyond mid-market complexity (multi-entity consolidation, IFRS reporting at scale) typically migrate to NetSuite, Microsoft Dynamics 365, or SAP.

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 Herbst Insight ERP objects map to Microsoft Dynamics 365 Business Central

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

maps to

Microsoft Dynamics 365 Business Central

General Ledger Account (D365)

lossy
Fully supported

The 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

maps to

Microsoft Dynamics 365 Business Central

Customer (Business Central) or CustTable (Finance and Operations)

1:1
Fully supported

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

Vendor (Business Central) or VendTable (Finance and Operations)

1:1
Fully supported

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

Item (Business Central) or Released Product (Finance and Operations)

1:1
Fully supported

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

Vendor Ledger Entries and Customer Ledger Entries (Business Central); VendTransOpen and CustTransOpen (Finance and Operations)

1:1
Mapping required

Open 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

maps to

Microsoft Dynamics 365 Business Central

Sales Order / Purchase Order (Business Central); SalesTable / PurchTable (Finance and Operations)

1:1
Mapping required

Herbst 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)

maps to

Microsoft Dynamics 365 Business Central

Item Ledger Entry and Warehouse Entry (Business Central); InventSum and InventTrans (Finance and Operations)

1:1
Mapping required

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

Employee (D365 Human Resources) or Payroll Summary (External)

1:1
Mapping required

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

User (D365)

1:1
Mapping required

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

Custom Fields or Extension Fields (D365)

lossy
Mapping required

Herbst 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

maps to

Microsoft Dynamics 365 Business Central

SharePoint / Dataverse Document Management

lossy
Not supported

Binary 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

maps to

Microsoft Dynamics 365 Business Central

Worker (D365 Human Resources) or Project Timesheet

1:1
Mapping required

Herbst 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.

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.

Herbst Insight ERP logo

Herbst Insight ERP gotchas

High

Herbst does not publish public API documentation or rate limits

Medium

Herbst Web Portal exports are module-scoped, not transactional graphs

Medium

SaaS hosting means migration windows depend on vendor co-operation

Low

Payroll module migration requires jurisdiction-specific sign-off

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

  • Herbst has no public API — access method determines feasibility

    Herbst Insight ERP has no publicly documented REST or bulk API endpoint reference. Export-based migrations must rely on direct SQL access to the hosted database, partner export tools, or the Herbst Web Portal's data view. We establish the access method during scoping, and where direct database access is unavailable we use staged CSV exports per module. This is flagged as high severity because the access method directly determines whether we can extract relational graph data (for transactional history) or only flat record sets. Customers should confirm their current contract status and data extraction entitlements with their Herbst account manager before migration kickoff.

  • Finance and Operations single-primary-address constraint reshapes customer and supplier data

    D365 Finance and Operations allows multiple address purposes to be defined on an address record (invoice, delivery, etc) but only one address can be marked as primary per purpose type. Herbst Web Portal exports may carry separate primary-invoice and primary-delivery addresses that require restructuring before D365 load. In Business Central the address model is more flexible. We identify the address pattern from Herbst during discovery and restructure accordingly, setting the primary address and logging secondary addresses for manual confirmation before go-live.

  • D365 validation rules block import if source data does not conform

    Finance and Operations and Business Central enforce field validation rules that Herbst exports may not satisfy — required field formats, conditional requireds, and picklist whitelists are common sources of rejection. We coordinate with the customer's D365 admin to grant the migration user the required data entity permissions and either temporarily suspend blocking validation rules during the load window or extend them with a migration-context exclusion. Skipping this step typically results in 5-25 percent record rejection on the first import pass, requiring rework and extension of the migration timeline.

  • Herbst Web Portal exports are module-scoped — relational links require reconstruction

    The Herbst Web Portal exports records per module (sales, purchases, stock) without the relational graph between them. Customer records export separately from their Orders, and Order lines export separately from Payments. We reconstruct the relational links during transformation using foreign key fields present in the export, then validate against the D365 sandbox before production load. Any records missing linking fields are flagged as orphaned and escalated to the customer's admin before we proceed.

  • Payroll jurisdiction sign-off is required before Irish compensation data loads

    Herbst Insight ERP's payroll module stores effective-dated compensation and deduction codes subject to Irish employment law and Revenue Online Service (ROS) compliance. We migrate payroll as summarised records rather than granular timesheet lines to avoid jurisdiction-mapping errors. The customer's HR lead and finance lead must jointly approve the payroll schema and the data fields we will load before any compensation data moves. This sign-off step is a gate in our migration sequence and must complete before we enter the payroll migration phase.

Migration approach

Six steps for a successful Herbst Insight ERP to Microsoft Dynamics 365 Business Central data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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

Context on both ends of the pair

Herbst Insight ERP logo

Herbst Insight ERP

Source

Strengths

  • SaaS delivery eliminates on-premise hardware, patching, and IT overhead for SMEs.
  • Modular design lets businesses configure only the modules they need — accounting, CRM, HR, payroll, distribution.
  • Irish-headquartered with direct vendor support and local reseller network.
  • Integrated web portal gives customers self-service access to orders, invoices, and statements.
  • Real-time ROM reports provide immediate visibility into accounts data across modules.

Weaknesses

  • Very limited public API documentation — export relies on direct database access or partner tooling.
  • Small market footprint compared to Tier-1 ERPs means fewer third-party integration templates exist.
  • Pricing tiers and feature gates are not publicly published, requiring direct sales engagement.
  • G2 review volume is extremely low (1 verified review), limiting independent quality signals.
  • Hosting is vendor-managed SaaS, giving customers limited control over infrastructure-level customisation.
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. All 8 core objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.

B

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

    A

    All 8 core objects map 1:1 between Herbst Insight ERP and Microsoft Dynamics 365 Business Central.

  • 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

    Herbst Insight ERP: Not publicly documented — typical SaaS limits assumed and confirmed during scoping.

  • Data volume sensitivity

    B

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

Estimator

Estimate your Herbst Insight ERP 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 Herbst Insight ERP to Microsoft Dynamics 365 Business Central data migrations

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.

Can't find your answer?

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 consultation

Most migrations land between six and ten weeks for master-data-focused scopes covering the COA, Customers, Suppliers, Items, and open AP/AR with no multi-year transactional history and no payroll data. Migrations including full historical order and invoice data, multi-warehouse inventory, payroll summaries, or Finance and Operations as the destination move to fourteen to twenty-two weeks because of the GL restructuring work, the payroll jurisdiction sign-off gate, and the Finance and Operations data entity configuration required before transactional data loads.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Herbst Insight ERP.
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