You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to link PL and RL rows when parent_je_header_id is not populated

edited Nov 6, 2023 4:20PM in General Ledger & Intercompany 2 comments

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!