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 Acccepted 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 Show Integration Transaction 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 Acccepted 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 Zoom to 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.
Quantity
The unit in which the quantity is expressed.
Transaction Amount
The transaction amount in the transaction currency.
Transaction Amount
The transaction currency.
Amount In
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.
Dimensions
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
The business object ID. For example, this can be the order number.
Business Object
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 Group
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
Batch Company
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.

 

Enable / Disable 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.
Enable / Disable 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.

Zoom to Transaction Origin
Displays the data in Operations Management of the selected transaction.
Show Integration Transaction
Starts the Integration Transactions (tfgld4582m000) session which displays the corresponding integration transaction of the selected transaction.
Show 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.