REPORTFORM;APX_1.frf
TITLE;รายละเอียดการตั้งหนี้เจ้าหนี้
SQL;SELECT DOCNO, APCARD.TAXNO, DATEDOC, APCARD.ACCID, APMST.XCOMP,
SQL;INVAMT,VATAMT,AMOUNT_D,RECAMT,APCARD.NBAL,APCARD.DPTID
SQL;FROM APCARD LEFT JOIN APMST ON APCARD.ACCID = APMST.ACCID
SQL;WHERE LEFT(TRTYPE,2) = 'AP'
SQL;ORDER BY DOCNO
CONDITION;ตั้งแต่วันที่ ~APCARD.DATEDOC~Date~2~~
CONDITION;ตั้งแต่เลขที่~APCARD.DOCNO~Chr~2~SELECT DOCNO FROM APCARD WHERE LEFT(TRTYPE,2)='AP'~
EXCELSQL;SELECT DOCNO, APCARD.TAXNO, DATEDOC, APCARD.ACCID, APMST.XCOMP,
EXCELSQL;INVAMT,VATAMT,AMOUNT_D,RECAMT,APCARD.NBAL,APCARD.DPTID
EXCELSQL;FROM APCARD LEFT JOIN APMST ON APCARD.ACCID = APMST.ACCID
EXCELSQL;ORDER BY DOCNO
