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
PostingLedger accountReconciliation groupAmountFinancial company
DebitInventoryInventory 11580200
CreditInterim TransitInterim Transit 11580200

 

Integration document type: Purchase Order/Receipt
PostingLedger accountReconciliation groupAmountFinancial company
DebitInterim TransitInterim Transit 11580200
CreditInvoice AccrualInvoice Accrual 31580100

 

Integration document type: Approval Purchase Invoice
PostingLedger accountReconciliation groupAmountFinancial company
DebitInvoice AccrualInvoice Accrual 31580100
CreditRegistered InvoicesNone1580100

 

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.