FATURA VE İRSALİYE TARİHLERİ FARKLI OLAN KAYITLAR SQL KODU

[E.ALKIN]

SELECT   FAT.DOCODE  AS 'FATURANO', FAT.DATE_ AS 'FATURA TARİHİ',L.DATE_ AS 'İRSALİYE TARİHİ',DATEDIFF(day,FAT.DATE_,(L.DATE_)) AS 'FARK'

FROM LG_901_01_STLINE AS L  LEFT OUTER JOIN LG_901_01_INVOICE AS FAT ON FAT.LOGICALREF=L.INVOICEREF
WHERE L.TRCODE in (03,08) AND DATEDIFF(day,FAT.DATE_,(L.DATE_)) > '0'



Not : TRCODE kısmındaki 03 satıştan iadeleri , 08 Satışları ifade eder , dilerseniz 01 satınalma faturları ve diğer fatura türlerini de ekleyebilirsiniz

[Begenchally]

SELECT DISTINCT                       
 LG_118_01_STFICHE.TRCODE , LG_118_01_STFICHE.FICHENO , LG_118_01_STFICHE.DATE_ ,  LG_118_01_STFICHE.NETTOTAL , 
 LG_118_01_STFICHE.INVNO , LG_118_01_INVOICE.FICHENO , LG_118_01_INVOICE.NETTOTAL , LG_118_01_INVOICE.DATE_     
FROM  LG_118_01_STFICHE INNER JOIN  LG_118_01_INVOICE ON LG_118_01_STFICHE.INVNO = LG_118_01_INVOICE.FICHENO AND LG_118_01_STFICHE.TRCODE = LG_118_01_INVOICE.TRCODE AND
     (LG_118_01_STFICHE.NETTOTAL <> LG_118_01_INVOICE.NETTOTAL OR  LG_118_01_STFICHE.DATE_ <> LG_118_01_INVOICE.DATE_)