REPORTFORM;GL3_E.frf
TITLE;DAILY JOURNAL BY DATE
SQL;select gltr.DATEDOC, gltr.GLID, glmst.GLDESC,glmst.GLEDESC,
SQL;gltr.JN, jn.JNDESC, gltr.DEBIT, gltr.CREDIT, gltrhd.xref,gltrhd.docno,gltrhd.xremark
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.DATEDOC, gltr.GLID
CONDITION;FROM DATE~GLTR.DATEDOC~Date~2~~
