Merhabalar ,
Firmanın Tahsilatlarını getirmek için yardıma ihtiyacım var.
Bu koda Cari Hesap Fişlerinide Eklemem Lazım
Cari Hesap Fişlerinin 70 kodu Kredi Kartları Where kısmı 70 kodu olmalı
Ayrıca Buraya Cari Hesapların Satış Faturalarınıda Getirmemiz Tarih Bazlı Mümkün mü ?
İyi Çalışmalar.
SELECT 'KASA' [MODUL], KS.DATE_[TARIH], MONTH(KS.DATE_) [AY], K.CODE[KODU], K.NAME[ADI], C.CODE[CHKODU], C.DEFINITION_[CHADI], C.SPECODE, KS.TRNET[TUTAR]
FROM LG_103_KSCARD K, LG_103_01_KSLINES KS, LG_103_01_CLFLINE CL, LG_103_CLCARD C
WHERE C.CODE <> '331.02.01' AND K.LOGICALREF = KS.CARDREF AND KS.TRANSREF = CL.LOGICALREF AND CL.CLIENTREF = C.LOGICALREF AND KS.TRCODE = 11
UNION ALL
SELECT 'BANKA' [MODUL], BL.DATE_[TARIH], MONTH(BL.DATE_) [AY], BN.CODE[KODU], BN.DEFINITION_[ADI], C.CODE[CHKODU], C.DEFINITION_[CHADI], C.SPECODE, BL.TRNET[TUTAR]
FROM LG_103_01_BNFLINE BL, LG_103_BANKACC BN, LG_103_CLCARD C
WHERE C.CODE <> '331.02.01' AND BL.BNACCREF = BN.LOGICALREF AND BL.CLIENTREF = C.LOGICALREF AND MODULENR = 7 AND TRCODE = 3
UNION ALL
SELECT 'VİRMAN' AS 'MODUL', A.DATE_[TARIH], MONTH(A.DATE_) [AY], B.CODE[BANKAKODU], B.DEFINITION_[BANKAADI], A.CODE[CHKODU], A.DEFINITION_[CHADI], A.SPECODE, A.TRNET
FROM (SELECT CL.DATE_, C.SPECODE, C.CODE, C.DEFINITION_, CL.TRNET, CL.SOURCEFREF
FROM LG_103_01_CLFLINE CL, LG_103_CLCARD C
WHERE CL.CLIENTREF = C.LOGICALREF AND CL.TRCODE = 5 AND CL.TRCODE = 5 AND SIGN = 1) A,
(SELECT CL.DATE_, C.SPECODE, C.CODE, C.DEFINITION_, CL.TRNET, CL.SOURCEFREF
FROM LG_103_01_CLFLINE CL, LG_103_CLCARD C
WHERE CL.CLIENTREF = C.LOGICALREF AND CL.MODULENR = 5 AND CL.TRCODE =5 AND SIGN = 0) B
WHERE A.SOURCEFREF = B.SOURCEFREF
UNION ALL
SELECT 'CEK_SENET' AS MODUL, CL.DATE_[TARIH], MONTH(CL.DATE_) [AY], 'BOS' AS KODU, 'BOS' ADI, C.CODE[CHKODU], C.DEFINITION_[CHADI], C.SPECODE, CL.TRNET[TUTAR]
FROM LG_103_01_CSROLL CL, LG_103_CLCARD C
WHERE CL.CARDREF = C.LOGICALREF AND CL.TRCODE IN (1, 2) AND C.CODE <> '331.02.01'