Joining GL with subledger, description repeating
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,
0