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.

For a list of the integration document types, refer to Integration document types. For each Integration document type, the mapping is given as defined in the demo companies that are delivered with the LN application.

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.

 

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 Description for Dimension Type 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
Reconciliation Value (Element)

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.

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.

Reference Link
Integration Document Type
Logical Company of Integration Transaction

The financial company in which the batch was created.

Document

Internal number required to generate a unique document number for the current line.

Status

The status of the transaction line.

Status

The status of the batch.

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.

Unique Identifier

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.

 

Sort by Transaction Date

Displays or hides the Transaction Date (Local) field as a selection criterion for the reconciliation transactions in the header.

If this check box is selected, the transactions of one transaction date are listed. You can then click Next Group and Previous Group to display the transactions of later and earlier dates.

Reconciliation Rounding Correction

Starts the Operations Management - Financial Reconciliation (tfgld4595m000) details session which you can use to create correction transactions.

Calculate Accepted / Not Accepted Totals

Calculates the total amounts in the Totals box for the displayed reconciliation group.

If you display another reconciliation group, to see the total amounts, you must click Calculate Accepted / Not Accepted Totals again.

Show Only Not Accepted Postings

Displays only the transactions for which you have not accepted the reconciliation data.

Sort by Position

Displays or hides the Sort Position field as a selection criterion for the reconciliation transactions in the header.

You can use this command if in the View menu, you have selected to sort the transactions by business object.

Transaction Origin

Displays the data in Operations Management of the selected transaction.

Integration Transactions

Starts the Integration Transactions (tfgld4582m000) session which displays the corresponding integration transaction of the selected transaction.

Contra-entry

Starts the Operations Management - Financial Reconciliation (tfgld4595m000) again to display the corresponding debit or credit reconciliation transaction of the selected transaction.

Reconciliation Correction

Starts the Operations Management - Financial Reconciliation (tfgld4595m000) details session which you can use to create correction transactions.

Maintain Reconciliation Opening Balance

Starts the Opening Balances for Reconciliation (tfgld4195m000) session, which you can use to change the amount or other details of the selected opening balance transaction.

For details, refer to Reconciliation corrections.

Create Reconciliation Opening Balance

Starts the Opening Balances for Reconciliation (tfgld4195m000) session, which you can use to create an opening balance for the selected transaction.

For details, refer to Reconciliation corrections.

Print Reconciliation Data

Starts the Print Reconciliation Data (tfgld4495m000) session, which you can use to print various types of reports of the reconciliation data.

Add Reconciliation Element to view

Adds the next reconciliation element, if present, as a selection criterion for the reconciliation transactions to the header.

You can use this command if in the View menu, you have selected to sort the transactions by reconciliation element.

Remove Reconciliation Element from view

Removes the reconciliation element with the highest number from the sorting criteria for the reconciliation transactions.

You can use this command if in the View menu, you have selected to sort the transactions by reconciliation element.

Enable / Disable Sort by Document Line Number

Displays or hides the Line field as a selection criterion for the reconciliation transactions in the header.

You can use this command if in the View menu, you have selected to sort the transactions by financial document.