ERP migration

Migrate from Guardian Software to Epicor Prophet 21

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 logo

Guardian Software

Source

Epicor Prophet 21

Destination

Epicor Prophet 21 logo

Compatibility

100%

12 of 12

objects map 1:1 between Guardian Software and Epicor Prophet 21.

Complexity

BStandard

Timeline

6-8 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

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

Guardian Software logo

Guardian Software

What's pushing teams away

  • Rate limits and export capabilities are not publicly documented, making data portability and migration planning difficult without vendor engagement.
  • Absence of a self-service bulk API forces customers into professional-services engagements for any significant data extraction, increasing switching costs.
  • Reported challenges with retire pool migration in blockchain-integrated workflows create friction when modernizing or decommissioning hybrid deployments.

Choosing

Epicor Prophet 21 logo

Epicor Prophet 21

What's pulling them in

  • Industry-specific design for wholesale distributors, not a general-purpose ERP repurposed for distribution — distributors choose P21 because it matches their replenishment, kitting, and counter-sale workflows out of the box.
  • Strong inventory control with automated replenishment, lot and serial tracking, and multi-warehouse management appeals to distributors with complex stock requirements and tight margin pressure.
  • Responsive customer support cited across G2 and Gartner reviews, with Epicor's 90% retention rate reflecting long-term customer satisfaction in a market where switching costs are high.
  • Cloud deployment on Microsoft Azure provides the flexibility to scale user counts and warehouse locations without on-premise infrastructure investment.
  • The Software Development Kit lets distributors personalize P21 to their specific business processes without modifying the application source code, preserving upgrade paths.

Object mapping

How Guardian Software objects map to Epicor Prophet 21

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

maps to

Epicor Prophet 21

Customer and Account (CustCnt / CustForm)

1:1
Fully supported

Guardian 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

maps to

Epicor Prophet 21

Job and JobMtl (material) / JobOper (operation)

1:1
Fully supported

Guardian 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

maps to

Epicor Prophet 21

Part and PartBin / WarehouseBin

1:1
Fully supported

Guardian 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

maps to

Epicor Prophet 21

ECOGroup / QC and Inspection Data (via UD tables or Kinetic Quality module)

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

Equip and EquipMeter / Asset and AssetMaintenance

1:1
Fully supported

Guardian 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

maps to

Epicor Prophet 21

JobOper with Work Center Group and Resource

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

GL Account and Cost Center

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

UD fields and EF (extended field) tables

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

GLJrnDtl (journal detail)

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

PODetail and PORel

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

Document Management (DocReference) / EDMS

1:1
Mapping required

Guardian 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

maps to

Epicor Prophet 21

User and UserCodes / Role and Security

1:1
Mapping required

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

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.

Guardian Software logo

Guardian Software gotchas

High

No public bulk export API forces vendor-assisted extraction

Medium

Policy artefacts and state migration is partial for blockchain-integrated workflows

Low

Rate limits are undocumented and reported only in response headers

Epicor Prophet 21 logo

Epicor Prophet 21 gotchas

High

Third-party bolt-on integrations complicate migration scope

High

Dirty data without standardized processes compounds migration risk

Medium

SDK customizations and BPMs may not survive platform upgrades

Medium

Report-based export only for non-technical users

Low

Per-user pricing model requires accurate user count before migration planning

