Bank Transactions (tfcmg2500m000)

Use this session to view the lines of the selected bank transaction. To view more line details, double click a line or select a line and, from the appropriate menu, select Bank Transactions.

Note: LN allows you to execute the payment or receipt reconciliation process directly using this session. If the Type of Transaction field is set to Payment Reconciliation or Receipt Reconciliation, you can select the anticipated invoice in the Invoice/Anticipated Document field and set the Payment Document Status from Open to Complete.
Note: When a Receipt Transaction or a Receipt Reconciliation for a receipt schedule line or a Payment Transaction or a Payment Reconciliation for a payment schedule line is processed:
  • If unrealized currency differences are calculated and posted at the schedule line level or not calculated, the unrealized currency difference is reversed (if applicable) and the realized currency difference is calculated and posted per schedule line. In case of partial receipt/payment for the schedule line, this is processed proportionally for the specific schedule line.
  • If unrealized currency differences are calculated and posted at invoice level, the unrealized currency difference is reversed on invoice level and the realized currency difference is posted on invoice level.

To start this session, you must select transaction type Cash in the Transactions (tfgld1101m000) session.

The current session allows you to process these bank transactions:

  • Receipt Transaction
  • Payment Transaction
  • Unallocated Payment
  • Unallocated Receipt
  • Advance Payment
  • Advance Receipt
  • Journal
  • Receipt Reconciliation
  • Payment Reconciliation

Payment authorization

Only authorized users can make payments. In the Payment Authorizations (tfcmg1100m000) session, you can define the user's authorizations and maximum amounts for the various transactions.

You cannot create a payment for a purchase invoice to which a hold reason is linked. An assigned approver must remove the hold reason.

Field Information

Document

The transaction type selected in the Transactions (tfgld1101m000) session. This transaction type must be a Cash transaction type.

Document

The unique identification of the document used for the transaction type's financial transactions.

Beginning Balance

The sum of the opening balance and the transactions entered until the specified time, with a specified batch and transaction type.

If you linked a currency to the transaction type, LN can calculate this amount.

Bank Currency

The currency used for the bank transactions.

Bank Account

A bank account of your company.

Closing Balance

The open payable amount for the invoice-to business partner.

Note: If the Calculate Closing Balance Automatically check box is selected in the Transaction Types (tfgld0511m000) session, LN calculates the closing balance after each bank transaction line is added. The bank balance check is not performed when you close this session.
Bank Relation

bank relation

Tax Date

The date on which the Value Added Tax (VAT) is reported.

Note: 
  • This value is defaulted with the Document Date field.
  • This value can be modified if Type of Transaction is set to Journal
  • This value can also be modified for Type of Transaction set to Payment Reconciliation, Advance Payment or Advance Receipt, if the Calculate Tax on Advance Payments/Receipts check box is selected in the CMG Parameters (tfcmg0100s000) session.
Own Tax Data
Registration Code

The code of registration.

Identification Number

The unique alphanumeric code issued by the tax registration authority by which the enterprise or business partner is identified in the country of issue. The length and the structure of the ID differs by country and type.

The name which is legally approved.

Business Partner Tax Data
Tax Country

The name of the country in which tax are paid.

Tax State/Province

The name of the state in which tax are paid.

Identification Number

The unique alphanumeric code issued by the tax registration authority by which the enterprise or business partner is identified in the country of issue. The length and the structure of the ID differs by country and type.

The name which is legally approved.

Amount to be Reconciled

The amount that remains to be matched.

Balance

The sum of the opening balance and the transactions entered until the specified time, with a specified batch and transaction type.

If you link a currency to the transaction type, LN can calculate this amount.

Registration Document Number

The document number (such as an external receipt number, supplier payment identification, customer receipt identification and so on) registered with the bank transactions for advanced payments, advanced receipts and cash journals.

