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) | |
Sales Open Items (GACCDUDATE) Customer Invoice Lines (BPCINVLIG) Customer Analytical Line (BPCINVLIGA) |
||
BIS (Supplier BP Invoice) | Purchase Invoices (PINVOICE) | |
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) |
|
Accounting Entry Lines (GACCENTRYD) |