Detailed Cash Flow Information (tfgld2561m000)

Use this session to view the Detailed Cash Flow Information. This session lists all contra transaction lines of a Cash Transaction, such as revenues lines of a sales invoice, or the cost lines of a purchase invoice. This information can be exported to Excel.

Field Information

All Companies

If this check box is selected, the Detailed Cash Flow Information for all the companies in LN is displayed.

Note: 
  • If this check box is selected, and the currency system is set to Dependent or Independent, all companies in the group are selected.
  • If this check box is selected, and the currency system is set to Standard, the Reporting Currency Group field becomes available and must be filled. All companies related to this reporting currency group are selected.
  • If this check box is cleared, the field Financial Company must be filled.
Reporting Currency Group

The code of the Reporting Currency Group.

Note: 
  • This field is available only if the Currency System is set to Standard.
  • This field is enabled only if the All Companies check box is selected.
Description

The description or name of the code.

Financial Company

The financial company for which the Detailed Cash Flow Information is displayed.

Note: This field is enabled only if the All Companies check box is not selected.
Description

The description or name of the code.

Fiscal Period

The From and To fields define a range of: fiscal years for which the Detailed Cash Flow Information is displayed.

Fiscal Period

The From and To fields define a range of: fiscal periods for which the Detailed Cash Flow Information is displayed.

Financial Company

The financial company of the cash transaction.

Cash Account

The ledger account of the cash transaction.

Description

The description or name of the code.

Transaction Type

The transaction type of the document related to the cash transaction.

Document

The document number of the cash transaction.

Line

The line number of the cash transaction.

Internal Sequence

The sequence number generated by the Generate Detailed Cash Flow Information (tfgld2261m000) session in case the paid or received amount is distributed over multiple invoice lines.

Document Date

The document date of the cash transaction.

Fiscal Year

The fiscal year in which the cash transaction is posted.

Fiscal Period

The fiscal period in which the cash transaction is posted.

Type of Cash Transaction

The type of cash transaction which is posted.

Allowed values

Supplier Payment

Cash Transactions created with type of transaction as Supplier Payment within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled payments on purchase invoices are also considered as supplier payments.

Customer Receipt

Cash Transactions created with type of transaction as Customer Receipt within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled receipts on sales invoices are also considered as customer receipts.

Unallocated Payment

Cash Transactions created with type of transaction as Unallocated Payment within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled unallocated payments are also considered as unallocated payments.

Unallocated Receipt

Cash Transactions created with type of transaction as Unallocated Receipt within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled unallocated receipts are also considered as unallocated receipts.

Advance Payment

Cash Transactions created with type of transaction as Advance Payment within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled advance payments and standing orders of the type Advance Payment are also considered as advance payments.

Advance Receipt

Cash Transactions created with type of transaction as Advance Receipt within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled advance receipts are also considered as advance receipts.

Cash Journal

Cash Transactions created with type of transaction as Cash Journal within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction. Reconciled standalone payments, and standing orders of the type Costs are also considered as Cash Journal Transactions.

GL Transaction on Cash Account

Non-Cash Transactions created on a Cash Account within a transaction type that does not have Transaction Category as Cash and Transaction Subcategory as Bank Transaction.

Payment Assignment

Cash Transactions created by assigning unallocated or advance payments to purchase invoices within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Assign Advance/Unallocated Payment

Receipt Assignment

Cash Transactions created by assigning unallocated or advance receipts to sales invoices within a transaction type that does not have Transaction Category as Cash and Transaction Subcategory as Assign Advance/Unallocated Receipt.

Intercompany Transaction

Intercompany transactions that are a result from intercompany payments/receipts and that are generated when:

  • A Supplier payment is paid from company A for an invoice from company B.
  • A Customer receipt is received in company A for an invoice from company B.
  • An Unallocated or advance payment is paid from company A on behalf of company B.
  • An Unallocated or advance receipt is received in company A which is meant for company B.
  • A Cash journal is created where the receipt or payment is done in company A and the related journal transaction is created for company B.

These transactions are created within a transaction type that has Transaction Category as Cash and Transaction Subcategory as Bank Transaction.

Not Applicable
Cash Flow Information Code

The Cash Flow Information Code linked to the Ledger Account of the Detailed Cash Flow Information line.

Description

The description or name of the code.

Transaction Amount

The amount in transaction currency.

Currency

The currency code of the Transaction Amount.

Amount in Invoice Currency

The transaction amount in the reporting currency.

  • This field is not available if the Currency System is set to Single or Independent.
  • If the Currency System is set to Standard or Dependent and the field All Companies is not selected, the field is defaulted with the amount in local currency. The user can use the ‘Rotate Currency’ option to switch between home currencies.
  • If the Currency System is Standard and the field All Companies is selected, the field is filled with the amount in the currency defined in the Reporting Currency Group entered.
  • If the Currency System is Dependent and the field All Companies is selected, the field is filled with the amount in the reference currency.
Amount in Local Currency

The cash transaction amount in local currency.

Description

The currency code of the amount in local currency.

Amount in Reporting Currency 1

The cash transaction amount in first reporting currency 1.

Note: This field is not displayed if the Currency System is set to Single.
Description

The currency code of the amount in first reporting currency 1.

Note: This field is not displayed if the Currency System is set to Single.
Amount in Reporting Currency 2

The cash transaction amount in second reporting currency 2.

Note: This field is available only if the Currency System is set to Independent.
Debit / Credit

The debit/credit indicator of the cash transaction.

Original Company

The company of the underlying document.

Original Transaction Type

Transaction type of the underlying document.

Original Document

The document number of the underlying document.

Line

The line number of the underlying document t

Sequence Number

The sequence number of the underlying document.

Background Sequence No.

The background sequence number of the underlying document.

Supplier's Invoice Number

The supplier invoice number if the original document is a purchase invoice.

Reference

The reference of the original document.

Document Date

The document date of the original document

Business Partner

The business partner of the original document.

Description

The description or name of the code.

Financial Supplier Group

The Financial Supplier Group of the business partner of the original document.

Financial Customer Group

The Financial Customer Group of the business partner of the original document.

Purchase Invoice Status

The status of the purchase invoice.

Allowed values

Registered
Transactions Entered
Matched
Approved
Note: This field is applicable only if the original document is a purchase invoice.
Ledger Account

The ledger account of the original document.

Description

The description or name of the code.

Dimensions

The dimension codes and the descriptions used in the original document line

Manual Cash Code

You can manually enter the Cash Flow Information Code if a transaction involves an exceptionally high amount.

Description

The description or name of the code.

Cash Flow Reason

The cash flow reason of the transaction.

Note: If the Cash Flow Statement in the Group Company Parameters (tfgld0101s000) session is selected, this field is defaulted with the Cash Flow Reason of the cash transaction.
Related Order

The purchase, freight or sales order related to the original document line.

Position

The purchase, freight or sales order position related to the original document line.

Logistic Company

The logistic company of the related order.

Related Item

The item of the order line related to the original document line.

Description

The description or name of the code.

Original Cash Company

The company number of the source company who paid or received the invoice in case of intercompany cash transaction.

Original Cash Transaction Type

The transaction type in the source company in case of intercompany cash transaction.

Original Cash Document

The document number in the source company in case of intercompany cash transaction.