Operations Management - Financial Reconciliation (tfgld4595m000)

Use this session to view and analyze the reconciliation data.

To display the business objects of a reconciliation group, click the Group buttons. To display the business objects of a different a reconciliation group, click the Find a record button to select the reconciliation group.

If you start the session or you display a new reconciliation group, the amounts in the Totals box are set to zero. To see the amounts, on the appropriate menu, click Calculate Accepted / Not Accepted Totals..

To view the transactions

To display the financial and logistic details of one transaction, double-click the transaction.

To group the reconciliation transactions in various ways, on the View menu you can click Sort By..., and then click one of these sort orders:

Note: If you have started this session by zooming, the sort order depends on the Basis for Final Acceptance of the reconciliation group.

To view the integration transaction

You can select a transaction and on the appropriate menu, click Integration Transactions to display the related integration transactions Integration Transactions (tfgld4582m000) session.

To display the total amounts

On the appropriate menu, you can click Calculate Accepted / Not Accepted Totals. to display the total debit amount, the total credit amount, and the balances for the reconciliation area.

The total amounts are displayed in the same home currency as the transaction amounts in the Amount In column on the utmost right of the session. To see the Amount In column, scroll the session to the right.

From the Tools menu, choose Rotate Currency to switch home currencies.

To view the original Operations Management transaction

You can select a line and on the appropriate menu, click Transaction Origin to start the Operations Management session in which the business object of the integration transaction was created. For example, if the business object is a purchase order, the Purchase Order Line Details (tdpur4101m200) session starts. You can use this session to examine the original transaction.

To create correction transactions

You can select a line and on the appropriate menu, click Reconciliation Correction or Reconciliation Rounding Correction. You can then create a correction transaction in the Operations Management - Financial Reconciliation (tfgld4595m000) details session.

You can post the corrections in the Accept Reconciliation Data (tfgld4295m000) session.

Note: 
  • You can only enter (rounding) corrections if in the Reconciliation Groups (tcfin0120m000) session either of the following check boxes is selected:

    • Allow Corrections on Accepted Reconciliation Data
    • Allow Corrections on Finally Accepted Reconciliation Data
  • You can only create correction transactions for reconciliation transactions that have the Ready status.

Field Information

Transaction date (UTC)

The date and time when the transaction was created in Operations Management, expressed as UTC time.

Logistic Company

The logistic company in which the Operations Management transaction was created.

Transaction Date (Local)

The transaction date and time expressed in local time.

Allowed values

In Financials , the local time is always used for posting and reporting.

Document Date

The transaction date of the financial transaction. The document date is always registered in local time.

Usually, the document date is the same date as the transaction date, except if you manually enter a different date in Financials .

Creation Date

The date and time when the integration transaction was logged.

For postdated and antedated transactions, the creation date differs from the transaction date.

Posting Date

The date on which the transaction was posted to the general ledger.

Quantity

The quantity handled by the transaction.

Unit

The unit in which the quantity is expressed.

Transaction Amount

The transaction amount in the transaction currency.

Transaction Currency

The transaction currency.

Debit/Credit

The type of amount.

Document

The transaction type used to generate the document number.

Document

The generated document number.

Line

The line number.

Ledger Account

The ledger account to which the amount was posted.

Dimension 1

The dimensions to which the amount was posted.

Amount In

The transaction amount in a home currency.

From the Tools menu, choose Rotate Currency to switch home currencies.

Business Object ID

The business object ID. For example, this can be the order number.

Business Object Reference

The business object reference if one is present.

Sort Position

The business object's sort position.

Business Object

The business object.

Reconciliation Value (Element 1)

The value of the reconciliation element.

Kind of Entry

The kind of entry.

In this session, the kind of entry is usually Integration Transaction but it can also be, for example, a Correction (Not Final) or an Opening Balance.

If the kind of entry is Integration Transaction Reversal, the original integration transaction was remapped. You can check whether the balance of the Integration Transaction (Reversed) and the Integration Transaction Reversal transactions is zero.

Automatic Opening Balance

Indicates whether the opening balances are created by the Close Reconciliation Data (tfgld4295m900) session.

Note: This field is read-only.
Integration Document Type

The integration document type.

Fiscal period

The fiscal year in which the transaction is posted.

Fiscal Period

The fiscal period in which the transaction is posted.

Reconciliation Group

The reconciliation group to which the transaction belongs.

Reconciliation Subarea

The reconciliation subarea to which the transaction belongs.

Batch Year

The fiscal year of the batch.

Batch

The batch number.

Accepted

To indicate that you checked and approved this entry, you can select this check box. If you accept transactions with the Accept Reconciliation Data (tfgld4295m000) session, LN selects the check box.

You can clear the check box if you wish. If this check box is selected, you cannot create or post corrections for this line.

Finally Accepted

To release this entry for archiving and deletion, you can select this check box. If you finally accept transactions with the Finally Accept Reconciliation Data (tfgld4295m100) session, LN selects the check box.

Integration Document Type

The integration document type.

Logical Company of Integration Transaction

The financial company in which the batch was created.

Status

The status of the transaction line.

Unposted

The transaction has not yet been posted to the general ledger.

Error

LN could not post the transaction due to an error. Use the Print Integration Transactions Error Log (tfgld4484m000) to list the errors.

Posted

The transaction was successfully posted in the general ledger.

Batch Status

The status of the batch.

Free

The batch has been created but does not contain transactions or the transactions are not balances. The batch cannot be finalized.

In Use

A user is entering or modifying transactions in the batch. The batch cannot be finalized.

Background in Process

Changes in the transactions are being processed. The batch cannot be finalized.

Ready

The batch is error free and ready for finalization.

Finalization in Process

The batch has been selected for finalization and finalization is in progress.

Finalized

The batch has been finalized.

Deleted

The batch and the transactions have been deleted.

Errors in Finalization

Errors occurred during finalization of the batch. The batch cannot be finalized.

Balance Reference

If this check box is selected, the reconciliation data is finally accepted based on the balance reference and the transactions are sorted by balance reference on the error report and process report.

Used Currency Rate

The currency rate used to calculate the transaction amount in the home currency.

Differences between the Used Currency Rate and the Actual Currency Rate can result in exchange gain and loss.

Actual Currency Rate

The currency rate that determines the actual value of the transaction. For example, this is the agreed rate for a purchase contract.

Differences between the Used Currency Rate and the Actual Currency Rate can result in exchange gain and loss.

Finance Company

The financial company in which the transaction is posted.

GUID

A generated unique key for the transaction.

Debit Amount

The accepted debit amount.

Credit Amount

The accepted credit amount.

Balance

The difference between the accepted Debit Amount and Credit Amount.

Debit Amount

The not accepted debit amount.

Credit Amount

The not accepted credit amount.

Balance

The difference between the not accepted Debit Amount and Credit Amount.

Debit Amount

The total debit amount of all the lines.

Credit Amount

The total credit amount of all the lines.

Balance

The difference between the total Debit Amount and Credit Amount.