ERP migration

Migrate from FUJITSU GLOVIA G2 to Epicor Prophet 21

Field-level mapping, validation, and rollback between FUJITSU GLOVIA G2 and Epicor Prophet 21. We move data and schema; workflows are rebuilt natively in Epicor Prophet 21.

FUJITSU GLOVIA G2 logo

FUJITSU GLOVIA G2

Source

Epicor Prophet 21

Destination

Epicor Prophet 21 logo

Compatibility

83%

10 of 12

objects map 1:1 between FUJITSU GLOVIA G2 and Epicor Prophet 21.

Complexity

BStandard

Timeline

6-10 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

FUJITSU GLOVIA G2 is a modular discrete manufacturing ERP with over 70 optional modules sold by CrescentOne under Constellation Software since Fujitsu's 2021 spin-off. Every GLOVIA G2 installation is unique depending on which modules were activated during implementation, so we begin discovery by enumerating every active module and any developer-added custom fields before we can build a migration map. Epicor ERP, and specifically Epicor Kinetic, is a cloud-native manufacturing ERP built for make-to-order and engineer-to-order environments with strong CPQ, production scheduling, and quality management. We migrate the transactional core: Item master and BOM structures, open and closed Work Orders, on-hand inventory with lot and serial data, open Sales and Purchase Orders, and Chart of Accounts with fiscal period balances. We do not migrate GLOVIA G2 workflows, automations, custom developer integrations, or IoT telemetry as these are non-portable platform configurations. Documents attached to GLOVIA G2 records migrate as file attachments to the corresponding Epicor records; custom developer fields require pre-creation in Epicor before any data loads.

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

FUJITSU GLOVIA G2 logo

FUJITSU GLOVIA G2

What's pushing teams away

  • High total cost of ownership including software licenses, implementation services, and ongoing support contracts exceeds what smaller discrete manufacturers can sustain long-term.
  • The rebranding from Fujitsu Glovia to CrescentOne under Constellation Software created uncertainty about product roadmap continuity and support quality.
  • Implementation complexity—configuring 70+ modules, custom fields, and integrations—routinely exceeds initial project timelines and budgets.
  • Limited third-party integration ecosystem compared to SAP or Epicor; some customers report difficulty connecting modern SaaS tools to GLOVIA G2's on-premises instances.
  • Steep learning curve for new employees; the visual workflow interface, while familiar to power users, requires significant training investment for new hires.

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 FUJITSU GLOVIA G2 objects map to Epicor Prophet 21

Each row shows how a FUJITSU GLOVIA G2 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.

FUJITSU GLOVIA G2

Item / Part

maps to

Epicor Prophet 21

Part

1:1
Fully supported

GLOVIA G2 Item master records map to Epicor Part. The part number, description, unit of measure, and cost fields transfer directly. Revision levels in GLOVIA G2 correspond to Epicor PartRev records that we create during the Part import. On-hand quantity, lot numbers, and serial numbers migrate from GLOVIA G2 inventory records and land in Epicor PartBin with location-specific rows. If GLOVIA G2 uses lot costing or FIFO valuation, the lot cost values migrate as PartTran records rather than as a simple quantity update.

FUJITSU GLOVIA G2

Bill of Materials (BOM)

maps to

Epicor Prophet 21

PartRev + PartMtl

lossy
Fully supported

GLOVIA G2 multi-level BOMs with by-products, co-products, and phantom BOMs map to Epicor PartRev (revision header) and PartMtl (material lines) tables. We sequence BOMs top-down by parent part number to preserve the multi-level structure during migration. Phantom BOMs require explicit PartRev.phantomBOMFlag configuration in Epicor. If GLOVIA G2 BOMs include alternate materials or alternate operations, we create corresponding PartMtl and PartOpr alternate records in Epicor. BOM revision dating from GLOVIA G2 migrates to Epicor PartRev with effective-from and effective-to dates set to preserve the revision history that manufacturing engineering relies on.

FUJITSU GLOVIA G2

Work Order / Production Order

maps to

Epicor Prophet 21

JobMtl + JobOper

1:1
Fully supported

GLOVIA G2 Work Orders map to Epicor Jobs (JobHead, JobMtl, JobOper, PartTran). Open work orders migrate with full material allocations, operation sequences, labor hour estimates, and current status. We preserve the operation sequencing by mapping GLOVIA G2 operation steps to Epicor JobOper with the correct OpCode, LaborHrs, and BurdenHrs. Closed work orders migrate as Job records with a Closed status flag and complete PartTran history. Inspection results from GLOVIA G2 attach to Epicor JobOper inspection operation types.

