ERP migration
Field-level mapping, validation, and rollback between Guardian Software and Epicor Prophet 21. We move data and schema; workflows are rebuilt natively in Epicor Prophet 21.
Guardian Software
Source
Epicor Prophet 21
Destination
Compatibility
12 of 12
objects map 1:1 between Guardian Software and Epicor Prophet 21.
Complexity
BStandard
Timeline
6-8 weeks
Overview
Moving from Guardian Software to Epicor ERP is a platform-level migration that requires bridging a foundry-specific ERP schema built for metal casting manufacturers against Epicor's broad manufacturing ERP designed for make-move-sell operations. Guardian stores production orders, material balances, quality records, and equipment assets in relational tables with industry-native cost pools (scrap, rework, tool wear) that have no direct Epicor equivalent; we resolve these through account-code mapping tables and custom field creation before load. The critical path on the source side is the absence of a self-service bulk export API: every significant data extraction from Guardian requires coordinating a vendor-assisted extract window with Guardian Professional Services, which adds four to six weeks to the migration schedule. We build that vendor engagement timeline into the project plan upfront so the extraction window does not become a blocker. Epicor's REST and Bulk APIs handle the destination load with rate-limit handling and batch chunking. Workflows, automations, and production scheduling rules do not migrate as code; we deliver a written inventory for the customer's Epicor administrator to rebuild in Kinetic.
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.
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 Epicor Prophet 21, 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
Epicor Prophet 21
Customer and Account (CustCnt / CustForm)
1:1Guardian Customer records with address, contact details, and customer type classification map to Epicor's Customer (CustCnt) and Customer Ship To (CustShip) entities. The customer's primary contact person becomes the CustCnt record with the company-level details in CustForm. We remap Guardian customer type codes (foundry-specific classifications) to Epicor customer groups via a mapping table created during scoping.
Guardian Software
Production Order
Epicor Prophet 21
Job and JobMtl (material) / JobOper (operation)
1:1Guardian Production Orders map to Epicor Job records with order status, quantity, schedule dates, and work center assignments. Each Production Order's material requirements map to JobMtl lines and its routing steps map to JobOper records. We validate that Guardian work center codes exist in Epicor's Resource Group table before migration; any unmapped work centers are flagged for the customer's Epicor admin to provision before the production order phase begins.
Guardian Software
Materials and Inventory
Epicor Prophet 21
Part and PartBin / WarehouseBin
1:1Guardian raw materials, alloys, and finished castings map to Epicor Part records with the Part Type set to Mfg (manufactured) or Purchased as appropriate. Inventory balances by location map to PartBin or WarehouseBin entries. Unit-of-measure conversions (Guardian's foundry-specific UOMs for weight and volume) are resolved via Epicor's UOMClass and UOMConv tables. Alloys and scrap materials require Part-plant configuration to ensure costing applies correctly in Epicor's inventory layer.
Guardian Software
Quality Records
Epicor Prophet 21
ECOGroup / QC and Inspection Data (via UD tables or Kinetic Quality module)
1:1Guardian Quality Records with inspection results, non-conformance reports, and certificates of conformance map to Epicor's Engineering Change Order (ECO) structure for non-conformance tracking or to Kinetic Quality module entities if that module is licensed. Quality codes and disposition statuses require a mapping table because Guardian uses foundry-specific quality codes that Epicor models as either inspection types or UD (user-defined) custom fields. We recommend validating whether the customer licenses Epicor Kinetic Quality before migration so we scope UD table creation versus native quality object mapping accordingly.
Guardian Software
Equipment and Assets
Epicor Prophet 21
Equip and EquipMeter / Asset and AssetMaintenance
1:1Guardian Equipment and Asset records (machines, furnaces, tooling) map to Epicor Asset and Equip records with maintenance schedules, depreciation data, and location assignments. Tooling assets with wear tracking map to Equip records with linked EquipMeter entries for cycle counts. Depreciation data migrates as AssetMaintenance records. We verify that Guardian asset classifications map to Epicor asset groups and that any insurance or location data in Guardian moves to custom fields or UD tables in Epicor.
Guardian Software
Work Center Routing
Epicor Prophet 21
JobOper with Work Center Group and Resource
1:1Guardian Work Center Routing (step-by-step routing of production orders through work centers with labor hours, machine hours, and sequence) maps to Epicor JobOper records with Operation Sequence, Work Center Group assignment, and Resource requirement. Foundry process types (molding, melting, pouring, finishing) are mapped to Epicor Resource Groups. Cycle-time and setup-time fields migrate to OpStds (operation standards) records. Routing structures vary by foundry process type, so we validate step count and cycle-time totals against Guardian's reported values during the sandbox migration.
Guardian Software
Chart of Accounts
Epicor Prophet 21
GL Account and Cost Center
1:1Guardian Chart of Accounts with foundry-specific cost pools (scrap, rework, tool wear, alloy loss) requires a multi-level account mapping to Epicor's GL Account structure. Each Guardian cost pool maps to one or more Epicor GL accounts depending on the customer's desired granularity in Epicor reporting. We create a written account mapping matrix during scoping that the customer's accountant reviews before migration; Epicor GL accounts are created before any transaction data loads to ensure referential integrity.
Guardian Software
Custom Fields
Epicor Prophet 21
UD fields and EF (extended field) tables
1:1Guardian custom fields on standard objects (foundry-specific tracking properties) migrate to Epicor User-Defined (UD) fields on the corresponding tables or to EF extended field tables if the kinetic schema supports it. Custom field data types are mapped to Epicor field types (character, numeric, date, checkbox). Complex formula fields from Guardian are flagged for manual rebuild in Epicor Kinetic calculated fields or Epicor Functions. We extract the full custom field manifest from Guardian during discovery and pre-create the destination fields in Epicor before any record migration begins.
Guardian Software
Journal Entries
Epicor Prophet 21
GLJrnDtl (journal detail)
1:1Guardian historical journal entries for cost accounting and period closes migrate to Epicor GLJrnDtl records with entry headers mapped to GLJrnGrp. We extract entry headers and line items, preserving reversing entries and adjustment flags. Foundry-specific journal types (alloy variance, scrap journal, tool wear amortization) require account mapping to Epicor's GL code structure. Period-close status from Guardian is preserved as a reference note on the migrated entries. We recommend migrating a rolling 24-month window of open and recent closed periods to limit migration scope and archive older periods to a separate data store.
Guardian Software
Purchase Orders
Epicor Prophet 21
PODetail and PORel
1:1Guardian Purchase Order headers with line items, quantities, prices, and vendor assignments map to Epicor PODetail records. Vendor cross-references are remapped to Epicor's Vendor table (VendCnt) based on a vendor mapping table built during scoping. Open PO releases map to PORel records with scheduled dates and quantities. Closed POs migrate as reference records only; we do not recreate closed PO lifecycle events in Epicor. Any Guardian-specific PO types (alloy PO, tooling PO, maintenance PO) are mapped to Epicor's PO types via a classification lookup.
Guardian Software
Documents
Epicor Prophet 21
Document Management (DocReference) / EDMS
1:1Guardian Documents (engineering drawings, batch sheets, compliance certificates) are exported as file attachments and re-associated in Epicor through DocReference records linked to the parent entity (Part, Job, Customer, or Vendor). File names and version metadata are preserved in the DocReference description and URL fields. For customers using Epicor's EDMS (Electronic Document Management System), we map documents to EDMS folders with the appropriate classification. PDF/A compliance certificates are stored as-is; binary formats are converted to PDF where Epicor rendering requires it.
Guardian Software
Users and Roles
Epicor Prophet 21
User and UserCodes / Role and Security
1:1Guardian User accounts with role-based access control map to Epicor User records with UserCodes for role classification. Role names and permission sets vary between Guardian and Epicor, so we map Guardian role hierarchies to Epicor Kinetic Security Groups during scoping. We recommend a post-migration access review workshop where the customer's Epicor admin aligns Guardian roles to Epicor Kinetic security groups with reference to the written role inventory we deliver. Active and inactive status is preserved; inactive users are migrated with status set to inactive and migrated login disabled pending reactivation by the admin.
| Guardian Software | Epicor Prophet 21 | Compatibility | |
|---|---|---|---|
| Customer | Customer and Account (CustCnt / CustForm)1:1 | Fully supported | |
| Production Order | Job and JobMtl (material) / JobOper (operation)1:1 | Fully supported | |
| Materials and Inventory | Part and PartBin / WarehouseBin1:1 | Fully supported | |
| Quality Records | ECOGroup / QC and Inspection Data (via UD tables or Kinetic Quality module)1:1 | Mapping required | |
| Equipment and Assets | Equip and EquipMeter / Asset and AssetMaintenance1:1 | Fully supported | |
| Work Center Routing | JobOper with Work Center Group and Resource1:1 | Mapping required | |
| Chart of Accounts | GL Account and Cost Center1:1 | Mapping required | |
| Custom Fields | UD fields and EF (extended field) tables1:1 | Mapping required | |
| Journal Entries | GLJrnDtl (journal detail)1:1 | Mapping required | |
| Purchase Orders | PODetail and PORel1:1 | Mapping required | |
| Documents | Document Management (DocReference) / EDMS1:1 | Mapping required | |
| Users and Roles | User and UserCodes / Role and Security1: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.
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
Epicor Prophet 21 gotchas
Third-party bolt-on integrations complicate migration scope
Dirty data without standardized processes compounds migration risk
SDK customizations and BPMs may not survive platform upgrades
Report-based export only for non-technical users
Per-user pricing model requires accurate user count before migration planning
Pair-specific challenges
Migration approach
Discovery and vendor extract coordination
We audit the Guardian source environment across all supported objects (Customers, Production Orders, Materials, Quality Records, Equipment, Work Centers, Chart of Accounts, Journal Entries, Purchase Orders, Documents, Users, and custom fields). We map the Guardian schema to Epicor's equivalent entities, identify work center codes, cost pool codes, and custom field definitions. Simultaneously, we initiate the vendor-assisted extract engagement with Guardian Professional Services to schedule the bulk data extraction window. The discovery output is a written migration scope, a Guardian-to-Epicor object mapping document, and a confirmed extract delivery date from Guardian. Without the extract window confirmed, we cannot finalize the migration schedule.
Epicor schema provisioning and account structure design
We design the destination Epicor schema in a sandbox or staging environment. This includes provisioning Resource Groups and Resources for each Guardian work center, creating GL account codes mapped from Guardian's cost pools (scrap, rework, tool wear, alloy loss), creating UD fields for foundry-specific custom field equivalents, and configuring Part types and Part-plant settings for materials and inventory. We coordinate with the customer's Epicor administrator to deploy these changes via Epicor's configuration tools. The GL account structure must be finalized and live in Epicor before any journal entry or transactional data is loaded.
Vendor-assisted extract intake and data profiling
Guardian delivers the bulk extract (typically as a database export, CSV files, or API response bundle) to the customer's environment. We validate the extract against Guardian's reported row counts for each object, profile the data for quality issues (duplicate records, missing required fields, date format inconsistencies, orphaned foreign keys), and build the transformation logic that maps Guardian field values to Epicor field values. Data profiling typically surfaces 15-30 percent of records requiring some form of cleansing or mapping correction before they can load cleanly into Epicor.
Sandbox migration and reconciliation
We run a full migration into the Epicor staging or sandbox environment using production-like data volume. The customer's Epicor administrator reconciles record counts for each object (customers in, production orders in, materials in, journal entries in), spot-checks 25-50 records per object against the Guardian source, and validates that cost pool mappings and work center assignments are correct. Any mapping corrections are applied and a second sandbox migration is run before production migration begins. Sandbox sign-off from the customer's administrator is a required gate before production cutover.
Production migration in dependency order
We run production migration in record-dependency order: GL accounts (created in step 2, validated), Customers and Vendors (master data, no dependencies), Parts and Inventory, Resource Groups and Resources, Equipment and Assets, Production Orders (with work center references validated), Journal Entries, Purchase Orders, Quality Records, Documents, Custom Field data, and finally User accounts. Each phase emits a row-count reconciliation report before the next phase begins. Epicor's Bulk API handles high-volume loads with batch chunking and rate-limit backoff. Any records that fail import are logged to an exception report and reprocessed after root cause analysis.
Cutover, validation, and automation rebuild handoff
We coordinate a data freeze window with the customer's operations team. A final delta migration captures any Guardian records modified between the last full migration and the freeze timestamp. We then enable Epicor as the system of record and decommission Guardian write access. We deliver the written inventory of Guardian automations, production scheduling rules, and custom workflows requiring rebuild in Epicor Kinetic. We do not rebuild these as Epicor Kinetic workflows inside the migration scope; that is a separate engagement or an internal Epicor administrator task. We support a one-week hypercare window for reconciliation issues raised during the first week of Epicor production use.
Platform deep dives
Guardian Software
Source
Strengths
Weaknesses
Epicor Prophet 21
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 3 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 Epicor Prophet 21.
Object compatibility
3 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 Epicor Prophet 21 migration scoping. Not seeing yours? Book a call.
Walk through your Guardian Software to Epicor Prophet 21 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 Epicor Prophet 21
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.