Skip to main content

Supported import types

You only see the types for modules your company has, and only those you have permission to write to. Parties, countries and currencies are always available.

AreaTypes
Company setupCountries, Currencies, Banks, Chart of Accounts
Stock setupWarehouses, Storage Locations, Product Groups, Units of Measure
Parties and productsParties (customers and suppliers), Items
PeopleDepartments, Designations, Employees
Opening balancesOpening Stock, Opening Balances
VouchersJournal Vouchers, Cash Payments, Cash Receipts, Check Payments, Check Receipts, Cash In Bank
CRMCRM Accounts, CRM Contacts, CRM Leads
Real estateProjects, Phases/Blocks, Units, Customers, Leads
Bookings and servicesBooking Resources, Booking Offerings, Historical Bookings, Collections Service Jobs, Collections Historical Payments, Field Service Sites, Field Service Equipment

Fixed Assets Tracking has its own import under its Assets screen.

Notes on Items​

  1. Existing items are matched by Item Code, then Item Name, then SKU, then Barcode. The first hit wins, so keep item codes unique.
  2. Quantity is written on insert only, as the opening balance. An update row that changes quantity is rejected. To load opening stock for existing items use the Opening Stock import.
  3. Opening stock appears in the Stock Ledger as an Opening Balance movement. With Accounting, its value is posted to the books. If it could not be posted (for example the opening date is in no open fiscal year, or the cost is zero), the result says so and you post the difference with a journal voucher.
  4. If TrackExpiry is true and the row has opening stock, OpeningBatchNumber and OpeningExpiryDate are required.
  5. Unknown Product Group and Unit of Measure values are created only if you chose that option. An unknown Warehouse, Preferred Supplier or Tax Group always fails the row.

Notes on CRM​

Lead, contact and account numbers are generated when the column is blank. Owners are matched on the HR employee code or email. Contacts can link to an existing CRM account but never create one, so import CRM Accounts first.

Not available yet​

Some modules have no import yet, for example price lists, purchase orders, sales history, BOMs and leave balances.