Reconciliation of Receivables/Payables for Affiliated Companies

[Former Member]

I am trying to reconcile the receivable and payables of two affliated companies using transacion F.2E. On the face of it the report is showing a difference of a particular amount. However, if we go into details of it, the details do not show any difference. The documents are posted in both company codes but probably they are somehow not linked somewhere and that link is checked by this report, it shows as if the two are out of sink. The report FK10 also matches with the totals of the details.

If anybody has faced a similar problem or knows what link this report looks for , please let me know.

thanks and regards,

Prerna Tatia

[Former Member]

The link is the reference field in both documents (BKPF-XBLNR). Make sure you also go under the Further Selections tab and under technical settings flag Conversion for reference numb. This will remove any leading zeros from billing documents. Hope this helps.