Using hint text for bank imports
The Accounting Hint Texts table is used during bank imports to evaluate the payment reference (purpose). This functionality is only relevant for automatic account assignment. These fields are not used for application matching.
The primary purpose lies in the use of prefixes and suffixes, which must be maintained exactly as the corresponding numbers are defined in the system (see examples below).
| Option | Description |
|---|---|
| Type | Specifies the type of reference, such as Customer No., Vendor No., or Document No. |
| Hint Text | Defines abbreviations used by customers or vendors (for example, “CU” or “CU.NO.”). In most cases, letters are removed during processing of the payment reference, so this field usually does not need to be filled. |
| Prefix | Defines a prefix (see Example 1). Using AssistEdit, you can define placeholders for: Year (based on the work date), Year (based on the current date). These placeholders are automatically resolved at runtime. This is especially useful at the turn of the year. |
| Suffix | Defines a suffix (see Example 2). |
| Offset | If a value is entered, evaluation starts from the specified position. |
| Length | Specifies the length of the document number. |
| Pmt. Import Interface Code | If the hint text should apply only to a specific interface (for example, PayPal), enter the interface code here. |
Example 1: account no. with a prefix
Your customer numbers always start with “D”, followed by a 5-digit number (for example, D12345). When making payments, customers sometimes include the “D” prefix and sometimes omit it.
- Create a line with the type Customer No.
- Leave the Hint Text field empty
- Enter “D” in the Prefix field
The system will then search for both variants:
- With prefix: D12345
- Without prefix: 12345
Example 2: document no. with a suffix
Your invoice numbers always consist of a 6-digit number followed by the suffix “VR” (for example, 123456VR). Some customers include the suffix in their payment reference, while others do not.
- Create a line with the type Document No.
- Leave the Hint Text field empty
- Enter “VR” in the Suffix field
During bank import, the system will search for both variants:
- With suffix: 123456VR
- Without suffix: 123456