REPORTFORM;GL4_E.frf
TITLE;SPECIAL JOURNAL REPORT BY DATE
SQL;select gltr.JN, jn.JNDESC, gltr.DATEDOC, 
SQL;gltr.GLID, glmst.GLDESC, glmst.GLEDESC,gltr.DEBIT, gltr.CREDIT, gltrhd.xref, gltrhd.docno,gltrhd.xremline
SQL;from gltr left join glmst on gltr.GLID = glmst.GLID
SQL;left join jn on gltr.JN = jn.JN 
SQL;left join gltrhd on gltr.docno = gltrhd.docno
SQL;order by gltr.JN,gltr.DATEDOC, gltr.GLID
CONDITION;FROM SPECIAL JN~GLTR.JN~Chr~2~SELECT JN FROM GLTR~JN
CONDITION;FROM DATE~GLTR.DATEDOC~Date~2~~
