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

Joining GL with subledger, description repeating

edited Jun 4, 2025 7:11AM in General Ledger & Intercompany

I have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not displaying the proper line description for the journal. The line description is not repeated throughout the entire output, only in projects:

SELECT
gjb.created_by,
gjb.last_updated_by,
gjb.creation_date,
gjb.name Journal_Batch,
gjb.description Journal_Batch_Description,
gjb.status Posting_Status,
gjh.period_name,
gjh.je_category,
gjt.description Journal_Cat_Desc,
gjs.user_je_source_name,
gjs.description Journal_Source_Desc,
gcc.concatenated_segments,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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