Requirements for the Generalized Interface

The information is moved in the form of a file, which contains one or more journal batches. This file must use a specific format.
Table 1. File format for importing journals via the generalized interface
Part Function
File The files must be ANSI ASCII, this is, the ordinary text file format for windows.
Header/Detail Each file must have header records containing general information about the batch. The header record must appear before any detail record for each batch. Each batch in the file must have one or more detail records that post debit or credit amounts to certain accounts. The format is:
  • Header for batch 1
  • Details for batch 1
  • Header for batch 2
  • Details for batch 2
  • Etc
Line Separator Each row is one unit (record) of information. The rows (records) in the file need to end with CR+LF (carriage return and row feed).
Amounts The following format is allowed for numerical values 10.00 or -10.00
Field Separator Each row contains a number of fields, separated by a ";". It is possible to use any other character, but then the default field separator has to be defined in the import parameters.