1. Home
  2. /
  3. Setup Guides
  4. /
  5. Financials
  6. /
  7. Open batch
  8. /
  9. Open batch interface files

Open batch interface files

Related topics

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:

  • On document level – a Pseudo account must be specified in Work with document types.
  • On Cash book level – a Cash book bank acc must be specified in Work with document types.
  • On voucher level – a Pseudo account must be specified in Work with voucher types.
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:

  • The Check voucher amount field value must be set to YES to turn on the automatic test verifying if the Amount to apply, or the difference between Closing and Opening balance, matches the total amount of the payments registered in the voucher.
  • The Pseudo account field must be completed if the accounting should be automatically performed on the voucher level.
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.

Related topics