Bank Relation (tfcmg0110s000)

Use this session to maintain the bank relation, used to process the payments to and from your business partners.

Note: If the Petty Cash check box is selected in the CMG Parameters (tfcmg0100s000) session, the name of this session is updated to Bank Relation (tfcmg0110s000) session.

Field Information

Bank

bank relation

Details
Bank details
Description

The name of the bank.

Account Type

The type of the account you are holding with the bank.

Allowed values

Normal
The account is a regular account.
Blocked
The account is a blocked account used to pay subcontractors using the Dutch subcontracting functionality WKA (Wet Ketenaansprakelijkheid).
Other
The account type is country-specific.
Cash Register
The entry is a cash register.
Bank Branch

The branch office of the bank.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Allow MT940 Format

Select this check box if the bank relation accepts electronic bank files in SWIFT-MT940 format.

Note: This field is enabled only if:
  • The value of the Account Type field is other than Cash Register.
  • The International Bank ID is specified for the Bank Branch Code associated with the bank relation in the Bank Branches (tfcmg0511m000) session.
Allow QR-bill

If this check box is selected, a QR-bill with the international bank account number or QR-IBAN is sent to the business partner

Note: This field is enabled only if the Switzerland check box is selected in the Implemented Software Components (tccom0100s000) session.
Bank Account

Specify your bank account number.

IBAN

Specify the international bank account number.

This account is used for payments and direct debits if the Use IBAN Account check box is selected in the Payment/Receipt Method (tfcmg0140s000) session.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
QR-IBAN

The QR- international bank account number used for the bills processed within Switzerland.

Note: 
This field is enabled only if:
  • The Switzerland check box is selected in the Implemented Software Components (tccom0100s000) session.
  • The Allow QR-bill check box is selected.
VAT Bank Relation
The VAT code associated with the bank relation.
Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Bank Balance
Bank Currency

The currency used for the bank relation.

Other Currencies allowed

If this check box is selected, you can use the bank relation for transactions in a currency other than the one entered in the Bank Currency field.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Bank Balance

The amount in a bank account available for payments, expressed in the currency defined in the Bank Currency field.

Currency

The home currency.

Exclude from Cash Forecast

If this check box is selected, amount related to bank relation must not be considered for cash forecast calculation.

Document Numbering / Compression
Transaction Type

Select the transaction type to post the bank transactions for the selected bank relation.

You can use the transaction type to do the following:

  • To post only the actual payments, and not anticipated payments.
  • For bank reconciliation of the anticipated documents attached to the bank relation.
  • To post remittance advice.
Note: If the Account Type field is set to Cash Register, the Transaction Subcategory of the transaction type must be set to Petty Cash Transaction.
Reversal Trans. Type

You can use the transaction type entered here to reverse fast cash postings in the Remittance Advice Lines (tfcmg2151m000) session.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Debit/Credit Notification Trans. Type

The transaction type that indicates whether the transaction is a debit or credit entry.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Options
Blocked for Payments

If this check box is selected, you cannot make payments through the bank account number linked to this bank relation.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Blocked for Direct Debits

If this check box is selected, you cannot carry out the direct debit procedure through the bank account number linked to this bank relation.

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Options
Default Priority
Payments

The priority of the bank relation for the automatic payment procedure.

You can enter a priority if the Bank Relation for Payments field of the CMG Parameters (tfcmg0100s000) session is empty.

If you select a bank relation for automatic payments in the CMG Parameters (tfcmg0100s000) session, you cannot enter a priority because LN uses the specified bank relation for all payments.

Direct Debits

The priority of the bank relation in the automatic direct debits procedure.

You can enter a priority if the Bank Relation for Direct Debits field of the CMG Parameters (tfcmg0100s000) session is empty.

If you select a bank relation for automatic direct debits in the CMG Parameters (tfcmg0100s000) session, you cannot enter a priority because LN uses the specified bank relation for all direct debits.

Document sent to bank
Transaction Type

Use this transaction type if checks are sent by means of the Send Checks to Bank (tfcmg4130m000) session.

Series Number

The sequence number that belongs to the Transaction Type.

Files
Device for Trade Note Files

The number of the printer on which the actual trade note file is printed, or the device that has created the file.

Path Trade Notes File

The directory and the file used in the Send Checks to Bank (tfcmg4130m000) session to send trade notes to the bank.

Path for EBS Files

The directory where the Electronic Bank Statements (EBS) files are stored. These files are received from a bank.

Path For EBS Archive

LN moves the converted Electronic Bank Statements (EBS) file from the directory defined in the Path for EBS Files field to the archive directory.

This prevents repeated conversion of the same files, which produces duplicate transactions.

The path for the archives directory is entered here.

UTF-8 File Format

If this check box is selected, the EBS file to be converted can contain 8 bit unicode characters according the Unicode Transformation Format (UTF). This value is used as default in the Convert Electronic Bank Statements (tfcmg5202m000) session for the UTF-8 File Format option.

Customer Details
Customer Code Extension

An additional customer code extension number for a bank account.

The customer code extension can be used to divide the bank's customers into subgroups. The extension is added to the customer code that you defined in the Bank Branches (tfcmg0511m000) session.

Division

The part of your organization for which you define the bank relation. For example, a division can reflect a department.

Credit Details
Credit Limit Check

The type of the credit limit check.

Allowed values

No Check

LN posts the receipt transaction without checking the integration transactions of the advance installment.

Warn User

If the integration transactions for advance installments are not posted, LN displays a warning message. If you acknowledge the message, LN continues to process the receipt transaction.

For automatic processes, Warn User and Block User often have the same result. LN blocks the process.

Block User

If the integration transactions for advance installments are not posted, LN blocks the receipt transaction.

Default value: No Check

Note: This field is enabled only if the value of the Account Type field is other than Cash Register.
Credit Limit Check in Cash Transactions

The credit limit check applicable for the cash transactions.

Allowed values

No Check

LN posts the receipt transaction without checking the integration transactions of the advance installment.

Warn User

If the integration transactions for advance installments are not posted, LN displays a warning message. If you acknowledge the message, LN continues to process the receipt transaction.

For automatic processes, Warn User and Block User often have the same result. LN blocks the process.

Block User

If the integration transactions for advance installments are not posted, LN blocks the receipt transaction.

Note: This field is enabled only if:
  • The Account Type field is other than Cash Register.
  • The Credit Limit Check field is set to Warn User or Block User.

One of the following actions is displayed:
  • If this field is set to No Check, LN does not check the Credit Limit Amount provided by the bank.
  • If this field is set to Warn User, The warning message Insufficient bank balance at bank [...]; credit limit being utilized. is displayed and allows you to continue with the payment process.
  • If this field is set to Block User, the warning message Insufficient bank balance at bank [...]. is displayed and cancels the payment process.
Credit Limit Amount

The amount of credit provided by the bank.

Note: This field is enabled only if the Credit Limit Checkfield is set to Warn User or Block User.
Anticipated Payments Amount

The total amount of the anticipated payments related to the bank, which are under payment process.

Anticipated Receipts Amount

The total amount of the anticipated receipts related to the bank, which are under receipts process.

Bank Balance with Credit

The balance amount in bank including credit limit amount.

Bank Balance with Credit= (Credit Limit Amount + Bank Balance + Anticipated Receipts Amount) - Anticipated Payments Amount

Related topics