ERP migration
Field-level mapping, validation, and rollback between Embrace ERP and Epicor Prophet 21. We move data and schema; workflows are rebuilt natively in Epicor Prophet 21.
Embrace ERP
Source
Epicor Prophet 21
Destination
Compatibility
10 of 14
objects map 1:1 between Embrace ERP and Epicor Prophet 21.
Complexity
BStandard
Timeline
6-10 weeks
Overview
Moving from Embrace ERP to Epicor Kinetic ERP is a data-model restructuring that moves South African mid-market manufacturers onto an internationally-scaled platform with deep discrete manufacturing capabilities. Embrace stores financial, inventory, and manufacturing records in tightly linked tables with no public REST or bulk export endpoint; we extract via scoped database read-only access and transform the schema for Epicor's multi-site, multi-company legal-entity model. The migration sequences Chart of Accounts and tax codes first to establish the financial backbone, then migrates customer and vendor masters with banking and tax registration detail, then handles inventory items and bill-of-materials hierarchies, and finally reconciles open AP/AR at cutover. We do not migrate iMBrace workflows or Embrace report customizations as code; we deliver a written inventory of both for the customer's Epicor admin to rebuild in Kinetic's Business Process Management (BPM) and Report Designer modules. Custom fields discovered during scoping are mapped individually to Epicor Kinetic's UD (user-defined) field infrastructure.
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 Embrace 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.
Embrace ERP
Chart of Accounts
Epicor Prophet 21
Chart of Control Account
1:1Embrace's Chart of Accounts structure maps directly to Epicor Kinetic's GL Account (COA) using the account code as the natural key and the account description as the account name. Embrace's cost-center dimension maps to Epicor's Department, Division, or Site segment depending on the customer's account structure. We extract the full account tree, identify any inactive accounts flagged in Embrace for deactivation, and configure the Epicor COA segment structure during initial Epicor setup before any transaction data lands.
Embrace ERP
Tax Codes
Epicor Prophet 21
Tax Connect
lossyEmbrace's SARS-compliant tax codes (VAT, withholding tax, and any custom statutory rates) map to Epicor Kinetic's Tax Connect configuration. We extract all active tax codes with current effective rates and jurisdictions, then configure Tax Connect in Epicor with matching tax types, rates, and applicability rules. Note that Epicor Kinetic's Tax Connect supports multiple tax authorities per jurisdiction; any Embrace tax code with custom calculation rules (compound tax, reverse charge, or third-party withholding) is flagged for manual review during scoping.
Embrace ERP
Customer
Epicor Prophet 21
Customer
1:1Embrace customer master records map to Epicor Kinetic Customer records with billing address, ship-to address, contact details, and tax registration number preserved. We resolve the customer's payment terms from Embrace's terms code to Epicor's Terms master. Customer credit limits and hold status migrate as Customer Credit records. Multiple ship-to addresses per customer in Embrace become Epicor ShipTos attached to the same Customer record.
Embrace ERP
Vendor
Epicor Prophet 21
Supplier
1:1Embrace vendor master records map to Epicor Kinetic Supplier records. Supplier-specific fields including banking details (bank name, account number, SWIFT/BIC) and tax registration migrate to Epicor Supplier and Tax Registration records. Payment terms resolve from Embrace terms codes to Epicor Terms master. We flag any Embrace vendor marked as inactive for manual review before final import to avoid creating suppliers with zero open purchase orders.
Embrace ERP
Item (Inventory)
Epicor Prophet 21
Part
1:1Embrace inventory items map to Epicor Kinetic Part records with stock code as Part Number, description as Part Description, and costing method (standard, average, FIFO) preserved via the Epicor Costing Lot Select field. Warehouse locations from Embrace map to Epicor Warehse records within the Epicor Site. We extract reorder parameters (reorder point, safety stock, economic order quantity) and configure Epicor's MRP and planning settings to match the Embrace planning logic. Any Embrace item with a non-standard unit of measure (UOM) set requires Epicor UOMClass configuration before the item imports.
Embrace ERP
Bill of Materials
Epicor Prophet 21
Bill of Materials / Method of Manufacture
1:1Embrace BOM hierarchies (multi-level, single-level, and phantom) map to Epicor Kinetic BOM and Method of Manufacture (MOM) records. We extract the full BOM tree from Embrace, identify the top-level manufactured part, and construct the Epicor BOM with the correct part revisions and bomrev records. Routing sequences from Embrace (work centers, operation sequences, standard times) map to Epicor JobMtl and JobOper records. Phantom BOMs in Embrace become Epicor Part master records flagged as Phantom. We rebuild BOMs in Epicor before any inventory or transaction data loads so that production orders can reference the BOM on day one.
Embrace ERP
Open AP
Epicor Prophet 21
AP Invoice / AP Payment
lossyOutstanding AP invoices in Embrace must be reconciled at migration cutover. We extract open AP items with full aging detail (invoice number, vendor reference, due date, amount, and any partial payment history) and load them into Epicor as AP Invoice records with status set to open. Any invoice with a partial payment applied in Embrace receives a corresponding AP Payment record in Epicor at cutover. We flag AP records with mismatched vendor account codes between Embrace and the Epicor Supplier master for manual resolution before import.
Embrace ERP
Open AR
Epicor Prophet 21
AR Invoice / AR Payment
lossyOutstanding AR invoices in Embrace migrate to Epicor Kinetic AR Invoice records with aging preserved. We extract open AR items (invoice number, customer reference, due date, amount, and any credit note offsets) and load them with status open. Any Embrace credit notes applied against an open invoice become Epicor AR Credit Memo records linked to the parent invoice. Customer balances are reconciled in Epicor AR before go-live; we flag any AR record with an unmatched Epicor Customer to avoid orphaning invoices against deleted customers.
Embrace ERP
Historical Transactions
Epicor Prophet 21
General Ledger Batch / Journal Entry
1:1Historical posted journals and batch details from Embrace can migrate to Epicor Kinetic GL Journal entries if the customer requires fiscal-year depth in the new system. We scope the required fiscal-year range with the customer during discovery and extract posted batches with full line-item detail. We do not migrate unposted transactions or any transaction type that has not been fully approved in Embrace. Epicor Kinetic stores historical journals in the GLJrnHed and GLJrnDtl tables; we load via Epicor's Journal Entry import with the original posting date, batch description, and source module preserved. Very large transaction histories (over 500,000 journal lines) may be scoped to the last two to three fiscal years with older history archived separately.
Embrace ERP
Documents and Attachments
Epicor Prophet 21
Document Management / External File Link
1:1Documents linked to transactions or master records in Embrace's document management layer are extracted via the file export path identified during scoping. We extract what can be reached programmatically and organize the file set by record type (customer, vendor, part, order) for reattachment in Epicor's Document Management module or as external file references. Any Embrace document stored in a non-filesystem location (embedded in a custom database field) is flagged for manual retrieval. We do not migrate the document management configuration itself; the customer's admin rebuilds any folder structure, security, and retention rules in Epicor's Document Management settings.
Embrace ERP
Custom Fields
Epicor Prophet 21
UD (User-Defined) Fields
lossyEmbrace user-defined fields on customer, vendor, part, and transaction records map to Epicor Kinetic UD fields (UD05 through UD99) using the equivalent data type (character, numeric, date, checkbox). We discover the complete custom-field schema during scoping by querying the Embrace database for non-standard column names on master and transaction tables. Any Embrace custom field with an unsupported data type (e.g., bespoke picklist values not matching an Epicor drop-down) is flagged for manual review before final import. Epicor UD fields are configured per table in Kinetic before any record import.
Embrace ERP
Users and Roles
Epicor Prophet 21
User / User Account
1:1Embrace user accounts and role-based permissions map to Epicor Kinetic User records and Business Unit / Security Role assignments. We extract Embrace user definitions (username, display name, email, active/inactive status) and map each to an Epicor Kinetic User with the equivalent access level. Any Embrace permission set without a direct Epicor Kinetic equivalent is documented in the handoff report for the customer's Epicor admin to assign using Kinetic's security model (Company, Site, Warehouse, Business Unit scoping). Passwords do not migrate; the customer's admin resets credentials or uses SSO configuration post-migration.
Embrace ERP
Workflow Definitions (iMBrace)
Epicor Prophet 21
BPM (Business Process Management)
1:1Workflows defined in Embrace's native workflow engine or the iMBrace companion platform do not migrate as executable code to Epicor Kinetic BPM. Epicor BPM uses a different process model (event-driven triggers, service-connector routing, and form personalization) that cannot be directly translated from Embrace's workflow definition format. We export workflow rules as structured definitions in a written inventory document that describes each workflow's trigger event, conditions, approval chain, and downstream actions. The customer's Epicor admin or a Kinetic implementation partner rebuilds these in BPM post-migration.
Embrace ERP
Report Customizations
Epicor Prophet 21
Report Designer / Crystal Reports
1:1Embrace report customizations holding business logic are not captured by standard data exports and do not migrate as report definitions to Epicor. We document every active custom report during scoping: the report name, base template, custom fields included, calculated columns, grouping logic, and branding elements. The customer's Epicor admin rebuilds these reports in Kinetic's Report Designer or Crystal Reports, referencing the migrated data fields. We provide a data dictionary that maps each Embrace custom field to its Epicor UD field equivalent so the admin can rebuild the calculations correctly.
| Embrace ERP | Epicor Prophet 21 | Compatibility | |
|---|---|---|---|
| Chart of Accounts | Chart of Control Account1:1 | Fully supported | |
| Tax Codes | Tax Connectlossy | Fully supported | |
| Customer | Customer1:1 | Fully supported | |
| Vendor | Supplier1:1 | Fully supported | |
| Item (Inventory) | Part1:1 | Fully supported | |
| Bill of Materials | Bill of Materials / Method of Manufacture1:1 | Fully supported | |
| Open AP | AP Invoice / AP Paymentlossy | Fully supported | |
| Open AR | AR Invoice / AR Paymentlossy | Fully supported | |
| Historical Transactions | General Ledger Batch / Journal Entry1:1 | Mapping required | |
| Documents and Attachments | Document Management / External File Link1:1 | Mapping required | |
| Custom Fields | UD (User-Defined) Fieldslossy | Mapping required | |
| Users and Roles | User / User Account1:1 | Mapping required | |
| Workflow Definitions (iMBrace) | BPM (Business Process Management)1:1 | Fully supported | |
| Report Customizations | Report Designer / Crystal Reports1: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.
Embrace ERP gotchas
Limited data export tooling blocks self-service migration
Report customizations are not captured by standard exports
Custom fields create schema variation across clients
Upgrade path can invalidate bespoke modifications
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 scoping
We audit the Embrace database schema across all installed modules to discover the complete set of master tables, transaction tables, custom fields, custom reports, and workflow definitions. We identify the database export path (direct SQL read, linked server, or file export) and confirm read-only access scope with the customer's IT team. We also review the Epicor Kinetic target environment (company code, site assignments, and any planned multi-company structure) and the intended fiscal-year depth for historical transaction migration. The discovery output is a written migration scope document listing every object, its record volume estimate, its mapping type, and any known constraints that require manual resolution.
BOM and routing pre-configuration in Epicor
Before any transactional data imports, we configure the Epicor Kinetic BOM and routing structures. We extract the full Embrace BOM hierarchy (multi-level and single-level), map component quantities, and create Epicor Part records with revision and BOM records for each manufactured item. Routing sequences (work centers, operation times, and scheduling offsets) load as JobOper records. We validate BOM integrity (quantity-per ratios, circular reference checks, missing components) and the customer's Epicor manufacturing team signs off on the BOM configuration before inventory and transaction data loads begin.
Financial backbone: Chart of Accounts, tax codes, and site setup
We extract and load the Embrace Chart of Accounts, tax codes, and payment terms into Epicor Kinetic. Account codes map to GL Account, tax codes configure Tax Connect, and terms codes map to Terms master. We configure the Epicor Site and Warehse records that correspond to Embrace warehouse and cost-center dimensions. All GL and tax configuration must be validated before open AP/AR and transaction data load because those records reference the chart of accounts and tax codes directly.
Master data migration: customers, vendors, and parts
We migrate customer, vendor, and part master records in parallel, starting with parts because BOM dependencies require Part records to exist before BOM lines can reference them. Customer and vendor migrations include all address, contact, tax registration, and banking detail fields. We resolve payment terms, credit limits, and hold status against the pre-loaded Terms and Credit masters. Each import phase emits a reconciliation report comparing source record count to destination insert count; any record rejected by Epicor validation rules is corrected and reloaded in the same phase before proceeding.
Open AP/AR cutover reconciliation
Outstanding AP and AR items extract from Embrace at cutover with full aging detail and import into Epicor as open invoices and credit memos. We freeze Embrace to read-only during the cutover window, run a final delta export to capture any transactions modified in the final hours, then import into Epicor. Customer and vendor balances in Epicor AR and AP are reconciled against the Embrace source totals before go-live is confirmed. Any AP or AR record with a mismatched vendor or customer code is held in a reconciliation queue and resolved manually before Epicor goes live.
Go-live, validation, and workflow rebuild handoff
We enable Epicor Kinetic as the system of record at the agreed cutover timestamp, confirm AR/AP opening balances match the Embrace source, and validate that master records (customers, vendors, parts) are accessible from Epicor's transaction modules. We deliver the iMBrace workflow inventory and the Embrace custom report documentation to the customer's Epicor admin team. We support a one-week hypercare window to resolve any data integrity issues surfaced during the first business week of live operation. We do not rebuild iMBrace workflows as Epicor BPM or custom reports in Epicor Report Designer; those are separate rebuild engagements.
Platform deep dives
Embrace 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 Embrace 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
Embrace ERP: Not publicly documented.
Data volume sensitivity
Embrace 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 Embrace ERP to Epicor Prophet 21 migration scoping. Not seeing yours? Book a call.
Walk through your Embrace 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 Embrace 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.