Matching Results (tfcmg2500m100)
Use this session to view the results of automatic and manual matching.
Field Information
- View
-
- Electronic Bank Statement
-
electronic bank statement
- Matching Status
-
- Converted
- Importing in Process
- Imported
-
The initial status of a bank statement that was received via a BOD.
- Validation in Process
- Not Applicable
- Validation Warnings
- Validated
- Matching in Process
- Partially Matched
- Conversion in Process
- Fully Matched
- Posting in Process
- Posting Errors
- Posted
- Exception
-
If this check box is selected, one or more errors or warnings exist.
- Lines
-
- Cash 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.
- Line
-
The line number.
The combination of line number and document number identifies the transaction.
- Company
-
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.
- Bank Statement Line
-
The sequence number of the bank statement line, always starting with value “1”.
- Bank Statement Sequence
-
The bank statement sequence number from the bank.
- Budget Exception
-
If this check box is selected, a budget exception or an error occurred.
To correct the problem, you can decrease the amount, or use a different budget account by changing the ledger account and/or dimensions. If no error occurred in this area, the budget controller must resolve the exception. In case of a setup error, the error must be corrected in the area in which it was caused.
- Deductions
-
- 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.
- Details
-
- General
-
- 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.
- Type of Transaction
-
Select the transaction category for the data you maintain in this session.
- 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.
- Bank Reference
-
If you use bank reference numbers, this is the bank reference number of the invoice.
- Invoice/Payment Details
-
- Invoice-from/to Business Partner
-
Enter the invoice-from business partner code or invoice-to business partner code.
- 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
- BP Payment No.
-
Enter the payment number used for payments to the business partner.
- Line
-
- Amounts in Bank/Transaction Currency
-
- Amount in Bank Currency
-
The payment amount, expressed in the currency defined in the Currency field.
- Amount in Invoice Currency
-
The payment amount, expressed in the currency defined in the Currency field.
-
The bank transaction currency.
- Amounts in Home Currency
-
- Currency Difference
-
The currency difference amount.
Currency differences arise due to exchange rate fluctuations.
- 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.
- Details
-
- 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.
- Own Tax Data
-
- Group Tax Code
- Tax State/Province
- The state and/or
province within the tax country for which the
registration codes are maintained.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Registration Code
- The user defined
code that identifies the registration.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Identification Number
- The unique tax
identification number associated with the registration
code.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Legal Name
- The name linked to
the own registration ID that can be used on the legal
reports.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Business Partner Tax Data
-
- Tax Country
- The code of the
tax country of the business partner associated with the
transaction.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Tax State/Province
- The state or
province of the country of the business partner for
which the tax registration is defined.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- BP Identification Number
- The tax
identification number of the business partner
to which the registration type is linked.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Legal Name
- The name linked to the
business partner registration ID that can be used on
the legal reports.Note: This field is displayed only if the Extended Registration Management field is set to Active in the Concept Activation (tcemm4600m100) session.
- Discount Date
- The date on which the discount is calculated.
- Late Payment Surcharge Date
- The late payment surcharge date.
- 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 Line Number
-
The payment schedule line number.
If you use receipts against shipments, this number indicates the shipment.
- Target Company
-
The financial company to which the transactions must be posted.
- Series No. Composed Payment
-
The sequence number that belongs to the Transaction Type.
- Pay-to/by Business Partner
- Journal description
-
Comments for the transaction.
- 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.
- 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:- The 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 set to 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.
- This field is defaulted from the Original Rate if the currency of the invoice is the same as the Original Transaction Currency.
- If the Type of Transaction is set to Unallocated Receipt, Advance Receipt, Unallocated Payment or Advance Payment, the Currency (Transaction) is defaulted from the Original Transaction Currency and the Rate (Bank-Transaction) is defaulted from the Original Rate.
- Journal description
-
The result of the selected rate.
- 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.
- Net/Gross
-
Either Net or Gross.
- Payment Document Status
- 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.
- 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 the 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.
- 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
- 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
- Dimensions
-
Enter the Dimensions.
- Dimension 2
- The second dimension to which the transaction must be posted.
- Dimension 3 - 12
- The dimensions to which the transaction must be posted.
- Ledger Account
- Dimensions
-
The first dimension to which the transaction must be posted.
- Dimension Description
-
The dimension description.
- Cash Flow Reason
-
The cash flow reason of the transaction.
- Transaction Template
- Tax Country/Code
-
The tax country to which the transaction template applies.
- Invoice Date
- Due Date
- Tax Period
-
The year and the tax period in which the tax over the invoice amount is settled.
- Tax Date
-
The date on which the Value Added Tax (VAT) is reported.
Note:- 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, only if the Calculate Tax on Advance Payments/Receipts check box is selected in the CMG Parameters (tfcmg0100s000) session.
- Invoice/Schedule Balance
- Sundry Costs
-
The sundry cost amount in the home currency.
-
The currency used for the bank transactions.
- Withholding Tax Amount
-
- 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.