FUJITSU GLOVIA G2

Customer / Account

maps to

Epicor Prophet 21

Customer

1:1
Fully supported

GLOVIA G2 Customer records map to Epicor Customer with ship-to and bill-to addresses preserved as separate address records. Credit limits, payment terms, and sales territory assignments transfer to Epicor Customer fields. Contact sub-records migrate as Epicor Person records linked to the Customer. Where GLOVIA G2 co-installed CRM module is active, we also migrate communication history records as Epicor CustomerLog entries.

FUJITSU GLOVIA G2

Vendor / Supplier

maps to

Epicor Prophet 21

Supplier

1:1
Fully supported

GLOVIA G2 Vendor records map to Epicor Supplier with procurement terms, lead times, approved supplier list assignments, and ASN data preserved. Multi-plant vendor assignments from GLOVIA G2 become separate SupplierPP records in Epicor per plant. Vendor contacts migrate as Epicor Person records linked to the Supplier.

FUJITSU GLOVIA G2

Sales Order

maps to

Epicor Prophet 21

OrderHed + OrderDtl

1:1
Fully supported

Open Sales Orders from GLOVIA G2 migrate line-by-line to Epicor OrderHed (header) and OrderDtl (detail) records. We transfer pricing, discounts, scheduled ship dates, and order statuses. GLOVIA G2 custom order fields map to Epicor OrderHed character fields or UD columns, requiring pre-creation in Epicor before the order import. Released orders versus pending orders in GLOVIA G2 map to Epicor OrderHed.OrderHeld flag to preserve the release status that the warehouse team acts on.

FUJITSU GLOVIA G2

Purchase Order

maps to

Epicor Prophet 21

POHeader + PODetail

1:1
Fully supported

Open Purchase Orders from GLOVIA G2 migrate to Epicor POHeader and PODetail. Vendor, order date, terms, and line items including part number, quantity, unit cost, and due date transfer directly. GLOVIA G2 custom PO fields require pre-creation of Epicor UD columns. Released versus pending status from GLOVIA G2 maps to Epicor POHeader APPROVED flag.

FUJITSU GLOVIA G2

General Ledger / Chart of Accounts

maps to

Epicor Prophet 21

GL Account + Ledger

1:1
Fully supported

GLOVIA G2 Chart of Accounts structures map to Epicor GL Account with natural account segment preserved and any segment structures (company, division, department) mapped to Epicor's multi-segment account code format. Custom ledger types added by GLOVIA G2 developers require pre-creation of Epicor Ledger records before migration. Sub-ledger associations from GLOVIA G2 map to Epicor GL Account segments.

FUJITSU GLOVIA G2

Journal Entries / Fiscal Period Balances

maps to

Epicor Prophet 21

GLJrnDtl

1:1
Fully supported

Open AP and AR sub-ledger records migrate as live Epicor GLJrnDtl entries. Closed fiscal periods in GLOVIA G2 are write-protected and cannot be re-posted; we extract the period balances as read-only historical records in Epicor GLJrnDtl with a closed period flag and deliver a reconciliation report for the customer's finance team to validate before the next fiscal period close. Custom journal entry types from GLOVIA G2 require pre-creation of Epicor Journal Codes.

FUJITSU GLOVIA G2

Inventory / Stock

maps to

Epicor Prophet 21

PartBin + PartLot

1:1
Fully supported

On-hand quantities by location migrate from GLOVIA G2 to Epicor PartBin with the quantity, cost, and qty Bearing flags preserved. Lot numbers and serial numbers with FIFO or lot costing values transfer to Epicor PartLot records linked to the PartBin. If GLOVIA G2 tracks lot expiration dates, those migrate as PartLot.LotSuffixDate fields. Location assignments from GLOVIA G2 warehouse management module map to Epicor Warehse and Bin records with shelf and location codes preserved.

FUJITSU GLOVIA G2

Documents / Attachments

maps to

Epicor Prophet 21

DocumentReference

1:1
Mapping required

GLOVIA G2 documents attached to items, work orders, and orders are exported via the Application Adapter file export and reattached to the corresponding Epicor records using Epicor's DocumentReference table. Document revision history and change descriptions transfer as DocumentRev records. We flag any unsupported attachment formats (non-standard GLOVIA G2 document types that Epicor cannot render) for manual retrieval from the GLOVIA G2 file store post-migration.

FUJITSU GLOVIA G2

Custom Objects / Developer Fields

maps to

Epicor Prophet 21

Custom Fields / UD Tables

lossy
Mapping required

GLOVIA G2 implementations frequently add custom fields and developer objects via the Bus and Task Developer environment. We identify every non-standard field during discovery and pre-create corresponding Epicor Extended Properties or UD columns before any data load. Custom lookup relationships in GLOVIA G2 (such as a custom field linking an Order to a Project object) require Epicor UD table creation and foreign key configuration in Epicor's database. We deliver a written map of every custom field with its source GLOVIA G2 data type and the target Epicor field definition, for the customer's Epicor admin to review and confirm before import.

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.

FUJITSU GLOVIA G2 logo

FUJITSU GLOVIA G2 gotchas

High

GLOVIA G2 rebranded to CrescentOne

High

Modular configuration creates unique per-instance schemas

Medium

On-premise deployments require direct database access

Medium

Historical closed periods are locked at migration time

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

  • Every GLOVIA G2 instance has a unique schema

    No two GLOVIA G2 installations are identical. Each customer activates a different subset of the 70+ optional modules and may have added custom developer fields via the Bus and Task Developer environment. We cannot assume a standard schema exists. Discovery must enumerate every active module and all custom objects before we build the migration map. Skipping this step results in silently dropped records and incomplete BOM structures in Epicor. We require read-only database or Application Adapter access during scoping to enumerate the exact active configuration.

  • Epicor BOM structure requires pre-configuration

    GLOVIA G2 stores BOMs as Item-level linked records with revision levels. Epicor ERP separates BOM revision (PartRev table) from material lines (PartMtl table) and operation steps (PartOpr table). Phantom BOMs, alternate materials, and alternate operations each require specific Epicor configuration flags that must be set before PartMtl and PartOpr import. If GLOVIA G2 BOMs are not pre-analyzed for phantom structure and alternates, the Epicor import produces flat BOMs that lose the multi-level hierarchy that shop floor scheduling relies on.

  • Closed fiscal periods are non-writable in GLOVIA G2

    GLOVIA G2 locks closed fiscal periods at the GL level and does not allow re-posting. We extract closed period balances as read-only records for Epicor, but reconciliation discrepancies between GLOVIA G2 closed balances and Epicor GL entries require manual post-migration review by the customer's finance team. We flag any unmatched accounts and deliver a reconciliation worksheet. Attempting to force re-posting into a closed GLOVIA G2 period is not possible and is outside the migration scope.

  • GLOVIA G2 custom developer fields require Epicor schema pre-creation

    GLOVIA G2 Bus and Task Developer fields are platform-specific and do not export through standard GLOVIA G2 data adapters in a directly portable format. We identify these fields during discovery, document their GLOVIA G2 data types and lookup relationships, and require the customer to create corresponding Epicor Extended Properties or UD columns before we run the migration. If Epicor schema pre-creation is not completed before migration day, custom field data cannot load and those fields are excluded from the migration scope.

Migration approach

