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.

Integration document type: Warehouse Receipt/Receipt
Posting	Ledger account	Reconciliation group	Amount	Financial company
Debit	Inventory	Inventory 1	1580	200
Credit	Interim Transit	Interim Transit 1	1580	200

Integration document type: Purchase Order/Receipt
Posting	Ledger account	Reconciliation group	Amount	Financial company
Debit	Interim Transit	Interim Transit 1	1580	200
Credit	Invoice Accrual	Invoice Accrual 3	1580	100

Integration document type: Approval Purchase Invoice
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.