Tech Trainings

Query to extract Journal Line Details – Fusion ERP

April 30, 2023 by admin

--GL Query 
SELECT
   gjb.NAME  batch_name, 
   gjh.JE_BATCH_ID,
    gl.name     ledger_name,
    gjh.je_source,
    gjh.je_category,
    gjh.name,
    gjh.description,
    gjh.status,
    gjh.date_created,
    gjh.period_name,
    gll.je_line_num,
    gll.entered_dr,
    gll.entered_cr,
    gll.accounted_dr,
    gll.accounted_cr
FROM
    GL_JE_BATCHES            gjb,
    gl_je_headers             gjh,
    gl_je_lines               gll,
    gl_ledgers                gl
WHERE
        1 = 1
	AND gjb.JE_BATCH_ID  = gjh.JE_BATCH_ID
    AND gll.je_header_id = gjh.je_header_id
    AND gjh.ledger_id = gl.ledger_id

Comments |0|