Match Bank Statements (tfcmg5210m000)

Use this session to assign bank statements to open entries.

Field Information

Bank Statement Type

.

Default value

Bank Account Statement

Bank Relation

bank relation

Bank Statement Date

The date on the bank statement.

Electronic Bank Statement

electronic bank statement

Match Options

The options for matching a business partner's open entries with a bank statement line.

Allowed values

Match - Surplus on Aging / Unallocated

The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount is matched automatically to an open invoice based on aging. If no open invoice is available, the surplus amount is posted as ‘unallocated’.

Match - Surplus on Unallocated

The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount is always posted as ‘unallocated’.

Match - Surplus to be allocated Manually

The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount remains as unmatched needs to be allocated manually.

Advanced Reference Matching

If this check box is selected, Infor LN performs extended matching, where the description or document reference fields do not include the transaction type and document number only.

For example, if the document reference field include the text "ETEA9F169E9FF954A4FA77CDAE3663765AA" then 169 could be subtracted as document number which Infor LN executes for matching.

If this check box is cleared, Infor LN matches based on the 'Reference must Fully Match' logic.

In this case, Infor LN assumes that the description or document reference fields of the Electronic Bank Statement line (sequence) only contain the "Transaction type" + "Document number".

Examples are "ACR12345678", "ACR-12345678", "ACR 12345678" or "A9/1234" .

Allow Underpayments

If this check box is selected, and the Accounts Receivable invoice amount exceeds the bank statement line amount, the latter amount becomes the matched amount, and you accept a partial payment.

If the bank statement line amount applies to multiple invoices and the sum of these invoice amounts exceeds the bank statement line amount, the automatic matching process will match the relevant open invoices as much as possible.

If this check box is cleared, and the Accounts Receivable invoice amount exceeds the bank statement line amount, these amounts will not be matched. Consequently, no partial payments are found and no user intervention will be required.

Use Payment Difference Tolerance

If this check box is selected, the payment difference tolerances defined in the CMG Parameters (tfcmg0100s000) and Payment Authorizations (tfcmg1100m000) sessions are taken into account.