Reconciliation Groups (tcfin0120m000)

Use this session to view reconciliation groups and their details.

The reconciliation groups are predefined. You can only change some of the reconciliation group details.

 

Reconciliation Group
Represents a group of integration ledger accounts on which you can perform reconciliation. A reconciliation group consists of the combination of a reconciliation area and a subarea, for example, Invoice Accrual/ Purchase Order WIP.
Reconciliation Group
A further division of a reconciliation area into the kinds of origins of the transactions. For example, the Interim Costs and Invoice Accrual reconciliation areas are divided into many subareas such as Sales Order, Purchase Order, and Service Order. The reconciliation area and subarea together form a reconciliation group which represents a group of integration ledger accounts.
Reconciliation Group
An additional description of the reconciliation group. For example, this field can be used for a more detailed description or a description in a different language.
Reconciliation
Write Reconciliation Data
If this check box is selected, LN logs reconciliation data for the transactions of the integration document types that belong to the reconciliation group.

By default, this check box is selected. For performance reasons, you can choose to clear the check box if you do not use the reconciliation group for reporting. For example, logging reconciliation data for the reconciliation groups of interim accounts such as Invoice Accrual, WIP, and Inventory is usually far more important than logging the data for profit and loss end accounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Logging of reconciliation elements.

Note

You cannot change the selection of this check box if unposted transactions exist in the reconciliation data of the reconciliation group in any financial company of the multicompany structure.

Log All Reconciliation Elements
If this check box is selected, LN logs the values of all the possible reconciliation elements that are available for the reconciliation group and that are present in the integration transaction. As a result, if you assign different reconciliation elements for the reconciliation group at a later date, the transactions already logged can still be reconciled.

By default, the check box is selected. If you have established that the setup of the reconciliation group is correct and meets your reconciliation requirements, you can clear the check box to improve performance.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Logging of reconciliation elements.

Non-monetary Account
If this check box is selected, this is a non-monetary account, for which reporting currency amounts of the integration transactions are based on the historical rates that applied to the related business objects.

If this check box is cleared, this is a monetary account, for which reporting currency amounts are determined using rates that are based on company and ledger account settings.

Note

This check box is applicable only if the Use Multiple Functional Currencies check box in the Companies (tcemm1170m000) session is enabled.

Automatically Accept Reconciliation Data
If this check box is selected, the logged data immediately has the Accepted status.

For reconciliation groups for which you only want to have the logged data available for analysis purposes, you can select this check box.

Note

If you select this check box and reconciliation data already exists for the reconciliation group or subgroup, you will be prompted to update this data in the Accept Reconciliation Data (tfgld4295m000) session.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Logging of reconciliation elements.

Automatically Finally Accept Reconciliation Data
If this check box is selected, the logged data immediately has the Final Accepted status.

For reconciliation groups for which you only want to have the logged data available for analysis purposes, you can select this check box.

Note

If you select this check box and reconciliation data already exists for the reconciliation group or subgroup, you will be prompted to update this data in the Finally Accept Reconciliation Data (tfgld4295m100) session.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Logging of reconciliation elements.

Allow Corrections on Accepted Reconciliation Data
If this check box is selected, you can enter a (rounding) correction on an accepted reconciliation transaction in the Operations Management - Financial Reconciliation (tfgld4595m000) session.
Allow Corrections on Finally Accepted Reconciliation Data
If this check box is selected, you can enter a (rounding) correction on a finally accepted reconciliation transaction in the Operations Management - Financial Reconciliation (tfgld4595m000) session.
Basis for Final Acceptance
Indicates the most specific level of detail on which you can reconcile and accept the transactions.

For example, if the Basis for Final Acceptance is business object ID which for a purchase order represents the order number, then you cannot reconcile and accept the reconciliation transactions per purchase order line.

Note

If the value is other than Not Applicable, the business object must be Closed before you can accept the reconciliation data in the Finally Accept Reconciliation Data (tfgld4295m100) session.

