Sage X3 Predefined Import Templates

This topic provides the list of modules that are migrated when performing data migration to Sage X3 v12.

Available Sources

Sage 100

Sage 300

Sage X3 (older version)

Sage 500

Sage 1000 UK

Destination Modules in Sage X3

Module	Entity	Field Validation
BIC (Customer BP Invoice)	Sales Invoices (SINVOICE)
BIC (Customer BP Invoice)	Sales Open Items (GACCDUDATE) Customer Invoice Lines (BPCINVLIG) Customer Analytical Line (BPCINVLIGA)
BIS (Supplier BP Invoice)	Purchase Invoices (PINVOICE)
BIS (Supplier BP Invoice)	Purchase Open Items (GACCDUDATE) Customer Invoice Lines (BPCSINVLIG) Customer Analytical Line (BPCSINVLIGA)
BPC (Customers)	Customers (BPCUSTOMER)	Category, Account Code, Payment Term, Tax Rule, Currency, Sales Rep, Statistical Group 1, Statistical Group 2
	Customer Addresses (BPADDRESS)	Postal Code, City
	Customer Contacts (CONTACT)
	Bank Details (BID)	Country
	Ship-To-Customer (BPDLVCUST)
BPS (Suppliers)	Suppliers (BPSUPPLIER)	Category, Account Code, Payment Term, Tax Rule, Currency, Delivery Mode, Statistical Group 1, Statistical Group 2
	Supplier Addresses (BPADDRESS)	Postal Code, City
	Supplier Contacts (CONTACT)
	Supplier Bank Details (BID)	Country
ITM (Products)	Products (ITMMASTER)	Category, Stock Unit, Purchase Unit, Sales Unit, Pack Unit 1, Pack Unit 2, Tax Level 1, Accounting Code
	Customer Product (ITMBPC)	Customer, Packing Unit 1, Packing Code
	Supplier Product (ITMBPS)	Supplier, Pack Unit, Purchase Unit
	Products - Sales (ITMSALES)
ITF (Products - Sites)	Products - Sites (ITMFACILIT)	Product, Site, ABC Class, Valuation Method, Location Type (Line 1), Location (Line 1), Location Type (Line 2), Location (Line 2), Container, Packing Unit
GAC (G/L Accounts	Accounts (GACCOUNT)
GAS (Accounting Entries)	Stock Movement Detail (SMVTD) Stock Movement Header (SMVTH) Stock Journal (STOJOU) Accounting Entries (GACCENTRY) Analytical Accounting Line (GACCENTRYA)
GAS (Accounting Entries)	Accounting Entry Lines (GACCENTRYD)