REPORTFORM;STCNOMOVE.frf
TITLE;รายงานสินค้าที่ไม่เคลื่อนไหว
SQL;SELECT 
SQL;ID,XDESC,NBAL, INVMST.UNIT,
SQL;LASTUPDATE AS LASTDATE,
SQL;(((YEAR(NOW()) - 1900) * 365) + DAYOFYEAR(NOW()))  - (((YEAR(lastupdate) - 1900) * 365) + DAYOFYEAR(lastupdate))  AS XAGE,
SQL;COSTBAL
SQL;FROM INVMST
SQL;WHERE (NBAL <> 0)
SQL;AND NOT (INVMST.XGROUP = "03" OR INVMST.XGROUP = "04")
SQL;ORDER BY ID
CONDITION;ตั้งแต่รหัสสินค้า~ID~Chr~2~SELECT ID FROM INVMST~INV
CONDITION;เงื่อนไข~~TextFile~~NOMOVE.TXT~
XQL;SELECT SUM(REPBAL) AS MQ, SUM(COSTREPBAL) AS MC FROM INVCARD
XQL;WHERE INVCARD.ID = :ID
USECROSSTAB;N
CROSSTABFRF;N
CROSSTABHEAD;
CROSSTABFIELD;
