Product Update 415: Log data available for bank statement import process
The bank statement import process can now be logged,
allowing you to view the status of the bank statement import process and more
information of the transaction.
New setting in Bank settings
The Data log: Bank statement import check box has
been introduced in the General section at System ➔ General ➔ Settings, under the Bank
settings.

With this check box selected, the logging of the bank
statement import process will be enabled.
Log button available
With the Data log: Bank statement import check box
selected, the Log button will be available at Cash flow ➔ Entries ➔ Import.

New screen displayed upon clicking Log button
Upon clicking the Log button, the Data log: Bank
statement import screen will be displayed. This new screen displays an
overview of log information of all the bank statement import processes that
have been performed. The overview can be displayed in the simple or advanced
mode, as explained in the following:
Simple mode
The following is an example of the overview screen in the
simple mode:

The following is an example of the overview in the simple
mode and when exported to Microsoft Excel:

Advanced mode
The following is an example of the overview screen in the simple
mode:

The following is an example of the overview in the advanced
mode and when exported to Microsoft Excel:

Allocation and matching criteria for bank statement import
The following table lists the criteria in the bank statement
import that trigger the allocation and matching:
Criteria
for allocation
|
Criteria
for matching
|
- Payment reference
- Offset bank account
- Offset name
- Invoice number
- Bank creditor
- Allocation rules
|
- Run: EREF, ID
- Run: PREF, ID
- Run: Allocation rules
- Run 0: Offset bank account + Invoice amount
- Run 1: Debtor, Creditor, Our ref.
- Run 2: Debtor, Payment reference
- Run 3: Creditor, Payment reference
- Run 4: Bank account, Our ref., Amount
- Run 5: Bank account, Creditor, Payment reference
- Run 6: Debtor, Our ref.
- Run 7: Bank account, Amount
- Run 8: Our ref., Amount
- Run 9: Payment references, Due dates
- Run 10: Extra matching (This is
applicable only if the Extra matching check box is selected at System ➔ General ➔ Settings,
under the Bank settings)
|
Main Category: |
Support Product Know How |
Document Type: |
Release notes detail |
Category: |
Release Notes |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
28.073.609 |
Assortment: |
Exact Globe
|
Date: |
29-12-2017 |
Release: |
415 |
Attachment: |
|
Disclaimer |