Kasa Ekstre Raporu
Logo Yazılım dan Sql Managent tarafından Kasa Ekstre Raporu için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT (SELECT CODE FROM LG_001_KSCARD WHERE LOGICALREF=ISLEM.CARDREF) As 'Kasa Kodu', (SELECT NAME FROM LG_001_KSCARD WHERE LOGICALREF=ISLEM.CARDREF) As 'Kasa Adı', CONVERT(nvarchar(50),(ISLEM.DATE_),103) As 'Tarih', ISLEM.FICHENO As 'Fiş No', ISLEM.CUSTTITLE As 'Ünvan', ISLEM.LINEEXP As 'Açıklama', Case ISLEM.SIGN When 0 Then ISLEM.AMOUNT ELSE 0 End As 'Tahsilatlar', Case ISLEM.SIGN When 1 Then ISLEM.AMOUNT ELSE 0 End As 'Ödemeler' FROM LG_001_01_KSLINES ISLEM WITH(NOLOCK) WHERE (ISLEM.DATE_ >= CONVERT(dateTime, '1-1-2016', 101)) AND (DATE_ <= CONVERT(dateTime, '12-31-2100', 101)) AND CONVERT(nvarchar(50),(ISLEM.DATE_),103) Between '1.01.2016' And '31.12.2100' ORDER BY DATE_, FICHENO |
Paylaş:
