Sage X3 Import Template Worksheet
Sage X3 loads data through import templates that map a file layout onto an object such as items, customers or orders. This worksheet gives migration teams one place to list each object, template and file, and to see how many records were extracted, loaded and rejected.
| X3 object | Import template name | Source file | Records extracted | Records loaded | Records rejected | Reject rate | Status | Owner | Target date | |
|---|---|---|---|---|---|---|---|---|---|---|
24 | 0.5% | |||||||||
5 | 0.4% | |||||||||
0 | 0% | |||||||||
210 | 10% | |||||||||
380 | 100% |
Template names are examples from a naming convention. Sage X3 import templates are defined in the application and the object codes shown are common ones, so confirm names and folders in your own environment. Reject rate counts records not loaded, including those not yet attempted.
Profile my migration extracts
Optional: we can run a data quality review on sample extracts before your first load.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per object and source file. Enter the number of records extracted from the legacy system and update the loaded count after every test load. The worksheet calculates rejects and a reject rate for each row and for the whole migration. Use the status column to show where each object stands, and export to Excel to share with the steering group or with the data owners who must fix rejected records.
Load order and dependencies
Master data usually has to load before transactions. Item and business partner records come before bills of material, orders and open balances, and reference tables such as units, categories and tax codes come before everything else. A bill of material import fails if its components do not exist. Track dependencies by sequencing the target dates in this sheet so no object is scheduled before the data it depends on.
- Reference and setup tables first
- Items, customers and suppliers next
- Bills of material and routings after items
- Open orders and balances last, after reconciliation rules are agreed
Reading the reject rate
A small reject rate in a test load is normal and shows validation working. A high rate on one object points to a mapping or cleansing problem, such as missing mandatory fields, invalid codes or duplicate keys. Review the import log, fix the source data rather than loosening validation, and reload. Aim for zero unexplained rejects before the production load, and keep the final counts as reconciliation evidence.
Frequently Asked Questions
What is an import template in Sage X3?
It is a definition that maps columns in a file to fields of an X3 object and controls how records are validated and created. Templates can be run interactively or in batch, so a migration team can reuse them for each test load.
How many test loads should I plan?
Plan at least two or three full dress rehearsals before the production load. The first finds mapping errors, the second proves the fixes, and the last proves timing and reconciliation. Complex manufacturing data often needs more.
Why were my records rejected?
Common causes are missing mandatory fields, codes that do not exist in reference tables, duplicate keys, wrong date or number formats, and violating dependency order. The import log gives the line and message, which you should copy into your tracker.
Should rejects be fixed in X3 or in the source file?
Fix them in the source or in the transformation step so the process is repeatable. Manual fixes in the target are lost on the next reload and make reconciliation harder.
If your Sage X3 migration includes years of legacy history, we can help profile and clean the extracts before the first test load.
Related Tools
Sage 100 to Cloud Migration Assessment
A 10-question readiness score for companies on Sage 100 deciding when and how to move to a cloud ERP, with recommendations by result band.
Costing & FinanceSage Intacct Dimension Design Worksheet
An editable worksheet for designing Intacct dimensions: which standard and custom dimensions to use, value counts, requirements and examples.
Costing & FinanceSage 300 Period End Checklist
A module-by-module month end close checklist for Sage 300: subledgers, inventory, costing, bank and general ledger, with critical steps flagged.
More Other ERPs tools
See all- Sage X3 Database Tables Reference
- Sage X3 Maintenance Checklist and Schedule
- Sage X3 Private AI Layer Blueprint Generator
- Sage X3 AI Assistant Sizing and Value Calculator
- Sage X3 4GL (L4G) Syntax and Functions Reference
- Sage X3 Supervisor and Dictionary Tables Reference (ATABLE, ATABZON, ATABDIV, AUTILIS)
- Sage X3 REST API Query URL Builder (Syracuse api1)
- Sage X3 SOAP Web Service Request Generator (CAdxWebServiceXmlCC)
- Sage X3 Patch, Syracuse and Version Upgrade Checklist (V11, V12 and Later Releases)
New to Sage X3 and Sage 100? Start with the Sage X3 and Sage 100 guide and toolkit.
Keep exploring
Free tools
- Sage X3 Database Tables ReferenceKey Sage X3 tables by module with what they store, typical key columns and naming conventions for SQL and reporting.
- Sage X3 Maintenance Checklist and ScheduleA tick-box routine maintenance plan for Sage X3: database, batch server, Syracuse, backups, patches, security and testing.
- Sage X3 AI Assistant Sizing and Value CalculatorSize GPUs and estimate value for a private AI assistant on Sage X3. Enter named users, usage and cost assumptions to get concurrency, tokens per day, index size and payback.
ERP fixes and how-tos
- Sage X3 AP automation: from invoice capture to postingHow to automate accounts payable in Sage X3: invoice capture, matching to receipts and orders, import and posting, approvals and what still needs a human.
- Sage X3 Production Planning, Scheduling and TrackingHow Sage X3 production planning works: master data, MRP, work orders, scheduling and shop floor tracking, and what to set up first. Practical overview.
- Sage X3 AI Integration On-Prem: A Private ArchitectureHow to add a private AI assistant to on-prem Sage X3: SQL read replica, Syracuse SData and web services, retrieval index, local GPU model and audit trail.
AI on your ERP
- AI for Sage X3, Grounded in Your Own Ledgers and Stock DataAdd AI to Sage X3 finance and stock data without exporting it to a public model. On-prem and private-cloud LLMs for Sage X3 in the UK and France.
- AI for Sage X3 Purchasing and Stock: Orders, Receipts and LotsAI for Sage X3 purchasing and stock: PO review, supplier delivery analysis, stock status and lot questions over X3 data using GraphQL, SOAP and private models.
Integrations
- How to add AI agents to Sage X3How to add AI agents to Sage X3: a tool layer over SData and web services, read-first design, human approval on writes, and on-prem models for MRP and POs.
- How to connect Power BI to Sage X3Connect Power BI to Sage X3 through a warehouse, replica or API, use the on-prem gateway, build manufacturing dashboards and add natural-language questions.