Satış vade tarihli rapor
Logo Yazılım dan Sql Managent tarafından Satış vade tarihli rapor için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT LG_001_CLCARD.CODE AS 'Kod', LG_001_CLCARD.DEFINITION_ AS 'Ünvan', LG_001_01_INVOICE.FICHENO AS 'Fatura No', CONVERT(nvarchar(50),(LG_001_01_PAYTRANS.PROCDATE),103) AS 'Fatura Tarihi', CONVERT(nvarchar(50),(LG_001_01_PAYTRANS.DATE_),103) AS 'Ödeme Tarihi', LG_001_01_PAYTRANS.TOTAL AS 'Tutar' FROM LG_001_01_INVOICE LG_001_01_INVOICE, LG_001_01_PAYTRANS LG_001_01_PAYTRANS, LG_001_CLCARD LG_001_CLCARD WHERE LG_001_01_PAYTRANS.FICHEREF = LG_001_01_INVOICE.LOGICALREF AND LG_001_01_INVOICE.CLIENTREF = LG_001_CLCARD.LOGICALREF AND LG_001_01_PAYTRANS.CARDREF = LG_001_CLCARD.LOGICALREF AND ((LG_001_01_INVOICE.TRCODE=8) AND (LG_001_01_PAYTRANS.MODULENR=4) AND (CONVERT(nvarchar(50),(LG_001_01_PAYTRANS.PROCDATE),103) Between '01/01/2000' And '31/12/2100')) AND CONVERT(nvarchar(50),(LG_001_01_PAYTRANS.DATE_),103) Between '1.01.2016' And '31.12.2100' ORDER BY LG_001_01_PAYTRANS.DATE_, LG_001_01_INVOICE.FICHENO |
Paylaş:
