ERP migration
Field-level mapping, validation, and rollback between Guardian Software and Microsoft Dynamics 365 Business Central. We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Business Central.
Guardian Software
Source
Microsoft Dynamics 365 Business Central
Destination
Compatibility
9 of 13
objects map 1:1 between Guardian Software and Microsoft Dynamics 365 Business Central.
Complexity
BStandard
Timeline
6-10 weeks
Overview
Moving from Guardian Software to Microsoft Dynamics 365 is a manufacturing ERP migration that requires coordinating vendor-assisted data extraction on the source side while designing a production-enabled destination schema on the Dynamics 365 Finance & Operations or Business Central side. Guardian Software does not publish a self-service bulk export API, so we build a vendor engagement timeline into every migration plan from the outset and coordinate PostgreSQL exports via the customer's IT team where partial self-service is available. We map foundry-specific cost pools (scrap, rework, tool wear) to equivalent general-ledger account structures in Dynamics 365, preserve production order routing through work centers and operations resources, and transfer quality record dispositions to Dynamics quality management modules. Historical journal entries, inventory balances, and equipment asset records with depreciation schedules move as typed records with parent-record lookups resolved at migration time. Workflows, approval chains, and manufacturing intelligence dashboards do not migrate; we deliver a written inventory of these for the customer's Dynamics 365 partner to rebuild.
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
Guardian Software platform overview
Scorecard, SWOT, gotchas, and pricing for Guardian Software.
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 Guardian Software 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.
Guardian Software
Customer
Microsoft Dynamics 365 Business Central
Customer (Business Central) or CustTable (Finance & Ops)
1:1Guardian Customer records with address, contact details, and classification map to Business Central Customer or Finance & Operations CustTable. Customer number from Guardian becomes the account code; payment terms and customer posting groups are mapped via a configuration table before import. Multi-address customers (invoice vs delivery) require the Dynamics 365 address-role model to be active on the destination, as Finance & Ops allows multiple address purposes per customer.
Guardian Software
Production Order
Microsoft Dynamics 365 Business Central
Production Order (Business Central) or Production Order (Finance & Ops)
1:1Guardian Production Orders map to Dynamics 365 Production Orders with order status, quantity, scheduled dates, and work-center routing transferred as typed records. The Guardian production-order number becomes the ProdId; routing steps from Guardian's Work Center Routing map to Operations in Dynamics 365 Finance & Ops or to the Production BOM and Routing in Business Central. Where Guardian stores furnace-specific heat numbers and batch IDs, these transfer to the Production Order's lot or serial number field.
Guardian Software
Materials and Inventory
Microsoft Dynamics 365 Business Central
Item (Business Central) or InventTable (Finance & Ops)
1:1Guardian raw material, alloy, and finished casting inventory records map to Dynamics 365 Item or InventTable with unit-of-measure conversions preserved via the item's unit-of-measure group. Current inventory balances (quantity and value) migrate as inventory on-hand journal entries posted to the appropriate location and warehouse codes. Bin-level location data from Guardian maps to the Dynamics 365 warehouse location hierarchy if the destination uses multi-bin inventory.
Guardian Software
Quality Records
Microsoft Dynamics 365 Business Central
Quality Association (Finance & Ops) or Quality Management (Business Central)
1:1Guardian Quality Records with inspection results, non-conformance codes, and certificates of conformance map to Dynamics 365 Quality Management entities. Inspection characteristics from Guardian transfer as Quality Association test variables; disposition status (accept, reject, rework) maps to the corresponding Dynamics 365 disposition codes. Attachments (PDFs, CoCs) migrate as document attachments linked to the quality record via SharePoint or the native attachments model.
Guardian Software
Equipment and Assets
Microsoft Dynamics 365 Business Central
Fixed Asset (Business Central) or Asset Table (Finance & Ops)
1:1Guardian Equipment records with maintenance schedules, depreciation data, and location assignments map to Dynamics 365 Fixed Assets. Acquisition cost, depreciation method, useful life, and location from Guardian transfer to the Fixed Asset card fields. Maintenance schedules migrate as Asset Service Tasks with recurrence patterns preserved. Any Guardian asset linked to a production order carries the asset reference forward into the Operations resource assignment.
Guardian Software
Work Center Routing
Microsoft Dynamics 365 Business Central
Work Center (Finance & Ops) or Work/Jachine Center (Business Central)
lossyGuardian Work Center Routing with step sequences, labor hours, machine hours, and setup times maps to the Operations Resource Group and Resource model in Finance & Ops, or Work/Machine Centers in Business Central. Step count, cycle time, and route operations transfer as typed routing records. Foundry-specific resource groups (furnace, pour, shakeout, heat treat) map to Resource Groups with capacity calendars configured per work-center availability.
Guardian Software
Chart of Accounts
Microsoft Dynamics 365 Business Central
G/L Account (Business Central) or Ledger (Finance & Ops)
lossyGuardian account codes and cost-center structures for financial integration require a configuration mapping table before migration. Foundry-specific cost pools (scrap cost, rework cost, tool wear) must map to G/L accounts in Dynamics 365 to maintain GL continuity in the destination. We extract the full Guardian cost-center hierarchy, map each code to a Dynamics 365 account, and validate total period balances post-import. Account validation against the Guardian trial balance is a required gate before production migration.
Guardian Software
Users and Roles
Microsoft Dynamics 365 Business Central
User (Azure AD) + Security Roles
lossyGuardian user accounts with role-based access control map to Azure Active Directory (Entra ID) users in the Dynamics 365 tenant. Role names and permission sets vary between Guardian and Dynamics 365, so we produce a role-mapping matrix during discovery and recommend a post-migration access review with the customer's security admin. We do not provision the Entra ID users themselves; we provide the role matrix and the customer provisions the identities.
Guardian Software
Custom Fields
Microsoft Dynamics 365 Business Central
Custom Fields or Extensions
lossyGuardian user-defined fields on standard objects (alloys, heat codes, foundry lot numbers, scrap codes) are extracted with their data types, picklist values, and parent object. We create equivalent custom fields in Dynamics 365 using the extension model (AL extensions in Business Central; DevTools extensions in Finance & Ops) and map the values during migration. Complex formula fields from Guardian require re-implementation as computed columns or Power BI measures, which is documented separately.
Guardian Software
Journal Entries
Microsoft Dynamics 365 Business Central
General Journal Lines (Business Central) or Ledger Entries (Finance & Ops)
1:1Historical journal entries for cost accounting and period closes transfer as general journal batches with header and line structure preserved. Entry date, account, debit, credit, and description migrate directly. Reversing entries and adjustment flags are preserved where supported by the destination posting model. Deep historical data (more than 5 fiscal years) is typically scoped as an archive read-only migration or left in the Guardian database for reference, per the customer's data retention policy.
Guardian Software
Purchase Orders
Microsoft Dynamics 365 Business Central
Purchase Order (Business Central) or PurchTable (Finance & Ops)
1:1Open and closed PO headers with line items, quantities, prices, and vendor assignments migrate to Dynamics 365 Purchase Orders. Guardian vendor cross-references are remapped to the destination vendor account codes resolved during the vendor mapping phase. Receipt and invoice matching status from Guardian transfers to the corresponding Dynamics 365 posting status fields. Closed POs migrate with their final receipt quantities for historical reporting continuity.
Guardian Software
Documents
Microsoft Dynamics 365 Business Central
Document Attachments or SharePoint
1:1Engineering drawings, batch sheets, compliance certificates, and operator logs stored as file attachments in Guardian migrate alongside their parent records and re-associate in Dynamics 365 via the document handling model. Filename and file type are preserved; file size and content are verified against a hash during import. We recommend SharePoint document management for the destination to align with Microsoft 365 integration, and we configure the SharePoint document location on the relevant entity.
Guardian Software
Bill of Materials
Microsoft Dynamics 365 Business Central
Production BOM (Business Central) or BOM (Finance & Ops)
1:1Guardian BOM structures for casting recipes, alloy ratios, and material compositions transfer to Dynamics 365 BOM versions with line items mapped to the migrated Item records. BOM quantities, scrap percentages, and routing consumption factors are preserved. Where Guardian stores version-controlled BOMs, the Dynamics BOM version number and status fields are populated to maintain engineering revision history.
| Guardian Software | Microsoft Dynamics 365 Business Central | Compatibility | |
|---|---|---|---|
| Customer | Customer (Business Central) or CustTable (Finance & Ops)1:1 | Fully supported | |
| Production Order | Production Order (Business Central) or Production Order (Finance & Ops)1:1 | Fully supported | |
| Materials and Inventory | Item (Business Central) or InventTable (Finance & Ops)1:1 | Fully supported | |
| Quality Records | Quality Association (Finance & Ops) or Quality Management (Business Central)1:1 | Mapping required | |
| Equipment and Assets | Fixed Asset (Business Central) or Asset Table (Finance & Ops)1:1 | Fully supported | |
| Work Center Routing | Work Center (Finance & Ops) or Work/Jachine Center (Business Central)lossy | Mapping required | |
| Chart of Accounts | G/L Account (Business Central) or Ledger (Finance & Ops)lossy | Mapping required | |
| Users and Roles | User (Azure AD) + Security Roleslossy | Mapping required | |
| Custom Fields | Custom Fields or Extensionslossy | Mapping required | |
| Journal Entries | General Journal Lines (Business Central) or Ledger Entries (Finance & Ops)1:1 | Mapping required | |
| Purchase Orders | Purchase Order (Business Central) or PurchTable (Finance & Ops)1:1 | Mapping required | |
| Documents | Document Attachments or SharePoint1:1 | Mapping required | |
| Bill of Materials | Production BOM (Business Central) or BOM (Finance & Ops)1:1 | 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.
Guardian Software gotchas
No public bulk export API forces vendor-assisted extraction
Policy artefacts and state migration is partial for blockchain-integrated workflows
Rate limits are undocumented and reported only in response headers
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 extraction planning
We audit the Guardian environment across editions (Advantage, Foundry), custom fields, production order history, inventory locations, cost-center structure, journal entry volumes, equipment records, and active user count. We identify every object that requires extraction and confirm the Guardian vendor engagement timeline for any extract that requires professional services. The discovery output is a written migration scope document listing record counts per object, extraction method (vendor-assisted or PostgreSQL self-service), and a recommended Dynamics 365 edition (Business Central Essentials/Premium or Finance & Operations) based on the customer's user count, manufacturing complexity, and integration targets.
Chart-of-accounts and cost-structure mapping
We extract the Guardian chart of accounts and cost-center hierarchy, then design the Dynamics 365 G/L account structure with the customer's finance team. Each foundry-specific cost pool (scrap, rework, tool wear) receives a mapped G/L account with the correct posting group assignment. We validate the draft mapping against the Guardian trial balance for the most recent closed period. This step gates production migration because any account mapping error propagates into inventory valuation and COGS reporting post-go-live.
Destination schema design and sandbox provisioning
We design the Dynamics 365 destination schema in a Sandbox environment: production warehouses and locations, work center groups and resource calendars, item units of measure and costing methods, quality management parameters, fixed asset classes and depreciation books, and any custom fields for foundry-specific tracking. We configure BOM structures, production order types, and the manufacturing posting profile. The customer validates the sandbox configuration with their operations team before we proceed to data migration.
Data profiling and cleansing workstream
We run full data extraction from Guardian (coordinating with Guardian professional services as required), load it into a staging environment, and profile for duplicates, missing required fields, inconsistent naming, inactive records linked to open balances, and cost-center usage drift. We generate exception reports and deliver them to the customer for remediation. Common remediation actions include de-duplicating vendor records, archiving items with zero on-hand and no open POs, and resolving inactive accounts tied to historical journal entries. Data cleansing is a parallel workstream; it does not block schema design but it gates the production migration.
Sandbox migration and reconciliation
We run a full migration into the Dynamics 365 Sandbox using production-like data volume. The customer's operations and finance leads reconcile record counts (items in, production orders in, fixed assets in, journal entries in), spot-check 30-50 records against the Guardian source data, and validate cost-account balances against the trial balance. Any mapping corrections, validation rule failures, or missing field translations surface here. The customer signs off the sandbox migration before we schedule the production cutover date.
Production migration and cutover
We run the production migration in dependency order: master data first (chart of accounts, vendors, customers, items, fixed assets), then transactional data (production orders, BOMs, routings, purchase orders), then balances and history (inventory on-hand journal entries, open work orders, journal entries for the current and prior fiscal year). We freeze Guardian write access during cutover, run a final delta migration of any records modified during the cutover window, post the inventory and GL opening balances, and hand the system to the customer's admin team. We deliver the workflow inventory document and a one-week hypercare window for reconciliation issues.
Platform deep dives
Guardian Software
Source
Strengths
Weaknesses
Microsoft Dynamics 365 Business Central
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 2 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 Guardian Software and Microsoft Dynamics 365 Business Central.
Object compatibility
2 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
Guardian Software: Not publicly documented — API specifications are not published; no developer portal or public rate limit reference found in the research corpus..
Data volume sensitivity
Guardian Software 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 Guardian Software to Microsoft Dynamics 365 Business Central migration scoping. Not seeing yours? Book a call.
Walk through your Guardian Software 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 Guardian Software
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.