Go to the main menu, click the expanded menu and choose Administration > Import/Export
To start a new import, click the plus icon in the upper-right corner of the screen.
Fill in a name for the import in the popup that appears.
Now you will be asked which file you are uploading. We currently support Sie4, Saft-T Accounting and CSV.
Import will automatically suggest default values for Customer, Vendor, Project and Department (as defined in format documentation), but VAT codes must be entered even if the file contains them.
Dimensions are defined in the file as #DIM <dimension ID> "dimension name"
Objects associated with each dimension are defined as # OBJECT <dimension ID> "Object ID" "Object Name"
- #DIM 8 "Customer" #
OBJECT 8 "100" "Customer AS"
- #DIM 1 “Department” #
OBJECT 1 “1” “Oslo”
Analysis codes in SAF-T Financial XML can be found in AnalysisTypeTable.
The import module proposes default codes for the following devices:
- TransactionType (B) or Document Type
- Project (P) or Project
- Employee (E) or Employee
- Department (A) or Department
<AnalysisType> P </AnalysisType>
<AnalysisTypeDescription> Project </AnalysisTypeDescription>
<AnalysisID> 100 </AnalysisID>
<AnalysisIDDescription> Estvoldv. 6 </ AnalysisIDDescription>
</ Analysis Type Table Entry>
<Analysis Type Table Entry>
<Analysis Type> A </ Analysis Type>
<AnalysisTypeDescription> Series </ AnalysisTypeDescription>
<AnalysisID> 1 </ AnalysisID>
<AnalysisIDDescription> Oslo </ AnalysisIDDescription>
The following fields are used from the XML file and linked to corresponding fields in CRM:
|Customer / SupplierID||CompanyIds|
|Bank Account||Bank Account|
OBS. If the address is missing the country field in XML, then the client country is used by default.
To match the table from the file to the fields in 24SO:
- First, select the import type
- Select columns from file and match with 24SO fields via the drop-down list under "Data type"
Skip Headers: Use this if the first row of the table contains headings (as in the example above).
Separators are automatically detected upon import, so file/data must contain at least 4 rows of data.
Date Format: Specify the date format used in the file.
Decimal separator: Select the decimal separator used in the Amount, Debit or Credit field.
Supported import types and associated data types:
- CRM (companies)
- PostalAddress (Street, ZipCode, Area, Country)
- VisitAddress (Street, ZipCode, Area, Country)
- DeliveryAddress (Street, ZipCode, Area)
- InvoiceAddress (Street, ZipCode, Area, Country)
- ReturnAddress (Street, ZipCode, Area, Country)
- isCustomer (default)
- isSupplier (1 or 0)
- Tax code
- Created at (date)
- Customer / Supplier No
- CID / CID