Note: 
  • This field is applicable only if the Slovakia and/or Czech Republic check boxes are selected Implemented Software Components (tccom0100s000) session.
  • The value in this field contains a maximum of thirty characters.
  • This value can be modified if Type of Transaction is set to Journal
  • This value can also be modified for Type of Transaction set to Advance Payment or Advance Receipt, only if the Calculate Tax on Advance Payments/Receipts check box is selected in the CMG Parameters (tfcmg0100s000) session.
Late Payment Surcharge

The late payment surcharge in the home currency.

Discount

The discount amount in the home currency.

Payment Difference

The payment difference in the home currency.

Factoring Commission

The factoring commission in the home currency.

The default factoring commission depends on the values entered for the Commission on Partial Payments in the CMG Parameters (tfcmg0100s000) session. You can change the amount.

Line

The line number.

The combination of line number and document number identifies the transaction.

Company Number

The financial company in which to post the transactions. The current company appears by default.

If the transaction type is Journal, you can select a different company. If you select a different company, LN automatically creates an intercompany transaction.

Group Tax Code

group tax code

Discount Date

The date on which the discount is applied on the invoice.

Late Payment Surcharge Date

The date of the late-payment surcharge.

Document Date

The date on which you carried out the transaction at the bank.

Default value

The current date appears, by default.

Based on this date, LN calculates the default amount received/paid, from the Receipt Transaction or Payment Transaction specified in the Type of Transaction field.

Dimension Description

The description of a dimension type.

The description of the dimensions is provided in the Group Company Parameters (tfgld0101s000) session.

Type of Transaction

Select the transaction category for the data you maintain in this session.

Journal description

Comments for the transaction.

Advance Payment Category

If you selected the Allow Advance Payment Category check box in the CMG Parameters (tfcmg0100s000) session and the posting method is Advance Payment, you must select a category.

BP Payment No.

Enter the payment number used for payments to the business partner.

Invoice-from/to Business Partner

Enter the invoice-from business partner code or invoice-to business partner code.

Bank Reference

If you use bank reference numbers, this is the bank reference number of the invoice.

Invoice/Anticipated Document

The transaction type of the invoice settled, fully or partially, by the bank transaction.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction
Document

The document number of the invoice settled, fully or partially, by the bank transaction.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction
Schedule

The payment schedule line number.

If you use receipts against shipments, this number indicates the shipment.

Payment Document Status

The status of the payment document associated with the bank transaction line.

Allowed values

Open
Partial
Complete
Rejected
Note: This field is enabled only if the anticipated invoice is selected in the Invoice/Anticipated Document field and set the value in this field from Open to Complete.
Pay-to/by Business Partner

The pay-to business partner or pay-by business partner.

Currency/Rate (Home-Bank)

The currency used for the bank transactions.

Rate

The currency exchange rate. This rate is defined in the Currency Rates (tcmcs0108m000) session.

The result of the selected rate.

Currency/Rate (Bank - Transaction)

The code of the currency and the rate used in the bank transaction and the ISO 4217 alpha currency code (recommended).

Note: 
  • This currency can be modified only if the Type of Transaction is set to Unallocated Receipt, Unallocated Payment, Advance Receipt or Advance Payment.
  • The currency is defaulted with the invoice currency, if the Type of Transaction is set to Receipt Transaction or Payment Transaction.
  • The rate can be modified only if:
    • The Type of Transaction is Receipt Transaction, Payment Transaction, Unallocated Receipt, Unallocated Payment, Advance Receipt or Advance Payment.
    • The Currency/Rate (Bank - Transaction) differs from the currency of the bank.
Bank Transaction Rate

The result of the selected rate.

Tax Country/Code

The tax country and tax code that apply to the transaction.

You can access this field:

  • If you select Advance Payment or Advance Receipt in the Document field.
  • If you select the Calculate Tax on Advance Payments/Receipts check box of the CMG Parameters (tfcmg0100s000) session.

