SentezPositive Satış Raporu SQL Sorgusu
Select CK.KOD As [Cari Hesap Kodu], CK.ADI As [Cari Hesap Adı],
S.MKOD As [Stok Kodu], isnull(SK.ADI, '') As [Stok Adı],
round(Sum(S.MIKTAR), 2) As Miktar, round(Sum(dbo.fn_CalcNetAmount(S.MIKTAR,
S.FIYAT, S.KDVDH, S.KDV, S.ISKTUTAR, S.ISK1, S.ISK2, S.ISK3, SF.ISKONTOT,
SF.TOPLAM, SF.KDVT, SF.MASRAF, SK.CARPAN1, SK.BOLEN1, SK.CARPAN2, SK.BOLEN2,
S.BRM)), 2) As Tutar
From CKART CK Inner Join
SFISD S On S.SIRKET = CK.SIRKET And S.CKOD = CK.KOD Left Join
SFIS SF On S.SIRKET = SF.SIRKET And S.TIP = SF.TIP And S.FISNO = SF.FISNO
Left Join
SKART SK On S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD
Where S.TIP In (20, 21) And S.TARIH >= :['İlk Tarih'#>=#2#01.01.2007] And
S.TARIH <= :['Son Tarih'#<=#2#31.12.2007]
Group By CK.KOD, CK.ADI, S.MKOD, SK.ADI
Order By CK.KOD, S.MKOD