Six steps for a successful FUJITSU GLOVIA G2 to Epicor Prophet 21 data migration

  1. Module and schema discovery

    We audit the source GLOVIA G2 instance by enumerating every active module, all custom developer fields, the Chart of Accounts structure, open order volume, work order counts by status, inventory location count, and closed period date ranges. For on-premise GLOVIA G2 deployments behind the customer firewall, we coordinate secure read-only database access with the customer's IT team; for cloud-hosted instances, we use GLOVIA G2 Application Adapters and REST data endpoints. Discovery output is a written schema inventory that becomes the baseline for every subsequent mapping decision.

  2. Epicor schema pre-creation

    We provision the Epicor destination schema before any data migration begins. This includes creating PartRev revisions for all GLOVIA G2 items, setting PartRev.phantomBOMFlag and PartMtl alternate flags for phantom and alternate material BOMs, creating UD columns for GLOVIA G2 custom developer fields, provisioning GL Account structures matching the GLOVIA G2 Chart of Accounts segment layout, and creating Epicor Warehse and Bin records for every GLOVIA G2 inventory location. Epicor schema deployment runs in a Sandbox environment first for validation, then migrates to the production Epicor org.

  3. BOM sequencing and parent-child resolution

    We extract GLOVIA G2 multi-level BOMs top-down and sequence the parent-to-child relationships before any PartRev or PartMtl insert into Epicor. We build a dependency graph of all GLOVIA G2 items and BOMs so that parent revisions are created before material lines reference them. Phantom BOMs and alternate materials are flagged during extraction and set to the correct Epicor PartRev and PartMtl configuration flags during the Epicor load. BOM revision effective dates migrate as PartRev.EffectiveDate to preserve the engineering revision timeline.

  4. Production migration in dependency order

    We run production migration into Epicor in strict record-dependency order: GL Account and Ledger (foundational), Warehse and Bin (location infrastructure), Part (items without BOM materials first), PartBin and PartLot (inventory), Supplier and Customer (trading partners), PartRev and PartMtl (BOMs after Parts confirmed), JobHead with JobMtl and JobOper (work orders), POHeader and PODetail (purchase orders), OrderHed and OrderDtl (sales orders), then GLJrnDtl (journals and closed period balances as read-only). Documents attach after their parent records are confirmed in Epicor. Custom field data loads last, after UD columns are confirmed to exist.

  5. GL reconciliation and closed period handoff

    We deliver a GL reconciliation worksheet comparing GLOVIA G2 closed period balances to the archived Epicor GLJrnDtl records. Any unmatched account codes or balance discrepancies are flagged for the customer's finance team to investigate and post as correcting journal entries if needed. We do not modify locked closed periods in GLOVIA G2 or Epicor. We provide a written closed-period archive file from GLOVIA G2 in case the customer needs to reference the original closed-period data outside Epicor.

  6. Cutover, document migration, and workflow inventory handoff

    We freeze GLOVIA G2 write access during the final migration window, run a delta migration of any records modified during the window, then enable Epicor as the system of record. Document attachments from GLOVIA G2 are uploaded to Epicor DocumentReference against their parent records. We deliver a written inventory of every GLOVIA G2 workflow, automation, and custom integration that requires rebuild in Epicor. We support a one-week post-go-live window for reconciliation issues raised by the manufacturing and finance teams.

Platform deep dives

Context on both ends of the pair

FUJITSU GLOVIA G2 logo

FUJITSU GLOVIA G2

Source

Strengths

  • Highly visual, spreadsheet-like interface that reviewers describe as user-friendly for teams familiar with Excel.
  • Deep discrete-manufacturing functionality including production planning, scheduling, shop floor control — purpose-built for automotive, aerospace, electronics.
  • 70+ modular ERP components installable alongside existing software, enabling staged adoption rather than big-bang replacement.
  • Extensive no-code customization — reviewers consistently call out the ability to modify processes without code as a major advantage over SAP Business One and Dynamics 365.
  • Strong overall recommendation rate on Gartner Peer Insights (100% would recommend across 45 reviews).

Weaknesses

  • Configuration complexity at scale — reviewers report initial setup is intricate and requires investment in implementation expertise.
  • Software updates can override custom configurations, forcing teams to reapply customizations after each upgrade.
  • Vendor responsiveness on support cases reported as slow by some customers — engagement with technical support can be difficult.
  • Training quality is uneven — multiple reviewers note training could be improved to help users adopt the breadth of capabilities.
  • Initial migration onto Glovia G2 is described as difficult and time-consuming, particularly for orgs coming off legacy ERPs.
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. 2 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 FUJITSU GLOVIA G2 and Epicor Prophet 21.

  • Object compatibility

    B

    2 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

    FUJITSU GLOVIA G2: Not publicly documented.

  • Data volume sensitivity

    A

    FUJITSU GLOVIA G2 exposes a bulk API — large-volume migrations stream efficiently.

Estimator

Estimate your FUJITSU GLOVIA G2 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 FUJITSU GLOVIA G2 to Epicor Prophet 21 data migrations

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

Can't find your answer?

Walk through your FUJITSU GLOVIA G2 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 ten weeks for accounts with up to 50,000 items, 10,000 open work orders, and 15 or fewer active GLOVIA G2 modules. Migrations with full multi-level BOM hierarchies, large closed work order histories, multi-entity General Ledger structures, or more than 20 active GLOVIA G2 modules move to fourteen to twenty weeks because of BOM sequencing complexity, GL reconciliation scope, and Epicor PartRev configuration requirements. The exact timeline depends on how quickly the customer's IT team provides read-only database access and confirms Epicor schema pre-creation.

Adjacent paths

Related migrations to explore

Ready when you are

Move from FUJITSU GLOVIA G2.
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