This feature allows to import bank messages in ISO20022 formats: pain.002.001.003 status return messages and camt.054.001.002 debit advice on the Vendor payment transfer form.
To use this feature, following setup should be completed:
- Import ER configurations "ISO20022 Camt.054" and "ISO20022 pain.002" from the LCS and select it on the vendor Method of payment form in the Return format configuration and Return format secondary configuration fields. It will require to activate Generic electronic Return format for the selected method of payment.
- Set up mapping of status codes between pain.002 statuses and vendor payment journal statuses on the Return format status mapping form.
Example setup:
| Return status | Payment status |
|---|
| RJCT | Rejected |
| ACCP | Accepted |
| ACSP | Recieved |
- Set up pain.002 error codes and descriptions on the Return format error codes form per external ISO20022 Status reason codes.
Example setup:
| Code | Name |
|---|
| AC01 | IncorrectAccountNumber
|
| AC02
| InvalidDebtorAccountNumber
|
| AC03 | InvalidCreditorAccountNumber
|
| AC04 | ClosedAccountNumber
|
| AC05 | ClosedDebtorAccountNumber
|
| AC06 | BlockedAccount
|
| ... | ... |
- If camt.054 file contains transaction charges which you decide to post along with posting of incoming payment, create payment fee on the vendor Payment fee form, and then associate it with the bank account on the Payment fee setup on the Methods of payment form.
To run the file import, open vendor payment transfers form and click Return file - vendor button. On the dialog screen select method of payment which have required settings for ISO20022 files and press OK. Then, select which file format do you plan to import and click OK. On the opened dialog, specify required parameters and path to the file location and click OK.
If you're importing pain.002 file, then status of vendor payment lines will be updated according to the information in imported file.
If you're importing camt.054 file, then additional parameters should be specified:
- Fee ID - new Payment fee lines will be created in vendor payment journal line if charges amount is present in camt.054 file.
- New journal name, New journal description - payment journal parameters where processed payments will be transferred. After transferring, new voucher numbers should be assigned within the new journal. See the Known limitations section for more information.
-
Import direct debit transactions - activate Import direct debit transactions if outgoing direct debits need to be imported to the vendor payment journal.
- Journal name - define a new journal name for the imported direct debit transactions
- Settle transactions - activate if imported vendor payments will need to be settled with invoices found in the system.
Imported information can be reviewed on the Payment transfers form.
In case of any issues in records in the file, they should be imported as is (i.e. with empty vendor account if it is not possible to find one).