Sage X3 to NetSuite Data Migration
Migrating from Sage X3 to NetSuite? Settle automates the mapping between Sage X3's SQL database and NetSuite's cloud architecture — preserving product masters, customer records, BOMs, lot tracking, and financial history.
Working with enterprise teams on active migration programs
Days
to production-ready mappings
Roughly half
the cost of consulting-led delivery
Every row
validated before go-live
Enterprise migrations routinely run months behind schedule. Yours doesn't have to.
This guide is for VPs of IT, data architects, and migration leads at companies moving data from Sage X3 to Oracle NetSuite — whether you're scoping, planning, or mid-program.
Sage X3 (formerly Sage Enterprise Management) stores data in SQL Server or Oracle tables — ITMMASTER (Products), BPCUSTOMER (Customers), BPSUPPLIER (Suppliers), BOMD (BOM Details), GACCENTRY (G/L Entries) — with site-level data segmentation and custom screens built through Sage X3's development tools. NetSuite uses a cloud-native object model. Settle translates Sage X3's table schema to NetSuite's object hierarchy automatically.
Based on the founding team's enterprise migration experience
Last updated July 2026
How Settle automates your Sage X3 to Oracle NetSuite migration
Settle profiles Sage X3's ITMMASTER table including management modes (lot, serial, sublot tracking) and maps each product to NetSuite's item configuration with proper tracking settings — flagging products where tracking mode translation requires business review.
BOMs and routings are restructured from X3's BOMD/ROUTING model to NetSuite's BOM format, with site-specific BOM alternatives identified and documented for the implementation team.
X3's analytical plan dimensions (up to 9) are mapped to NetSuite's segment model — Settle generates the dimension consolidation plan and flags analytical values that need to be merged or restructured.
Settle generates the inventory transformation including lot and serial number migration from STOCK/STOJOU, with costing method alignment validated between X3 and NetSuite before go-live.
Get your Sage X3 to Oracle NetSuite mapping analysis — see results in under an hour
Migration timeline: manual vs. Settle
Traditional approach
Timeline
4–12 months
Estimated cost
$600K–$1.5M
Team size
3–8 consultants
Typically requires
×Manual field mapping in spreadsheets
×Custom ABAP/SQL extraction scripts
×3–5 mock migration cycles
×Dedicated source system consultants
×Manual reconciliation testing
With Settle
Enterprise benchmarksTimeline
Days
Estimated cost
A fraction of consulting cost
Team size
1–3 internal resources
Included
✓Schema profiling & analysis
✓AI-generated field mappings
✓Transformation SQL
✓Validation & readiness reports
✓Production-ready load files
Common challenges migrating from Sage X3 to Oracle NetSuite
Product master with lot and serial tracking
Sage X3's ITMMASTER table stores products with management modes that control lot tracking, serial tracking, sublot management, and stock valuation methods per product. NetSuite uses item-level lot tracking and serial number settings. The management mode translation affects inventory control post-migration. Settle maps X3 product management modes to NetSuite's lot/serial configuration and flags products with tracking mode mismatches.
Explore related migrations →BOM and routing restructuring
X3 stores BOMs in the BOMD table with routing operations in the ROUTING table — both tied to product revisions and site-specific alternatives. NetSuite uses BOM records with component lines and routing steps. X3's BOM alternatives (site-specific BOM variants) don't have a direct NetSuite equivalent. Settle maps X3's BOM/routing structure to NetSuite's format and flags site-specific alternatives that require business decisions.
Explore related migrations →Analytical plan to NetSuite segments
Sage X3 uses an analytical plan with up to 9 analytical dimensions for cost allocation and reporting. NetSuite uses classes, departments, and locations as segments — a maximum of 3 standard segments plus custom segments. The dimensional model compression from X3's 9 dimensions to NetSuite's segment structure requires careful planning. Settle maps X3 analytical dimensions to NetSuite segments and flags dimension values that need consolidation.
Explore related migrations →Multi-site inventory and costing
X3 supports multi-site operations with site-level inventory, site-specific costing, and inter-site transfers. NetSuite uses locations for the same purpose but the costing model differs — X3 supports standard, average, FIFO, LIFO, and lot-level costing per site. Settle maps X3's site/costing model to NetSuite's location/costing structure and validates inventory valuation alignment.
Explore related migrations →Customer and supplier data with X3 BP categories
X3 uses a Business Partner concept similar to SAP — BPCUSTOMER and BPSUPPLIER are separate tables but share a common BP framework with categories, statistical groups, and payment conditions. NetSuite has a different customer/vendor structure. Settle maps X3 business partner attributes to NetSuite fields, translating payment terms, delivery modes, and category codes.
Explore related migrations →Sage X3 to Oracle NetSuite field mapping — what data moves
12 data objects typically migrated
| Source Object | → | Target Object |
|---|---|---|
| ITMMASTER (Products) | → | Item |
| BPCUSTOMER (Customers) | → | Customer |
| BPSUPPLIER (Suppliers) | → | Vendor |
| BOMD (BOM Details) | → | BOM / BOM Revision |
| ROUTING (Operations) | → | Routing |
| MFGHEAD (Production Order) | → | Work Order |
| SORDER / SORDERQ (Sales Order) | → | Sales Order |
| PORDER / PORDERQ (Purchase Order) | → | Purchase Order |
| STOCK / STOJOU (Inventory) | → | Inventory Adjustment |
| GACCENTRY (G/L Entries) | → | Journal Entry |
| SINVOICE (Sales Invoice) | → | Invoice |
| PINVOICE (Purchase Invoice) | → | Vendor Bill |
Typical enterprise migrations include 500K–10M+ records across these objects. Settle handles profiling and mapping at enterprise scale.
The cost of manual Sage X3 to Oracle NetSuite migration
Sage X3 to NetSuite migrations are driven by mid-market manufacturers and distributors outgrowing Sage X3's capabilities — particularly in e-commerce integration, multi-subsidiary consolidation, and modern reporting. Sage X3 (also known as Sage Enterprise Management) is used by 5,000+ companies globally in process manufacturing, discrete manufacturing, and distribution. Companies migrate when they need cloud-native architecture, better API connectivity, or when they're acquired by a PE firm standardizing on NetSuite.
The technical complexity comes from Sage X3's manufacturing-oriented data model. X3 stores products with multi-level BOMs (BOMD), routing operations (ROUTING), lot and serial tracking (STOCK, STOJOU), and sophisticated costing across multiple sites. The chart of accounts in X3 uses an analytical plan structure that differs from NetSuite's segmented account model. Additionally, Sage X3's custom development — screens, workflow rules, and crystal reports — contains business logic that must be documented.
Migration projects typically run 4–12 months through Sage or NetSuite partners. The data conversion workstream — mapping X3 tables to NetSuite objects, restructuring BOMs, translating the chart of accounts, and migrating transactional history — is the most labor-intensive phase because X3's schema is less documented than SAP or Oracle systems.
Consulting-led delivery for migrations in this class typically runs $600K–$1.5M. Settle prices it fixed and scoped — read the full cost breakdown.
Frequently asked questions
Related migration paths
Exceptions surface before the first load, not after the third.
Built by the team that ran Fortune 500 migrations by hand. Currently onboarding enterprise design partners on active migration programs.
Ready to migrate from Sage X3 to Oracle NetSuite?
Tell us about your migration and we'll show you how Settle can help.
No commitment required. We'll review your migration scope and share a preliminary assessment within 48 hours.