REPORTFORM;GL2_E.frf
TITLE;DAILY JOURNAL REPORT BY DOCUMENT
SQL;select gltr.DATEDOC, gltr.GLID, glmst.GLDESC,glmst.GLEDESC,
SQL;gltr.JN, jn.JNDESC, gltr.DOCNO, 
SQL;gltr.DEBIT, gltr.CREDIT,gltrhd.XREMARK, gltr.LINE,gltrhd.xref
SQL;from gltr left join gltrhd on gltr.DOCNO = gltrhd.DOCNO
SQL;left join glmst on gltr.GLID = glmst.GLID
SQL;left join jn on gltr.JN = jn.JN
SQL;order by gltr.DOCNO, gltr.LINE
CONDITION;FROM DOCUMENT~GLTR.DOCNO~Chr~2~SELECT DOCNO FROM GLTR ~GLDOC
CONDITION;FROM DATE~GLTR.DATEDOC~Date~2~~
