ERP migration
Field-level mapping, validation, and rollback between Freedom ERP and Epicor Prophet 21. We move data and schema; workflows are rebuilt natively in Epicor Prophet 21.
Freedom ERP
Source
Epicor Prophet 21
Destination
Compatibility
13 of 15
objects map 1:1 between Freedom ERP and Epicor Prophet 21.
Complexity
BStandard
Timeline
6-10 weeks
Overview
Moving from Freedom ERP to Epicor ERP is a database-first migration: Freedom ERP has no documented public REST or SOAP API, so we extract directly from the underlying relational schema via read-only database access or module-level CSV exports. Epicor ERP (specifically Kinetic for mid-market discrete manufacturers) exposes a REST API for data ingestion, which we use for the destination load. The migration requires reconstructing multi-level BOMs, resolving operation and work-center routing in Production Orders, mapping the Freedom chart of accounts to Epicor GL accounts, and auditing every custom field added during Freedom implementation for UDF equivalence in Epicor Kinetic. We do not migrate Freedom ERP workflows, automations, or document file stores as code; we deliver written inventories for the customer's admin to rebuild in Epicor 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 Freedom ERP 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.
Freedom ERP
Customer
Epicor Prophet 21
Customer
1:1Freedom ERP Customer records map to Epicor Kinetic Customer with phone, address, and GST details preserved. The Freedom customer code becomes Epicor Kinetic's Customer ID or part of a composite key, and we preserve the GST registration number in the tax registration field. Customer credit limits and payment terms migrate as Epicor Kinetic Customer credit and terms records. We resolve any cross-references from open Sales Orders or Delivery Notes to Customer before import so the Customer record exists prior to any related transactional record.
Freedom ERP
Vendor
Epicor Prophet 21
Supplier
1:1Freedom ERP Vendor master data maps to Epicor Kinetic Supplier with contact info, payment terms, and tax registration preserved. Vendor-linked PO history and GRN records require Supplier to be imported before PO and receipt records. We map the Freedom vendor code to Epicor Kinetic Supplier ID and preserve any PAN or GSTIN registration in the tax registration fields. Payment terms from Freedom map to Epicor Kinetic terms codes, which may require a lookup table if term labels differ between systems.
Freedom ERP
Item
Epicor Prophet 21
Part
1:1Freedom ERP Items (raw materials, intermediates, finished goods) map to Epicor Kinetic Part records with unit of measure, standard cost, and warehouse assignment preserved. The Freedom item code maps to Epicor Kinetic Part Number. We extract Item-UOM conversion factors and map them to Epicor Kinetic's UOMClass and UOM conversions. Stock quantities per warehouse migrate as PartBin records. Item planning parameters (reorder point, safety stock, min/max) map to Epicor Kinetic's planning fields if configured in Freedom.
Freedom ERP
Bill of Materials
Epicor Prophet 21
Part BOM
1:1Freedom ERP BOMs define multi-level product structures with component quantities, scrap rates, phantom assembly flags, and co-product definitions. We extract the full BOM tree from Freedom, reconstruct it as Epicor Kinetic Part BOM records, and map each level to Epicor's BOMRevision and BOMLine structure. Phantom assemblies in Freedom map to Epicor Kinetic phantom BOMs. Scrap rates and operation yield percentages migrate to the respective BOM line fields. This step adds a planning day to the migration scope because BOM correctness directly affects production costing downstream.
Freedom ERP
Chart of Accounts
Epicor Prophet 21
GL Account
1:1Freedom ERP accounts with account type, group, and GST/S-tax mapping migrate to Epicor Kinetic GL Account structure. We export the full COA from Freedom, map account codes and names, and import into Epicor Kinetic's chart of accounts. Cost-center assignments where configured migrate as Epicor Kinetic Department or Cost Center codes. If Freedom uses a different account code length or segment structure than Epicor Kinetic, we flag the segment mismatch and propose a mapping strategy before import.
Freedom ERP
Open AP/AR
Epicor Prophet 21
AP Invoice / AR Invoice
1:1Outstanding payables and receivables from Freedom ERP include invoice-level detail with due dates, amounts, and GST/S-tax tax breakdown. We export open invoices, match supplier and customer references to the migrated Supplier and Customer records, and create Epicor Kinetic AP and AR open invoice records. GST tax codes from Freedom require a tax code mapping table in Epicor Kinetic before AP/AR import can proceed. Closed historical invoices migrate as AP/AR history records if the scope includes historical financial data.
Freedom ERP
Production Order
Epicor Prophet 21
Job
1:1Freedom ERP Production Orders link to BOMs, work centers, operation sequences, and scheduling dates. We extract work orders with full operation routing, map work center assignments to Epicor Kinetic Resource Groups and Resources, and preserve scheduled start and end dates. The migration maps Freedom production order status to Epicor Kinetic Job status (released, complete, closed). If Freedom uses process manufacturing mode, we assess whether to map to Epicor Kinetic Jobs or Process Jobs based on the destination configuration. Job material requirements (JobMtl) are populated from the linked BOM.
Freedom ERP
Employee
Epicor Prophet 21
Employee
1:1Freedom ERP Employee records include personal details, department, designation, date of joining, and org hierarchy. We export all active and inactive employee records and map to Epicor Kinetic Employee, preserving department assignments and reporting relationships. Employee addresses and contact details migrate as Epicor Kinetic Employee contact information. If Freedom stores employee照片 or documents, we flag these for manual migration to Epicor Kinetic's document management since no export API exists.
Freedom ERP
Payroll Records
Epicor Prophet 21
Payroll / Labor
1:1Freedom ERP payroll data includes salary components, deductions, payrun history, and earnings per employee. Epicor Kinetic handles payroll through its HRMS module or integration with a dedicated payroll product, not as a core ERP transaction. We export payrun summaries and individual earning records from Freedom ERP as structured historical records, but post-migration payroll setup in Epicor Kinetic HRMS is scoped separately because Epicor's payroll module requires distinct configuration and often a separate implementation phase. We preserve a payroll history export file for the customer's HR team to enter into Epicor Kinetic HRMS or a connected payroll system.
Freedom ERP
Quality Control Records
Epicor Prophet 21
QA/QC Inspection
1:1Freedom ERP QC inspection records link to production lots and item batches with inspection results, measured values, and defect logs. We extract inspection records and map them to Epicor Kinetic's QA module where available in the target edition. Custom inspection criteria fields from Freedom map to Epicor Kinetic UDF fields on the inspection record. Not all Epicor Kinetic editions include the full QA/QC module; we verify edition inclusion during scoping and flag any gap as a separate configuration item.
Freedom ERP
Maintenance Records
Epicor Prophet 21
Asset Maintenance
1:1Equipment and machine maintenance logs from Freedom ERP include work orders, spare parts consumed, technician assignments, and labor hours. We export maintenance history and map to Epicor Kinetic's Asset Management module as Asset Downtime and Maintenance records. Linked spare parts migrate as Part transactions against the asset. Technician assignments map to Epicor Kinetic Resource or Employee assignments depending on the destination configuration.
Freedom ERP
Project
Epicor Prophet 21
Project
1:1Freedom ERP Project module stores project definitions, milestones, tasks, WBS entries, and resource assignments. We extract project structures and remap them to Epicor Kinetic Project, preserving task dependencies, milestone dates, and billing information. Project accounting and revenue recognition configurations require separate setup in Epicor Kinetic because the financial posting rules differ from Freedom ERP's project accounting model.
Freedom ERP
Gate Entry Logs
Epicor Prophet 21
Inventory Transaction Log
1:1Gate entry records from Freedom ERP track inward and outward material movement with vehicle, challan, and material details. We export gate entry logs as structured records and map them to Epicor Kinetic inventory transactions (receipts and shipments) linked to the relevant PO or SO. The vehicle number, challan reference, and material description migrate as transaction-level notes or UDF fields since Epicor Kinetic does not have a native gate-entry object.
Freedom ERP
Custom Fields and Custom Tables
Epicor Prophet 21
UDF / User Defined Fields
lossyFreedom ERP custom fields and non-standard tables added during implementation require manual audit before export. We scan the production database for columns and tables that do not appear in the standard Freedom ERP schema, flag each custom field with its table, column name, and data type, then map to Epicor Kinetic UD fields. Epicor Kinetic UD fields require configuration in the UD Service Designer or via BPM for data population, which adds a schema build phase before data migration. This step is the primary source of migration timeline uncertainty when Freedom ERP has extensive customizations.
Freedom ERP
Documents and Attachments
Epicor Prophet 21
Content / Media
lossyFreedom ERP documents stored in the application file store—PDFs, images, scanned files—have no exposed export API. We document all file locations referenced in the Freedom ERP database and provide a file inventory list to the customer for manual upload to Epicor Kinetic Content and Media storage. This is a manual step post-migration and does not migrate as part of the automated data migration scope.
| Freedom ERP | Epicor Prophet 21 | Compatibility | |
|---|---|---|---|
| Customer | Customer1:1 | Fully supported | |
| Vendor | Supplier1:1 | Fully supported | |
| Item | Part1:1 | Fully supported | |
| Bill of Materials | Part BOM1:1 | Mapping required | |
| Chart of Accounts | GL Account1:1 | Fully supported | |
| Open AP/AR | AP Invoice / AR Invoice1:1 | Mapping required | |
| Production Order | Job1:1 | Fully supported | |
| Employee | Employee1:1 | Fully supported | |
| Payroll Records | Payroll / Labor1:1 | Mapping required | |
| Quality Control Records | QA/QC Inspection1:1 | Mapping required | |
| Maintenance Records | Asset Maintenance1:1 | Mapping required | |
| Project | Project1:1 | Fully supported | |
| Gate Entry Logs | Inventory Transaction Log1:1 | Mapping required | |
| Custom Fields and Custom Tables | UDF / User Defined Fieldslossy | Fully supported | |
| Documents and Attachments | Content / Medialossy | Not 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.
Freedom ERP gotchas
No public API requires direct database migration path
Custom fields stored outside standard tables
Large data volumes trigger performance degradation
BOM and routing complexity varies by manufacturing mode
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 database access setup
We audit the Freedom ERP production database or module-level CSV exports across all modules in scope. We document the database schema version, identify standard and non-standard tables, extract record counts per object, and assess custom field usage by scanning for columns outside the base Freedom ERP schema. We confirm the database hosting arrangement and obtain read-only credentials. The discovery output is a written migration scope with a custom field inventory, BOM complexity assessment, and GL account structure map.
Custom field audit and UDF schema design
We build the Epicor Kinetic UDF schema to receive Freedom ERP custom fields. Each Freedom custom column identified in discovery maps to an Epicor Kinetic UD field with the appropriate data type (string, number, date, checkbox). We design the BPM logic required to populate each UD field or document the requirement for the customer's Epicor partner to build post-migration. This step is the primary source of timeline variability for heavily customized Freedom ERP instances.
BOM tree reconstruction and routing design
We extract the full BOM hierarchy from Freedom ERP including multi-level structures, phantom assemblies, and co-product definitions. We map each BOM level to Epicor Kinetic Part BOM revision records, resolve work center assignments, and configure scrap rates and operation yields. We produce a BOM mapping document that the customer reviews and approves before the BOM import phase begins. Routing data (operation sequences, work centers, machine assignments) maps to Epicor Kinetic JobOper and ResourceGroup records.
GL account mapping and tax code configuration
We export the Freedom ERP Chart of Accounts and map account codes, names, groups, and GST/S-tax assignments to Epicor Kinetic GL accounts. We configure Epicor Kinetic tax codes to match Freedom's GST/S-tax regime. If the account code length or segment structure differs between systems, we flag the discrepancy and propose a mapping strategy. Open AP/AR tax breakdowns require the tax code mapping table to be complete before invoice import can proceed.
Sandbox migration and reconciliation
We run a full migration into an Epicor Kinetic test environment using representative data volume. The customer's operations lead reconciles record counts (Customers, Suppliers, Parts, BOMs, GL Accounts, Production Orders, Employees) against the Freedom ERP source, spot-checks fifty random records per object, and validates BOM tree integrity. Any mapping corrections are documented and applied before the production migration begins.
Production migration in dependency order
We run production migration in record-dependency order: GL Accounts first (foundation for all financial transactions), then Customers and Suppliers (referenced by AP/AR and PO), then Parts and Part BOMs (referenced by Jobs), then Production Orders mapped to Jobs, then open AP/AR invoices, then Employees, then Payroll history (structured export for HR team to enter), then QC records, Maintenance records, Projects, and Gate Entry logs. Custom UDFs populate via BPM triggers after their parent records are committed. Each phase emits a row-count reconciliation report before the next phase begins.
Cutover, validation, and document migration handoff
We freeze Freedom ERP writes during cutover, run a final delta migration of any records modified during the migration window, then enable Epicor Kinetic as the system of record. We deliver the document file inventory list for manual upload to Epicor Kinetic Content and Media storage. We deliver the BPM rebuild list for Epicor Kinetic UDF population. We do not rebuild Freedom ERP workflows, automations, or forms; we deliver a written inventory of these for the customer's Epicor implementation partner to address as a separate engagement.
Platform deep dives
Freedom ERP
Source
Strengths
Weaknesses
Epicor Prophet 21
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 Freedom ERP and Epicor Prophet 21.
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
Freedom ERP: Not applicable.
Data volume sensitivity
Freedom 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 Freedom ERP to Epicor Prophet 21 migration scoping. Not seeing yours? Book a call.
Walk through your Freedom ERP 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 Freedom ERP
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.