FinansalHatırlatıcı-SQL
SELECT CONVERT(VARCHAR(50),INV.DATE_,104), SUM(INV.GROSSTOTAL), CL.CODE, INV.FICHENO FROM LG_003_CLCARD CL JOIN LG_003_03_INVOICE INV ON INV.CLIENTREF=CL.LOGICALREF AND INV.CANCELLED=0 AND INV.CLIENTREF>0 WHERE INV.DATE_>=DATEADD(DAY,-7,Convert(DATE,GETDATE(),104)) AND INV.DATE_=DATEADD(DAY,-7,Convert(DATE,GETDATE(),104)) AND TAKSIT.DUEDATE<GETDATE() GROUP BY KREDI.CODE,BANKA.CODE,TAKSIT.DUEDATE --Cari hesap fişleri select * FROM LG_003_CLCARD CL JOIN LG_003_03_CLFLINE CLF ON CLF.CLIENTREF=CL.LOGICALREF
.JPG)
