REPORTFORM;STCNOMOVE_E.frf
TITLE;STOCK CARD NO MOVEMENT
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;ORDER BY ID
CONDITION;FROM STOCK ID~ID~Chr~2~SELECT ID FROM INVMST~INV
CONDITION;CONDITION~~TextFile~~NOMOVE.TXT~
XQL;SELECT SUM(REPBAL) AS MQ, SUM(COSTREPBAL) AS MC FROM INVCARD
XQL;WHERE INVCARD.ID = :ID
