Search term list
Use this function create a list of search terms related to fixed identifiers, like a BP name or text in a bank transaction. This search is used in the advanced bank statement import process.
These search terms can be used to match a transaction to a certain general ledger account or BP account.
In Bank import settings, select the Search term list check box to apply these terms to the search and then select when to apply the terms: before or after the standard search. If you select after, it only applies to transactions with a C status.
Setting up a list
- Select Create in the Action panel to set up a new list.
- Enter the Company for this search list and select a File format and a Bank.
- Select the Append icon to create the list.
When adding terms, you cannot use wildcards. If you enter several texts as a single criteria, such as "Lease contract," the exact string must be found. If you center several criteria, you need to link them with AND, for example "Reference text and amount."
Payment related settings
You can enter either a general ledger or a BP account but not both. For a BP account, a control account must also be given.
The sign of the payment attribute entered must fit the payment sign of the transaction (or set to payment direction). Otherwise there is no match, even when other criteria apply.
The account structure of the payment attribute needs to be Bank <=> BP or Bank <=> Account.
If a general ledger account subjected to VAT is used, a VAT code is mandatory.
A (fixed) distribution can be used if either the general ledger or the BP account are set up for analytical accounting.
(missing or bad snippet)Prerequisites
Refer to the documentation on Implementation.
Actions
Select Create to define a new search term.
File format (field FILFMT) |
Enter a file format to restrict the search list to a certain file format. |
Bank (field BAN) |
Enter a bank to restrict the search list to a certain bank. |
Reference (field SEAPAYREF) |
Enter text to search for in the payment reference fields that have been stored by the import segment definition in [F:BSIIMPD]FREREF(0) to (9). |
BP reference (field SEABPRREF) |
Enter text to search for in the BP reference fields that have been stored by the import segment definition in [F:BSIIMPD]BPRREF(0) to (5). |
Description (field SEAOTH) |
Enter text to search for in the payment description that have been stored by the import segment definition in [F:BSIIMPD]DES). |
BTC reference (field SEABTC) |
This field is dedicated to search terms in the subdetail for CAMT.053/.054 transaction entries. It allows you to add bank transaction codes as a concatenated string. The value in the BTC reference field consists of concatenated values for Domain, Family, and Sub-family or the concatenated values for Code and Issuer when the Proprietary element is present in the bank transaction section of the statement. Bank transaction codes on C-level transactions in CAMT.053/.054 statements are currently not taken into account in the standard setup for element mapping and bank import segment definition. |
Amount (field SEAAMT) |
Amount to search for. You can only enter positive values in this field. |
Attribute (field DENCOD) |
Enter the payment attribute that is used when generating the payment. The sign of the payment attribute entered must fit the payment sign of the transaction (or set to payment direction). Otherwise there is no match, even when other criteria apply. The account structure of the payment attribute needs to be Bank <=> BP or Bank <=> Account. |
Site (field FCY) |
Enter the site that is used for payment generation. If the bank account is linked to a dedicated site, both sites must be the same. |
Account (field ACC) |
Enter the general ledger account to use if the payment should be assigned to a general ledger account. Typical examples for this would be expenditures for rent, leasing, bank fees, etc. You can enter a general ledger account or a BP account, but not both. If a general ledger account subject to VAT is used, a VAT code is mandatory. A (fixed) distribution can be used if the general ledger account is set up for analytical accounting. For one search term, you can enter a general ledger account or a BP account, but not both. |
BP (field BPR) |
Enter the BP account to use if the payment should be assigned directly to a BP account. Note that in this case a payment without direct relation to an invoice is generated. You can enter a general ledger account or a BP account, but not both. For a BP account, a control account must also be given. A (fixed) distribution can be used if the BP account is set up for analytical accounting. For one search term, you can a general ledger account or a BP account, but not both. |
Control (field BPRSAC) |
Enter a control account if you entered a BP account to use if the payment should be assigned directly to a BP account. |
Tax (field VAT) |
Enter a VAT code if the general ledger account you entered to use for payment is subject to a VAT tax. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
The only error messages are the generic ones.
Tables used
The following tables are implemented by the function :
Table | Table description |
|---|---|
BSISEALIS [BSILIS] | Search term list |