Pair-specific challenges

  • Vendor-assisted extraction required for Guardian production data

    Guardian Software does not publish a self-service bulk API for customers to independently extract production orders, material balances, or transactional history. Any migration involving full historical data requires coordinating a vendor-assisted extract window with Guardian Professional Services. This adds four to six weeks to the project schedule because the extraction must be scheduled, executed by Guardian's team, validated against on-screen totals, and delivered as a file or database export. We build this vendor engagement timeline into the project plan from day one and do not start the extraction phase until Guardian confirms the extract window. If Guardian's Professional Services bandwidth is constrained, the extract window can become a critical path item that delays the entire migration.

  • Foundry-specific cost pools require account mapping before journal migration

    Guardian stores foundry-specific cost pools (scrap, rework, tool wear, alloy loss) as native fields in the production order and journal entry tables. Epicor does not have equivalent native fields; these cost pools must be mapped to GL account codes in Epicor's chart of accounts. If the GL account structure is not finalized and created in Epicor before transactional data migration begins, journal entries referencing those accounts will fail import. We hold the journal entry phase until the customer signs off on the account mapping matrix and the accounts are live in Epicor. Migrations that skip this step end up with journal entries pointing to placeholder accounts or silent failures.

  • Work center codes must exist in Epicor before production order migration

    Guardian Production Orders reference work center codes that map to Epicor Resource Group and Resource records. If a Guardian work center code does not have a corresponding Epicor Resource Group, the JobOper records referencing that work center will fail import due to referential integrity errors. We audit the full set of Guardian work center codes during discovery, create the Epicor Resource Group and Resource records before the production order phase, and validate that all work center references are satisfied before loading any Job records. This validation step is a prerequisite gate that blocks the production order phase until resolved.

  • Epicor on-premise development sunsetting creates cloud migration pressure

    Epicor has announced the sunsetting of on-premise development for Kinetic, Prophet 21, and BisTrack, with Active Support continuing through December 31, 2029. If the customer's target Epicor deployment is on-premise Kinetic, the migration project has a defined endpoint for on-premise support. If the customer prefers a cloud deployment, the target shifts to Epicor Industry ERP Cloud (Epicor Kinetic Cloud), which requires additional scoping for cloud-specific configuration, tenant provisioning, and data center region selection. We clarify the deployment model with the customer during discovery so the migration plan targets the correct Epicor platform variant.

  • Custom objects and UD fields require pre-creation in Epicor schema

    Guardian foundry-specific custom fields and any user-defined data structures must be created in Epicor before any record migration. Epicor's schema does not auto-create custom fields on import; attempting to load records with custom field data into fields that do not exist results in data being silently dropped or import errors. We extract the full Guardian custom field manifest during discovery, create the equivalent Epicor UD fields and EF table entries in the destination org before migration begins, and validate the schema matches the source field list. This is a separate Epicor administration task that requires either a schema deployment via Epicor tools or manual field creation by the customer's Epicor admin.

Migration approach

Six steps for a successful Guardian Software to Epicor Prophet 21 data migration

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

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

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

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

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

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

Context on both ends of the pair

Guardian Software logo

Guardian Software

Source

Strengths

  • Deep foundry-specific ERP data model with industry-native cost structures and quality tracking built in.
  • Real-time visibility bridging shop-floor operations and financial ledgers for manufacturers.
  • Flexible workflow configuration allowing foundries to map processes to the platform rather than the reverse.
  • 30+ year track record with 80% reinvestment into product development signals ongoing platform investment.

Weaknesses

  • No publicly documented bulk API or self-service export mechanism for data extraction.
  • Vendor-assisted data pulls are required for significant migrations, increasing professional-services cost.
  • Export capabilities, rate limits, and API specifications are not publicly accessible.
Epicor Prophet 21 logo

Epicor Prophet 21

Destination

Strengths

  • Purpose-built for wholesale distribution with industry-specific replenishment, kitting, and counter-sale workflows out of the box.
  • Multi-warehouse management with bin locations, cross-docking, and real-time inventory visibility across all warehouse locations.
  • Automated replenishment engine with demand-based and min-max planning reduces stockouts and overstock carrying costs.
  • AI-infused reporting via Epicor Prism provides Gen AI-driven insights into ERP data without requiring a BI team.
  • Strong customer retention at 90% and a 50-year track record in the distribution vertical provides long-term vendor stability.

Weaknesses

  • High total cost of ownership — per-user pricing of $150-200/month plus $10K-$500K implementation creates significant budget commitment for small and mid-market distributors.
  • Customization via SDK requires technical expertise and introduces upgrade risk when custom code conflicts with new P21 releases.
  • Report generation performance is a known pain point — multiple users report system freezes during large or complex report exports.
  • Third-party bolt-on reliance for functionality that competitors include natively increases integration complexity and total solution cost.
  • Limited public API documentation — developers building custom integrations report difficulty finding P21 API authentication methods and endpoint specifications.

Complexity grading

How hard is this migration?

Standard ERP migration. 3 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Guardian Software and Epicor Prophet 21.

  • Object compatibility

    B

    3 of 8 objects need a mapping; the rest are 1:1.

  • 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

    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

    B

    Guardian Software doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Guardian Software to Epicor Prophet 21 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 Guardian Software to Epicor Prophet 21 data migrations

Answers to the questions buyers ask most during Guardian Software to Epicor Prophet 21 migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Migrations land between six and eight weeks for straightforward accounts with under 50,000 production orders, clean cost structures, and no multi-site Guardian deployment. Migrations with large historical transactional volumes, complex foundry-specific cost pools requiring multi-level account mapping, or significant custom field dictionaries move to fourteen to twenty-two weeks because of vendor-assisted extract coordination, data profiling, and work center routing validation. The Guardian vendor-assisted extract window alone adds four to six weeks to the schedule before any migration work begins.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Guardian Software.
Land in Epicor Prophet 21, 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