You can define a special format for the payment file if the existing standard formats do not meet the requirements of your bank.
In the setup (Payments Import Setup) you define what user-defined formats can be used for. During import (Import Payment File) you can then select the option Custom Format.
Fields
Code
Specifies the code for the custom format.
Description
Specifies a description for the custom format.
Active
Specifies whether the custom format is completely set up and active. Only active formats can be used in payments import.
Bank Account No.
Specifies the bank account number for whom the format is valid.
Bank Account Name
Shows the bank account name.
Note
This field is filled in automatically if you enter the Bank Account No..
Bank Account IBAN
Shows the bank account IBAN.
Note
This field is filled in automatically if you enter the Bank Account Number.
Separator
Specifies the separator symbol for the fields.
Start Delimiter
Specifies the start delimiter for the fields.
End Delimiter
Specifies the end character for the fields.
Decimal Separator
Specifies the decimal separator for the fields.
No. of Fields
Shows the number of existing fields for this format.
Note
If you click in the field you will open the page Payments Import Custom Format Fields.
For more information, see Payments Import Custom Format Fields.
No. of Assigned Import Fields
Shows the number of assigned import fields for this format.
Note
If you click in the field you will open the page Payments Import Custom Format Fields.
For more information, see Payments Import Custom Format Fields.
File Structure
Shows the file structure with the separators of the import format.
Actions
Fields
Shows the list of the configured fields of the custom format, you can make the settings regarding the fields here.
Suggest Fields
With the function Suggest fields, the fields can be automatically read or suggested from the CSV file (header line). Each field in the file that is to be imported into the payments import must then be assigned to a field number of the import.
Actions, Setup
Import
This action imports a file with a user defined format in CSV format. The file must start with a header line containing the field names. A row or record cannot be longer than 1024 characters. After creating a format and setting up the separators used in the CSV file, the fields of the file and their assignment to the payments import can be set up. These files can be imported from other systems that you have already configured and exported using the export function.
Export
Use this action to export a custom format to a file. This exported file can be used for import into other databases.