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.
| Area | Types |
|---|---|
| Company setup | Countries, Currencies, Banks, Chart of Accounts |
| Stock setup | Warehouses, Storage Locations, Product Groups, Units of Measure |
| Parties and products | Parties (customers and suppliers), Items |
| People | Departments, Designations, Employees |
| Opening balances | Opening Stock, Opening Balances |
| Vouchers | Journal Vouchers, Cash Payments, Cash Receipts, Check Payments, Check Receipts, Cash In Bank |
| CRM | CRM Accounts, CRM Contacts, CRM Leads |
| Real estate | Projects, Phases/Blocks, Units, Customers, Leads |
| Bookings and services | Booking 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
- Existing items are matched by Item Code, then Item Name, then SKU, then Barcode. The first hit wins, so keep item codes unique.
- 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.
- 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.
- If TrackExpiry is true and the row has opening stock, OpeningBatchNumber and OpeningExpiryDate are required.
- 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.
Learn more about Biznsbook Data Import on biznsbook.com.