Bill of exchange import
Use this function to import paying bank files.
These imported files contain the notes payable/receivable submitted to the issuing bank. In order to reconcile them with the notes posted to a "portfolio" (i.e. a group of notes P/R not due), or to reject them, two options are available:
- Automatic reconciliation: can be started directly from the import function (see Automatic reconciliation)
- Manual reconciliation (see Manual reconciliation)
This function can be launched in batch mode.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
Presentation
A dialog box opens where you can specify the paying bank notice assignment criteria:
- Company, site
- Bank
Enter the Name of the file to be imported.
It should also be mentioned that if an automatic reconciliation needs to be triggered with the portfolio notes P/R, the automatic reconciliation criteria are saved under the STD code in the Automatic reconciliation function. They can be modified by clicking the Criteria option from the Automatic reconciliation field.
The reconciled lines of the imported paying bank notices can then be managed in the paying bank entry screen, and then returned to the bank.
The non-reconciled lines can be the subject to an automatic or manual reconciliation, at least until the notice has been sent back to the bank (see 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 account 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
| No help linked to this field. |
|
|
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 bank account number 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 bank account number 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 bank account number 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 bank account number 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 account number of the statement does not exist in the BANK file"
The bank account 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.