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.
HAVING ABS(SUM(B.DEBIT)-SUM(B.CREDIT)
Özgür GÜLER – White Eagles - BLOG
Teknoloji Dostunuz
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.
HAVING ABS(SUM(B.DEBIT)-SUM(B.CREDIT)