The following is an overview of the basic tables and files relevant for the Work with open batches routine. The standard setup records are preloaded at installation and the function with the standard setup can be run without specific preparations. As the variety of functions can be defined in the listed tables, the setup work should depend on the user’s requirements and customs. These tables and files, for which the user may need to add a new and/or customize an existing record, are indicated by YES written into the Customize column.
Setting up basic data
How to set up templates for the detail entry panels is described in section Setting up detail panel templates below.
| Table/File | Additional info | Preloaded records | Customize |
|---|---|---|---|
| Settlement options | A settlement option defines:
|
The following system records are preloaded in the FIN application:
*MANUAL *DOC_TYPNO *DOC_BRNO *DOC_MLTEX *DOC_LIST *DOC_LIST3 *DOC_LISTM *DOC_LISTE See Loading data in A/R tables and files for detailed information. |
YES |
| Selection options | Selection options are used to control the way that open documents are displayed on the A/R settlement workbench panel. | The following standard records are preloaded in the FIN application:
*STDSELCTN The last settlement option is defined to display the Standard sequence and selection panel before the A/R settlement workbench panel. |
YES |
| Document settlement option | No user setup is required for this file. However, it may be adjusted.
Document settlement options control the action that should be taken for a document during settlement. The settlement option code can be manually selected for a document displayed on the A/R settlement workbench or automatically assigned by the system during the transfer of settlements from the interface. The standard Settle or Fully settle options may be chosen during the transfer to settle the transferred document as it would be settled with the option on the A/R settlement workbench. |
All the options that can be applied for a document displayed on the A/R settlement workbench panel are preloaded for this table. Some of them which can be applied for a document also during the import process are preloaded with the Allowed for batch parameter set to YES.
These are, for example Settle, Fully settle. See Loading data in A/R tables and files for detailed information. |
|
| Program function keys | For each detail entry panel, the set of the available functions is accessible via the Fnc list function key. It means that the standard customization of the function key assignment is enabled via Program function key maintenance. | The system file contains the standard set of the functions and the assigned function keys. | YES |
| Language table maintenance, special panel value | For some of the panel fields, for example for the Error code field, the list of possible values is defined in the Panel value control file.
To view the list on the panel in the required user language the translation needs to be completed for the language in the Language table. |
N/A | YES |
| Batch import options | The Batch import option defines the set of information which is mandatory in order to perform the import and update of transactions. It can be used as a parameter if the transactions import should be run as a batch job.
If the import is started interactively from the Work with open batches routine, then all the mandatory information can be entered directly on the panel. |
N/A | YES |
| Batch list profiles | The Batch list profile defines the list of the printouts that are mandatory to be printed at journal update. | The SYSTEM record is preloaded in the FIN application. | YES |
| System document type table | No user setup is required for this file.
The difference document type XDB is required to create cross-debtor settlements. The cross-debtor settlements are enabled if the standard settlement option *DOC_LIST is applied. The record must exist in the file. |
New system type XDB linked to the XDB document type is preloaded in the FIN application. |
|
| Document type table | No user setup is required for this file.
The difference document type XDB is required to create cross-debtor settlements. The cross-debtor settlements are enabled if the standard settlement option *DOC_LIST is applied. The record must exist in the file. |
New difference document type XDB linked to the system type XDB is preloaded in the FIN application. |
|
| Allocation categories | No user setup is required for this file.
The following categories are defined to classify the performed allocation processes:
The records must exist in the file. |
The following necessary system records are preloaded in the FIN application:
BATCH SERIES INTERF |
|
| Allocation objects | No user setup is required for this file.
The preloaded records define the programs for which the allocation procedures are implemented.
The records must exist in the file. |
The following necessary system records are preloaded in the FIN application:
PROG FSR490 PROG ASGR085 |
|
| Function controls | No user setup is required for this file. The preloaded function must be active. The Active/Inactive switch is foreseen only to simplify the system service, if any issues occur. | The ALLOCPRG function is preloaded as an active function in the FIN application. |
|
| Number series | No user setup is required for this file.
The preloaded number series is internally used by the settlement procedures. The record must exist in the file. |
The 911 number series is preloaded in the FIN application. |
|
| IFS communicator types | The table is optional.
If the Transfer transactions from IFS function should be used for loading Open batch interface files, then a dedicated IFS communicator type must be defined here. The IFS communicator may define the program which will:
The Batch import option, a parameter mandatory for the import from Open batch interface files, may be provided in this table. |
N/A |
|
| Extended number series | The file is listed here for information only.
An external number series may be defined here, in order to be used by the program which should load the Open batch interface files. |
N/A |
|
Setting up detail panel templates
The template handling is essential for the Work with open batches routine. Therefore, the standard setup of the template files which is preloaded at installation is shortly described here. Templates are applicable both for the manual and for the imported transactions creation. A template, which should be indicated for the import, is used as follows:
- To display the interface data on the entry panels, if a batch should be maintained in the Work with open batches routine.
- To initialize the data, which is not loaded into the Open batch interface files.
New templates can be created and maintained directly from the relevant detail registration panels: Batch and voucher headers, A/R payment, A/R Cash book details entry, Sundry debtor information.
| Table/File | Additional info | Preloaded records | Customize |
|---|---|---|---|
| Batch/voucher entry template | If additional voucher information is to be loaded into the SROKBVH file, then the dedicated template should be defined to show the additional fields:
For the SYSTEM template, the Display attribute for these fields is set to NO. Additionally:
|
The Batch/Voucher template SYSTEM is preloaded in the FIN application. | YES |
| Payment entry template | For the SYSTEM template, Display attributes for all the available fields is set to YES.
The Init from existing parameter is set to YES. It indicates that payment data which is not loaded into the SROKBPP file (for example, the debtor number) may be completed with the data retrieved from the document which is to be settled. Additionally:
|
The A/R payment template SYSTEM is preloaded in the FIN application | YES |
| A/R Cash book entry template | For the SYSTEM template, Display attributes is set to YES for all the available fields.
Additionally, the exchange rate related fields will be initialized with the values defined in the A/R control file. |
The Cash book header template SYSTEM is preloaded in the FIN application. | YES |
| Sundry debtor information template | For the SYSTEM template, Display attributes is set to YES for all the available fields. | The Sundry debtor information template SYSTEM is preloaded in the FIN application. | YES |
For more information, see About DC1 Financials interface environment.