ERP migration
Field-level mapping, validation, and rollback between Wiise and Epicor Prophet 21. We move data and schema; workflows are rebuilt natively in Epicor Prophet 21.
Wiise
Source
Epicor Prophet 21
Destination
Compatibility
12 of 13
objects map 1:1 between Wiise and Epicor Prophet 21.
Complexity
BStandard
Timeline
6-10 weeks
Overview
Moving from Wiise to Epicor ERP is a manufacturing-capability migration, not a straightforward record copy. Wiise is a Microsoft Dynamics 365 Business Central derivative that excels at finance, CRM, inventory, and light project costing for Australian and New Zealand mid-market businesses, but it lacks deep shop-floor, MRP, MES, configure-to-order, and configure-to-print capabilities that discrete manufacturers require at scale. Epicor ERP is purpose-built for 50-2,500-employee manufacturers running job shop, make-to-order, engineer-to-order, and mixed-mode production. We extract data from Wiise through Business Central APIs and native exports, transform dimensional chart-of-accounts tags into Epicor cost codes, map BOM and routing headers to Epicor PartBill and PartMtl structures, and load through Epicor's REST and bulk interfaces. Workflows, approval chains, and automated posting rules from Wiise do not migrate; we deliver a written inventory of every automation requiring rebuild in Epicor BPM alongside the data migration. Manufacturing-specific customizations (BPMs, BAQs, UD tables) that were built in the source Wiise environment also do not carry forward and require Epicor-native reconstruction post-migration.
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 Wiise 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.
Wiise
Customer
Epicor Prophet 21
Customer
1:1Wiise Customer cards map to Epicor Customer with name, address, contact details, payment terms, and currency settings transferred directly. We resolve the CustomerShpTo (ship-to address) records as Epicor ShipTo records attached to the same CustomerNum. Credit limits and payment terms become Epicor CashTerms and CreditLimit fields. Multi-currency settings on the Wiise customer card migrate to the Epicor Customer Currency record.
Wiise
Vendor
Epicor Prophet 21
Vendor
1:1Wiise Vendor cards map to Epicor Vendor with the same structure as Customer. Purchase terms, currency settings, and payment methods transfer to Epicor Vendor records. Where Wiise vendor cards carry cost-centre dimensional tags for AP posting, we map these to Epicor VendorPPGroup (Posting Price Group) for PO routing and apply cost-code defaults during AP invoice entry.
Wiise
Item
Epicor Prophet 21
Part
1:1Wiise Items (stock, non-stock, and service) map to Epicor Part records. Item type, inventory posting groups, and warehouse location assignments transfer to Epicor's Part with TypeCode (Stock, Non-Stock, Service), PartClass, and PartWhse records. Wiise's 2 decimal-place limit on custom Item fields means any decimal precision above 2 places is rounded before Epicor import; we flag every instance in the pre-flight mapping report.
Wiise
Chart of Accounts
Epicor Prophet 21
GL Account + Cost Code
1:1Wiise uses a dimensional chart with cost-centre, department, and location tags on every posting. We map Wiise account codes to Epicor GL Account numbers directly and map the dimensional tags to Epicor Cost Codes. During scoping, we verify that the Epicor Cost Code structure (which can be up to 20 characters and hierarchical) accommodates the full set of Wiise dimension combinations. Any unmatched dimension combinations are escalated before the first GL import.
Wiise
Open AP / Open AR
Epicor Prophet 21
AP Invoice / AR Invoice
1:1Outstanding AP and AR records migrate as open Epicor APInvoiceHed and ARInvoiceHed entries with invoice date, due date, remaining amount, and currency preserved. We use Epicor'sAPInvoice or ARInvoice endpoints to insert header and detail lines. Invoice totals are reconciled against the Wiise trial balance before the import phase opens. Lines referencing inventory items require a matching Part record to exist in Epicor first, so we stage Parts before AP/AR.
Wiise
Bill of Materials
Epicor Prophet 21
PartBill / PartMtl
1:1Wiise BOMs (Premium tier) map to Epicor PartBill with the parent Part as the finished good and BOM lines as PartMtl entries with quantity-per-assembly and scrap percentages. Wiise BOM revision numbers map to Epicor RevisionNum with an effective date preserved. Routing headers (Premium tier) map to Epicor JobOper records with work-centre assignments, cycle times, and setup hours. We verify that the Epicor site ID exists for each BOM before import because BOMs in Epicor are site-specific.
Wiise
Job / Project
Epicor Prophet 21
Project
1:1Wiise Jobs with task-level work breakdown, resource assignments, and billing map to Epicor Project and ProjectPhase records. Job-specific cost dimensions from Wiise migrate as Epicor WBS codes or Cost Codes on the Project. Epicor's Project Control module supports milestone billing, progress billing, and job costing against a budget, which is more sophisticated than Wiise's job-costing model; we preserve Wiise job totals as opening values on Epicor Project Phase budget fields.
Wiise
Fixed Asset
Epicor Prophet 21
Asset
1:1Wiise Fixed Asset records (acquisition date, cost, depreciation method, book value, location) map to Epicor FAAsset with the depreciation schedule preserved as-is. We flag any assets still under depreciation at migration date so that the customer can set the correct fiscal year start for depreciation posting in Epicor. Asset disposals and revaluations from Wiise migrate as adjustment transactions against the existing Asset record.
Wiise
Employee
Epicor Prophet 21
Employee
1:1Wiise Employee records (name, position, department, employment status, HR metadata) migrate to Epicor Employee with active and terminated employees included. Wiise payroll history (pay runs, superannuation, leave balances) is in a separate priced add-on module and migrates as a distinct workstream; we recommend HR team sign-off on employee-level records and coordinate with the customer's chosen payroll destination. Epicor's HR module uses an EmployeeNum as the primary key; we resolve by personal email as the dedupe match.
Wiise
Warehouse / Inventory Location
Epicor Prophet 21
Site + Warehouse
1:1Wiise warehouse locations with bin-level item quantities map to Epicor Plant (Site) and Warehouse records with bin locations preserved as PartBin entries. Where Wiise uses location codes for inter-company transfers, we map these to Epicor Site codes and verify that the inter-company trading setup in Epicor is configured to match the Wiise multi-entity structure before inventory quantities transfer.
Wiise
Custom Fields
Epicor Prophet 21
UD Table / UD Code
1:1Wiise custom fields on Customer, Vendor, Item, Sales Header/Lines, Purchase Header/Lines, Job, Contact, Fixed Asset, and Service Item migrate to Epicor UD fields (UD01-UD30 tables) or as custom fields on the relevant Epicor table. We pre-create the UD schema in Epicor before data migration, matching Wiise field types (text, lookup, date, decimal) to the equivalent Epicor data type. The 2 decimal-place limit on Wiise custom decimals carries forward as-is; we flag precision rounding in the pre-flight report.
Wiise
Documents / Attachments
Epicor Prophet 21
Document Management (DMS/EDMS)
lossyWiise has no public API endpoint for binary attachments. We advise customers to use Wiise's built-in export function to download attached documents (invoices, POs, scanned files) before the cutover date and store them in a shared location for manual upload to Epicor DMS post-migration. Epicor's document management is available with full CRUD API, but binary files must be uploaded separately from structured data in this migration pattern.
Wiise
Payroll Add-on
Epicor Prophet 21
External HRMS
1:1Wiise Payroll is a priced add-on calculated per active employee and stores pay runs, superannuation, and leave balances in a schema tied to Australian and New Zealand payroll compliance. We extract employee compensation history and leave balances as a structured export, but the Wiise payroll schema is not a standard Business Central table and requires a separate migration run into an external HRMS or the customer's chosen payroll platform. HR team sign-off is required before any employee record crosses into Epicor.
| Wiise | Epicor Prophet 21 | Compatibility | |
|---|---|---|---|
| Customer | Customer1:1 | Fully supported | |
| Vendor | Vendor1:1 | Fully supported | |
| Item | Part1:1 | Fully supported | |
| Chart of Accounts | GL Account + Cost Code1:1 | Mapping required | |
| Open AP / Open AR | AP Invoice / AR Invoice1:1 | Mapping required | |
| Bill of Materials | PartBill / PartMtl1:1 | Fully supported | |
| Job / Project | Project1:1 | Fully supported | |
| Fixed Asset | Asset1:1 | Fully supported | |
| Employee | Employee1:1 | Fully supported | |
| Warehouse / Inventory Location | Site + Warehouse1:1 | Fully supported | |
| Custom Fields | UD Table / UD Code1:1 | Mapping required | |
| Documents / Attachments | Document Management (DMS/EDMS)lossy | Not supported | |
| Payroll Add-on | External HRMS1: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.
Wiise gotchas
No public API for document attachments
Custom field decimal precision loss
Multi-company scoping must be declared upfront
Opening balance reconciliation requires manual sign-off
Payroll is a priced add-on with separate schema
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 Wiise tier confirmation
We audit the source Wiise environment including tier (Business or Premium), entity count, Item volume, BOM and routing presence (Premium required), open AP/AR age and volume, job/project count, payroll add-on usage, and custom field count by page type. We also extract a trial balance and chart of accounts listing to verify dimensional-tag cardinality for cost-code mapping. The discovery output is a written migration scope, Epicor edition recommendation (Epicor Kinetic Cloud or on-premise), and a multi-company setup checklist if multiple Wiise entities are in scope.
Epicor schema preparation and cost-code design
We work with the customer's Epicor implementation partner to design the destination schema. This includes provisioning Sites, Warehouses, Part classes, GL Account structure, Cost Code hierarchy (to absorb Wiise dimensional tags), Customer and Vendor number formats, BOM and routing templates per production type, and any required UD tables for Wiise custom field recreation. Schema is validated in a non-production Epicor environment before production migration planning begins.
Data extraction, cleansing, and dimensional mapping
We extract structured data from Wiise through Business Central APIs and native exports. Dimensional chart-of-accounts tags are transformed into Epicor Cost Codes during this phase. We run duplicate detection on Customer and Vendor records (dedupe by ABN for Australian entities, company name + address for others), flag precision rounding on custom decimal fields, and produce a data-quality report that the customer reviews and signs off before import begins.
Staging and dependency-ordered import
We import into Epicor in strict dependency order: GL Accounts and Cost Codes first (required for all postings), then Sites and Warehouses, then Part master data (required for inventory quantities), then BOM and routing structures (require Part), then inventory quantities (require Part and Warehouse), then Customers and Vendors, then AP/AR open items (require Vendor and Customer), then Projects and Fixed Assets, then Employee records. Each phase emits a row-count reconciliation report; the next phase does not begin until the previous is signed off.
BOM and routing validation in Epicor non-production
Before production migration, we run a BOM and routing validation in a non-production Epicor environment. We generate a sample production order from a migrated BOM, simulate the routing through the work centres, and verify that the PartBill and PartMtl structures produce the expected material picks. This catches missing work-centre setups, incorrect scrap percentages, and phantom BOM configuration errors before they block production at go-live.
Production migration, cutover, and document handoff
We freeze Wiise writes during the cutover window, run a final delta migration of any records modified since the last extraction pass, then open Epicor as the system of record. We deliver the Workflow and Approval inventory document to the customer's admin team for Epicor BPM reconstruction. We deliver a document-export checklist with file counts and target DMS paths for the manual attachment upload. We support a one-week hypercare window for reconciliation issues. We do not rebuild Wiise workflows as Epicor BPMs or provide post-migration admin support as standard scope; these are separate engagements.
Platform deep dives
Wiise
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 Wiise 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
Wiise: Not publicly documented — governed by Business Central cloud throttling defaults.
Data volume sensitivity
Wiise exposes a bulk API — large-volume migrations stream efficiently.
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 Wiise to Epicor Prophet 21 migration scoping. Not seeing yours? Book a call.
Walk through your Wiise 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 Wiise
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.