Currently, the interface files for import of the A/R payments, A/R Cash book payments and A/R settlement transactions are provided (see section Overview below). The fields which are not loaded may be automatically completed by the system upon transfer. It is done either based on the definition of the template, which is indicated for the transfer, or by applying the standard defaulting procedure, the same which is run upon manual registration.
Due to the variety of bank file layouts, the system does not provide any standard function that interprets bank data and loads the bank-related information into the Open batch interface files. However the users, who import bank data from the IFS with the Transfer transactions from/to IFS function, have the possibility to define an IFS communicator type dedicated to handle the Open batch interface files. The IFS communicator type may define the program, which will transfer bank data from the IFS, interpret bank data, load the data into the Open batch interface files and finally run the import into DC1.
Overview
The following is an overview of the Open batch interface files.
File name | File description | Additional info |
---|---|---|
SROKBPP | A/R payment interface file | This is the main interface file for the payment import to DC1. One payment entry per KBPP record is always created.
The Document type indicated for the transferred payment must be defined with an automatic contra accounting. Automatic contra accounting can be defined as follows:
|
SROKBPS | A/R settlement interface file | This is the file containing the settlements that are related to payments imported via the SROKBPP file. The Settlement option must be indicated in the file to determine the settlement method that should be applied.
If the standard settlement option *DOC_TYPNO or *DOC_BRNO is indicated, then the file should also contain the identification of the document that should be settled with the transferred payment. If the settlement option *DOC_LIST (or an option which is based on this one) is indicated, then the list of the documents that should be settled with the imported payment, must be loaded into the separate file – the SROKBSP file. |
SROKBSP | A/R settlement pre-interface file/documents list | The list of the documents to be settled with the imported payment should be loaded into this file. This only applies if the standard settlement option *DOC_LIST (or an option which is based on this one) is indicated in the corresponding SROKBPS record. |
SROKBVH | Voucher additional info interface file | Additional voucher-related information, such as Amount to apply, Opening/Closing balance, can be provided in this file.
The following field values set for the applied voucher type in Work with voucher types determine how the additional information is processed:
|
SROKBCB | Cash book header interface file | If the transferred payment is an A/R Cash book payment, then the additional Cash book related information should be provided in this file.
The document type indicated in the file must be a Cash book payment, which means the Liquid entry panel field value is set to 8 for the document in Work with document types. |
SROKBTX | Text interface file | The text linked to the transferred payment can be provided in this file. |
SROKBSN | Sundry information interface file | The sundry information linked to the transferred payment can be provided in this file. |