LOC Statement Import
This function is used to import the paying bank files of the bank.
These imported files contain the drafts submitted to the issuing bank. In order to reconcile them with the drafts posted to draft management, or to reject them, two options are proposed:
- the automatic reconciliation can be started directly from the import function (see documentation Automatic reconciliation).
- Manual reconciliation (see documentation Manual reconciliation).
This function can be launched in batch mode.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
Presentation
The system submits a dialog box within which the paying bank note assignment criteria are specified:
- company, site;
- bank.
Enter the Name of the file to be imported.
It should also be mentioned if an automatic reconciliation need to be triggered with the drafts in draft management. If the case arises, the retained automatic reconciliation criteria are saved under the STD code of the automatic reconciliation function. They can be modified by calling the "criteria" context menu from the "automatic reconciliation" flag.
The reconciled lines of the imported paying bank notices can then be handled in the paying bank entry screen, then be returned to the bank.
The non-reconciled lines can be the subject of an automatic or manual reconciliation, at least until the notice has been re-exported to the bank (see documentation Paying bank export).
Close
Fields
The following fields are present on this tab :
Criteria
|
If this field is entered, a specific structure may be taken into account for the imported file. In addition, only the data from the specified file corresponding to the Bank ID Number are imported. |
|
Specify to which company the imported file data apply. |
|
Specify to which site the imported file data apply. The site must belong to the company specified in the previous field. |
Generation
|
Select Client to generate the extraction files in a folder on your computer or workstation. Select Server to generate the extraction files on a network or shared folder. Enter or select the server location (Access path) in the Directory field. |
|
Name of the file to import. For 'Server' destination, click the Selection icon to open the list of available volumes. In this list, you can select a directory/file. |
Block number 3
|
When ticking this field, after proper import of LOC statements, a reconciliation is launched between LOC statements and the paying bank notices for the various banks in the file. The reconciliation setups are by default those recorded in the STD memo associated with the Automatic Reconciliation function. However, these can be modified via right button Criteria. |
Close
Batch task
This function can be run in batch mode. The standard task RELLCR is provided for that purpose.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
"This site is in the XXX company"
In the criteria entry screen, the entered site is from a company different from the previously entered company.
"RELLCRBOR Import file not set up"
The setup of the RELLCRBOR bank file does not exist.
"Problem with the setup of the RELLCRBOR bank file Header/detail/statement total/general total recording"
The setup of the header/detail/statement total/general total recording does not exist.
"No issuer recording"
The file to be imported does not contain any issuer recording. The statement has not been created.
"Detail line after the general total line"
The file to be imported contains a detail recording after the general total recording. There is no statement creation for this detail line.
"No detail lines"
The file to be imported does not contain any detail lines. The statement has not been created.
"No statement total"
There is no statement total recording after the detail recordings. In that case, the statement has not been created.
"Several general total recordings"
The file to be imported contains more than one general total recording.
"Statement total after the general total"
The file to be imported contains a statement total recording after the general total recording. There is no statement creation for this statement total line.
"Several statement total recordings"
At least 2 statement total recordings follow each other. The statement has not been created.
"Header currency unknown"
The currency field of the issuer recording is different from <empty>, " F " and " E ". The statement has not been created.
"Statement(s) concerning declaration site XXX"
The paying declaration site code of the issuer recording is different from the first 5 characters of the ID Number of the bank account entered in the setups. The statement has not been created.
"Paying declaration site XXXXX"
The paying declaration site code of one of the detail recordings is different from the first 5 characters of the ID Number of the bank account entered in the setups. The statement has not been created.
"Paying office XXXXX"
The paying office code of one of the detail recordings is different from the characters no. 6 to 10 of the ID Number of the bank account entered in the setups. The statement has not been created.
"Account of the drawee XXXXXXXXXXX"
The drawee account of one of the detail recordings is different from the characters no. 11 to 21 of the ID Number of the bank account entered in the setups. The statement has not been created.
"Acceptance code #"
The acceptance code of one of the detail recordings is different from 0, 1 and 2. It is an information message.
"Amount equal to zero"
The amount of one of the detail recordings is equal to zero. This is an information message.
"Amount of statement XXX different from detail total"
The amount of the statement total recording is different from the total of the amounts of the detail recordings. This is an information message.
"Statement already imported"
A statement with the same creation date, the same processing center, the same number and the same amount has already been imported. The statement has not been created.
"General amount ### different from statement total"
The amount of the general total recording is different from the total of the amounts of the statement total recordings. This is an information message.
"Bank XXX Company YYY"
The bank account of the statement is attached to a company different from the company entered in the criteria entry screen.
"Bank ID number of the statement does not exist in the BANK file"
The Bank ID number of the statement is not attached to any bank account.
"PY7: Sequence number counter exceeded"
The number range for the paying bank notices has been exceeded. It needs to be set up again.
"PY7: Transaction cancelled"
Problem during the allocation of the paying bank notice number.