SentezPositive Stok Giriş/Çıkış Kalan Raporu SQL Sorgusu
Select SK.KOD As [Stok Kodu], SK.ADI As [Stok Adı],
round(isnull((Select Sum(S.MIKTAR) From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP < 20 And
S.TIP <> 17), 0), 2) As [Giriş Miktarı], round(isnull((Select Sum(S.MIKTAR)
From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP > 19 And
S.TIP < 50), 0), 2) As [Çıkış Miktarı], round(isnull((Select Sum(S.MIKTAR)
From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP < 20 And
S.TIP <> 17), 0) - isnull((Select Sum(S.MIKTAR) From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP > 19 And
S.TIP < 50), 0), 2) As [Kalan Miktarı], SK.AFIYAT1 As Fiyat,
round(round(isnull((Select Sum(S.MIKTAR) From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP < 20 And
S.TIP <> 17), 0) - isnull((Select Sum(S.MIKTAR) From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP > 19 And
S.TIP < 50), 0),2) * SK.AFIYAT1, 2) As Tutar
From SKART SK
Where SK.KOD >= :['Başlangıç Kodu'#>=#1] And
SK.KOD <= :['Bitiş Kodu'#<=#1#ZZZZZ] And (Select Count(*) From SFISD S
Where S.SIRKET = SK.SIRKET And S.MKOD = SK.KOD And S.TIP < 50 And
S.TIP <> 17) > 0
Order By SK.KOD