This field can have the following values:

  • Business Object ID
    You can reconcile and accept the transactions per business object ID or on a less specific level.
  • Business Object ID + Sorting Position
    You can reconcile and accept the transactions per business object ID plus sorting position, for example, the order line number, or on a less specific level.
  • Business Object ID + Reference
    You can reconcile and accept the transactions per business object ID plus business object reference or on a less specific level.
  • Reference Link between Business Objects
    You can reconcile and accept the transactions from different reconciliation groups by reference link.
  • Not Applicable
    You cannot reconcile and accept the transactions per business object ID or reference link. You can reconcile and accept the transactions per reconciliation element or on a less specific level.

    This value applies to reconciliation groups of these reconciliation areas:

    • Inventory
    • Consignment Inventory
    • Assembly Line WIP
Log Currency Differences
Indicates whether currency differences are logged for the integration document type.

This field can have the following values:

  • Automatically
    You must define a mapping for the Currency Difference integration document type.
  • Manually
    The Currency Difference integration document type is only used to log the reconciliation data. No currency difference transaction is generated. Before reconciliation, you can run the various currency differences sessions to clear the currency differences from the integration accounts. For details, refer to Currency differences accounts.
  • Not
    Currency differences are not logged. No Currency Difference integration document type is generated.

For details, refer to Log Currency Differences.

Integration Document Type
Currency Difference
The integration document type used to log the currency differences transactions generated for the reconciliation area.

No mapping can be defined for the integration document type. It is only used for the reconciliation process.

Rounding Difference
The integration document type used to log the rounding differences transactions for the reconciliation area.

No mapping can be defined for the integration document type. It is only used for the reconciliation process.

Correction
The integration document type used to log the Reconciliation Correction transactions that you can create in the Operations Management - Financial Reconciliation (tfgld4595m000) session for the reconciliation area.

No mapping can be defined for the integration document type. It is only used for the reconciliation process.

Opening Balance
The integration document type used to log the opening balance transactions.

No mapping can be defined for the integration document type. It is only used for the reconciliation process.

Reconciliation Element
Reconciliation Elements 1, 2, 3, 4, 5
A reconciliation element for the reconciliation group.

You can select a reconciliation element from the Possible Reconciliation Elements by Reconciliation Group (tcfin0125m000). The most specific element has number 5 and the least specific element has the lowest number.

Block deleting of
Business Objects of not finally accepted transactions
If this check box is selected, you cannot archive and/or delete business objects in Operations Management before the reconciliation data of the reconciliation group has been finally accepted in the Finally Accept Reconciliation Data (tfgld4295m100) session.

By default this check box is selected. If you only use the reconciliation data for reporting, you can clear this check box.

Alternatively, you can consider to select the Automatically Finally Accept Reconciliation Data check box for the reconciliation group.

Finally accepted transactions of not deleted Business Objects
If this check box is selected, you cannot archive and/or delete the reconciliation data if the business objects still exist in Operations Management, that means, if the business object has not been archived and/or deleted.

By default this check box is selected. If necessary, for example, for projects that run longer than a fiscal year, you can clear this check box.

 

Integration Document Types by Reconciliation Group
Starts the Integration Document Types by Reconciliation Group (tcfin0115m000) session which lists the integration document types linked to the reconciliation group.
Possible Reconciliation Elements by Reconciliation Group
Starts the Possible Reconciliation Elements by Reconciliation Group (tcfin0125m000) session which lists the reconciliation elements available for the reconciliation group.

To asssign reconciliation elements to the reconciliation group, you must zoom to this session in the Reconciliation Element fields of the Reconciliation Groups (tcfin0120m000) details session.

Integration Document Types
Starts the Integration Document Types (tfgld4557m000) session. You can view the integration document type details and you can change the Description and/or the Sort Element of the integration document type.
Change Reconciliation Elements
Starts the Change Reconciliation Elements (tcfin0220m000) session, in which you can select new reconciliation elements for the reconciliation group.