Has anyone built a report that shows the intercompany transactions for easy reconciliation? The purpose is to trace any discrepancies. We use AICJEs, intercompany vendor bills/intercompany customer invoices and vendor prepayments/customer deposits. For example, columns are: Main Subsidiary Document No. GL Account Transaction Amount Counterparty Subsidiary Document No. GL Account. Transaction Amount

I believe this To Subisidary field is the Due To/From subsidiary column

I'm like 95% sure that To Subsidiary doesn't correspond with the Due/To From Subsidiary field on Advanced Interco JEs. I'm fairly sure that field is the header field that you can use in some instances to do some interco magic using a regular JE. Much to my consternation when also looking for that in the past, the Due/To From Sub doesn't appear to be exposed anywhere. Not in search, not in reporting, not in Analytics WBs. I'm not even sure it's exposed in ODBC, though I haven't looked for a while. I'd love to be wrong if someone knows of it being available somewhere.

Yeah it’s probably from the Intercompany Transfer order like the To Location field is the transfer to location

Yeah that's a good point. Interco Customers/Vendors can't have multiple subs, so it would have to be that one for the line. Not clear from the requirement if 100% of the lines have an interco vendor or customer or not though and you'd be out of luck if it didn't.

We used to not populate the interco vendor and customer. So some are blank. But we have a script that automatically copies the due to and due to from field into another field, so we can use it in a saved search. I'm looking for something that covers all intercompany transactions in an accounting-friendly format hopefully.