What can you import into Sage 500?

1 minute read time.

Sage 500 has multiple import tools and here is the list what each of them can import.

Imports using DataPorter:

Enter Inventory Transactions
Enter Invoices
Enter Journal Transactions
Enter Purchase Orders
Enter Quotes
Enter Sales Orders
Enter Vouchers
Maintain Account Segments
Maintain Accounts
Maintain Allocations
Maintain Customers
Maintain Item Classes
Maintain Items
Maintain Natural Accounts
Maintain Non-Inventory Items
Maintain Recurring Invoices
Maintain Recurring Transactions
Maintain Recurring Vouchers
Maintain Salespersons
Maintain Vendors
Physical Inventory – Enter Counts
Set Up Postal Codes

Imports using Data Import Manager:

Account Segments
Allocations
Bank Accounts
Banks
Budgets
Buyers
Closed Purchase Orders
Closed Sales Orders
Commission Classes
Customer (Contract) Pricing
Customer Classes
Customer Custom Fields
Customer Items
Customer Payment Terms
Customer Price Groups
Customers
Employees
General Ledger Custom Fields
GL Accounts
Inventory
Inventory Item Classes
Inventory Items
Item Custom Fields
Journals
Matrix Pricing by Customer Grp
Matrix Pricing by Product Grp
Natural Accounts
Non-Inventory Item Classes
Non-Inventory Items
Operations
Pending AP Vouchers
Pending AR Invoices
Pending Customer Payments
Pending GL Transactions
Price Sheets
Processing Cycles
Product Categories
Product Group Pricing
Product Price Groups
Purchase Order Custom Fields
Purchase Orders
Purchase Product Lines
Purchasing Departments
Reason Codes
Routings
Sales Commission Plans
Sales Order Custom Fields
Sales Orders
Sales Product Lines
Sales Tax Accounts
Sales Tax Classes
Sales Tax Codes
Sales Tax Schedules
Sales Teams
Sales Territories
Salespersons
Shipping Methods
Tender Types
Tools
Vendor Classes
Vendor Custom Fields
Vendor Items
Vendor Payment Terms
Vendors
Warehouse Bins
Warehouses
Work Centers

The following Sage 500 modules contain the Data Import Utility task:

GL Import
Account Information
Budget Data
Transactions

AP Import
Vendor Information
Pending and posted Vouchers
Vendor Transaction and Purchase History

AR Import
Customer Information
Customer Transaction and Sales History
Pending and posted invoices

IM Import
Item information
Inventory
Beginning Balances

Cash Management
Bank Reconciliation