I have an SQL query that shows me the GL distribution for all invoices. But the problem I have is that for invoices that were posted using the Intercompany functionality, it just shows me that the item was posted to the Intercompany Account, not the GL distribution from the other side of the transaction.
Does anyone know how to get it to return the G/L where the item is posted to in the other company, and not the Intercompany account in the ledger where it is posted?
Any help would be greatly appreciated.
Thanks