Sub ledger SQL
Summary
I need to link sub ledger tables to each journal sourceContent
I am creating a report that shows GL transactions and need to link into each specific journal source. Via XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER i have been able to link to both payables and receivables sources but i am struggling to link to payroll, cash management and receipt accounting sources (from sub ledger tables). Does anyone have any advise in finding the links between these tables, please?
Many thanks.
Version
20A2