Ön tarafta olan fişlerin çoğu paytrans ( borç takipte ) yok !!
Sorgu yazılıp hangi fişlerin olmadığı tespit edilecek . Kayıt çok fazlaysa yeniden ne yapılacağı ile ilgili görüşülecek . --Fatura SELECT * FROM LG_017_01_INVOICE WHERE LOGICALREF NOT IN ( SELECT FICHEREF FROM LG_017_01_PAYTRANS WHERE MODULENR=4) AND EXIMFCTYPE=0 AND CLIENTREF>0 AND DEVIR=0 AND CANCELLED=0 AND NETTOTAL>0 AND FROMEXCHDIFF=0 --Cari hesap fisleri select * FROM LG_017_01_CLFLINE WHERE MODULENR=5 --AND CLIENTREF=2 AND LOGICALREF NOT IN (SELECT FICHEREF FROM LG_017_01_PAYTRANS WHERE MODULENR=5) AND TRCODE6 --Banka fisleri SELECT * FROM LG_017_01_BNFLINE WHERE MODULENR=7 AND TRCODE IN(3,4) AND LOGICALREF NOT IN ( SELECT FICHEREF FROM LG_017_01_PAYTRANS WHERE MODULENR=7 ) -- Çek Senet SELECT * FROM LG_017_01_CSTRANS WHERE ROLLREF NOT IN ( SELECT FICHEREF FROM LG_017_01_PAYTRANS WHERE MODULENR=6) AND ROLLREF>0 AND CARDREF>0 AND TRCODE NOT IN (5,6,11)
.JPG)