LN only calculates the tax amount if the transaction amount is not less than the amount specified in the Minimum Amount for Tax Calculation field in the CMG Parameters (tfcmg0100s000) session.

Specify the country code for tax calculation. This country code must have been linked to the tax code in the Countries (tcmcs0110s000) session.

LN displays the country (for tax) linked to the discounts, late payment surcharges, and payment differences with respect to this partial payment in the Posting Data by Tax Code for Deductions (tfcmg0150m000) session.

Amount in Bank Currency

The payment amount, expressed in the currency defined in the Currency field.

Net/Gross

Either Net or Gross.

Amount in Transaction Currency

The payment amount, expressed in the currency defined in the Currency field.

The bank transaction currency.

Transfer Method

The way in which the transactions are transferred to the bank.

If the supplier pays the bank costs, you cannot change this field.

Sundry Costs

The bank costs that do not belong to any other specified category.

If the supplier pays the bank costs, you cannot change this field.

Reference

Enter the reference text.

Cash Flow Reason

The cash flow reason of the transaction.

Amount in Home Currency

The payment amount in the home currency.

Tax Amount in Bank Currency

The tax amount in the invoice currency.

If a tax code is linked to the invoice, LN displays the tax amount calculated on the basis of the data defined for the specified tax code in the payment/receipt currency.

Remittance

remittance code

Debit / Credit

Use this indicator to classify the amount as debit/credit. You can access this field if the transaction type is Journal.

Control Account

ledger account

Dimension 1

Enter the Dimensions.

Invoice Date

invoice date

Due Date

due date

Fiscal Period

The fiscal year and the fiscal period number of the bank transaction.

Fiscal periods are defined in the Periods (tfgld0105m000) session.

Reporting Period

The reporting year and the period number determine the reporting period of the bank transactions.

Reporting periods are defined in the Periods (tfgld0105m000) session.

Tax Period

The tax year and the period number determine the period used to post the tax reports for bank transactions.

Tax periods are defined in the Periods (tfgld0105m000) session.

Invoice/Schedule Balance

invoice balance

Sundry Cost in Home Currency

The sundry cost amount in the home currency.

Currency Difference

The currency difference amount.

Currency differences arise due to exchange rate fluctuations.

The currency used for the bank transactions.

Net Amount Payable to Business Partner

The net payable invoice amount.

Withholding Income Tax

The withholding income tax amount.

Withholding Social Contribution

The withholding social contributions amount.

Social Contribution Company Expense

The social contributions (expense) amount.

Discount Amount

If the invoice is paid within an allowed discount period, LN deducts this amount from the total invoice amount.

You can access this field if the value in the Document field is

  • Receipt Transaction
  • Payment Transaction

LN gives the default discount amount, if the value in the LPS/Discount for Partial Payments field in the CMG Parameters (tfcmg0100s000) session is

  • Fully
  • Proportionally

If the Block Discount Exceeding Tolerance check box is selected in the CMG Parameters (tfcmg0100s000) session and the discount exceeds the discount tolerance amount defined in the Payment Terms (tcmcs0113s000) session, you cannot process bank transaction.

Late Payment Surcharge Amount

The late-payment surcharge amount.

Late payment surcharge is calculated using the percentage linked to the invoice in:

  • Sales Invoices (tfacr1110s000)
  • Purchase Invoice Entry (tfacp2600m000)
Payment Difference

The payment difference for the selected invoice.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction

The payment difference amount and the percentage must both fall within the tolerances defined in t250he CMG Parameters (tfcmg0100s000) session or specifically for you in the Payment Authorizations (tfcmg1100m000) session.

Factoring Commission Amount

The factoring commission amount, expressed in the currency defined in the Currency/Rate (Home-Bank) field.

The default factoring commission depends on the values entered for the Commission on Partial Payments in the CMG Parameters (tfcmg0100s000) session. You can change the amount.

Related topics