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.