REPORTFORM;POSVAT.frf
TITLE;รายงานภาษีขาย 
SQL;select arcard.DATEDOC, arcard.DOCNO, arcard.AMOUNT_B, arcard.amount_b-arcard.vatamt-arcard.novatamt as invamt, arcard.VATAMT, 
SQL;(arcard.AMOUNT_B - arcard.INVAMT) - arcard.VATAMT as AMOUNT_BAL, arcard.XREMARK,
SQL;arcard.xnote,arcard.jobno,arcard.novatamt
SQL;from arcard
SQL;where left(docno,2) = "IV"
SQL;and frompos = 1
SQL;order by arcard.DATEDOC, arcard.DOCNO
CONDITION;ตั้งแต่วันที่เอกสาร~ARCARD.DATEDOC~Date~2~~
EXCELSQL;select arcard.DATEDOC, arcard.DOCNO, arcard.AMOUNT_B, arcard.amount_b-arcard.vatamt-arcard.novatamt as invamt, arcard.VATAMT, 
EXCELSQL;(arcard.AMOUNT_B - arcard.INVAMT) - arcard.VATAMT as AMOUNT_BAL,arcard.novatamt,
EXCELSQL;arcard.XREMARK,
EXCELSQL;arcard.xnote,arcard.jobno
EXCELSQL;from arcard
EXCELSQL;where left(docno,2) = "IV"
EXCELSQL;and frompos = 1
EXCELSQL;order by arcard.DATEDOC, arcard.DOCNO
USECROSSTAB;N
CROSSTABFRF;N
CROSSTABHEAD;
CROSSTABFIELD;
