Reconciliation - multicompany aspects

The reconciliation data is stored in the financial company in which the integration transaction is posted. As a result, for intercompany and intergroup transactions, the debit and credit data is logged in various financial companies. If the financial companies do not share the Reconciliation Data (tfgld495) table, you cannot view the debit transaction and the credit transaction together.

For best results, companies must not share the Reconciliation (tfgld495) table. In a multicompany environment, the most likely requirement is that reconciliation occurs on the level of a legal entity or enterprise unit. Because a financial company usually corresponds to a legal entity, this requires a non-shared setup. A non-shared setup also reduces the table size, as in that case the reconciliation data is divided across multiple physical tables.

Example

For a purchase order, the following situation occurs:

  • The purchase office is linked to financial company 100.
  • The warehouse of the receipt is linked to financial company 200.

The related postings appear in different reconciliation groups and in different financial companies.

Posting Ledger account Reconciliation group Amount Financial company
Debit Inventory Inventory 1 1580 200
Credit Interim Transit Interim Transit 1 1580 200
Posting Ledger account Reconciliation group Amount Financial company
Debit Interim Transit Interim Transit 1 1580 200
Credit Invoice Accrual Invoice Accrual 3 1580 100
Posting Ledger account Reconciliation group Amount Financial company
Debit Invoice Accrual Invoice Accrual 3 1580 100
Credit Registered Invoices None 1580 100

Within the reconciliation groups, the related transactions stay together. However, the reconciliation data in the Interim Transit 1 and the Inventory 1 reconciliation groups is stored in financial company 200, while the reconciliation data in the Invoice Accrual 3 reconciliation group is stored in financial company 100. In the Invoice Accrual 3 reconciliation group, the entries balance.