SATIR TOPLAMLARI TUTARSIZ OLAN MUHASEBE FISLERI

 

SATIR TOPLAMLARI TUTARSIZ OLAN MUHASEBE FISLERI

SELECT A.FICHENO,A.DATE_ FROM LG_001_01_EMFICHE A, LG_001_01_EMFLINE B
WHERE A.LOGICALREF=B.ACCFICHEREF
AND A.TRCODE=4
GROUP BY A.FICHENO,A.DATE_,A.TOTALACTIVE,A.TOTALPASSIVE
HAVING ABS(SUM(B.DEBIT)-SUM(B.CREDIT))>1