Merhaba Arkadaşlar,
İki Query yadım.
1. Bnfline toplamları
SELECT DAY(BNF.DATE_)AS 'GÜN',MONTH(BNF.DATE_)AS 'AY', YEAR (BNF.DATE_) AS IL,
ISNULL(SUM(CASE WHEN BNF.TRCODE=3 AND BNF.specode='TUTAR' THEN BNF.DEBITTOT END),0) AS GELEN,
ISNULL(SUM(CASE WHEN BNF.TRCODE=3 AND BNF.specode='KDV' THEN BNF.DEBITTOT END),0) AS KDV,
ISNULL(SUM(CASE WHEN BNF.TRCODE=1 AND BNF.specode='MASRAF' THEN BNF.CREDITTOT END),0) AS MASRAF,
ISNULL(SUM(CASE WHEN BNF.TRCODE=4 AND BNF.MODULENR=7 AND BNF.SIGN=1 THEN BNF.CREDITTOT END),0) -
ISNULL(SUM(CASE WHEN BNF.TRCODE=4 AND BNF.MODULENR=7 AND BNF.SIGN=1 AND BNF.SPECODE ='EDV' THEN BNF.CREDITTOT END),0) AS ÖDEME
FROM LG_001_04_BNFICHE AS BNF WHERE BNF.TRCODE IN (1,3,4)
GROUP BY BNF.DATE_
ORDER BY BNF.DATE_2. Stline toplamları
SELECT DAY (ST.DATE_) as'GÜN' ,MONTH(ST.DATE_) as 'Ay',YEAR(ST.DATE_) AS YIL,
ISNULL(SUM(CASE WHEN ST.TRCODE=8 THEN ST.GROSSTOTAL END),0) AS [SATIŞ],
ISNULL(SUM(CASE WHEN ST.TRCODE=8 THEN ST.TOTALDISCOUNTS END),0) AS [İNDİRİM],
ISNULL(SUM(CASE WHEN ST.TRCODE=3 THEN ST.TOTALDISCOUNTS END),0) AS [İADE],
((SUM(CASE ST.TRCODE WHEN 8 THEN ST.GROSSTOTAL ELSE 0 END)) - (SUM(CASE ST.TRCODE WHEN 8 THEN ST.TOTALDISCOUNTS ELSE 0 END))-
(SUM(CASE ST.TRCODE WHEN 3 THEN ST.TOTALDISCOUNTED ELSE 0 END )))AS [NET_SATIŞ],
(SUM(CASE ST.TRCODE WHEN 8 THEN ST.TOTALVAT ELSE 0 END)-SUM(CASE ST.TRCODE WHEN 3 THEN ST.TOTALVAT ELSE 0 END)) AS [KDV],
SUM(CASE ST.TRCODE WHEN 1 THEN ST.GROSSTOTAL ELSE 0 END) AS [ALIŞ]
FROM LG_001_04_STFICHE AS ST WHERE ST.TRCODE IN (1,3,8)
GROUP BY ST.DATE_
ORDER BY ST.DATE_Şimdi bu kodu birleşdiremiyorum
İlginc bir şey var
02.01 de fnfline-de hareket var ama stfiche de o tarihde yok. ve ya tersi.
Bu konuda yarımçı olmanızı rica ediyorum
