REPORTFORM;RS5_E.frf
TITLE;RETURN FROM ISSUE BY JOB,DATE REPORT
SQL;select invcard.DOCNO, invcard.DATEDOC, invcard.ID, invmst.XDESC,
SQL;invcard.QUAN, invcard.UNIT, invcard.COST, 
SQL;invcard.COSTAMT, invcard.LOCID,
SQL;retisshd.DPTID, depart.DDESC, retisshd.REFNO,
SQL;retisshd.JOBNO, jobmst.JDESC
SQL;from invcard 
SQL;left join invmst on invcard.ID = invmst.ID
SQL;left join retisshd on invcard.DOCNO = retisshd.DOCNO
SQL;left join depart on retisshd.DPTID = depart.DID
SQL;left join jobmst on retisshd.JOBNO = jobmst.JOBNO
SQL;where left(invcard.DOCNO,2) = "RS"
SQL;order by retisshd.JOBNO, invcard.DATEDOC,invcard.DOCNO,invcard.ID,invmst.XDESC 
CONDITION;FROM JOB NO~RETISSHD.JOBNO~Chr~2~SELECT JOBNO FROM JOBMST ~JOB
CONDITION;FROM DATE~INVCARD.DATEDOC~Date~2~~
