How to link PL and RL rows when parent_je_header_id is not populated
Summary:
How to link PL and RL rows when parent_je_header_id is not populated
Content (required):
I need to write a query that will bring primary ledger details along with its reporting ledger details. Reporting ledger row in gl_je_headers table will have parent_je_header_id column populated with its primary ledger row's header id.
My issue is the parent_je_header_id of my reporting ledger row is null. On investigation we understand the user who posts the journal would not have access to RL, hence the parent_je_header_id is not populated and is null.
0