Mali Dönem Bağımsız Firma da Devreden Miktarlı Maliyet Raporu

[LsuErsoy]

Merhaba arkadaşlar ;

Konu başlığında da bahsettiğim gibi bir "Mali Dönem Bağımsız Firma da Devreden Miktarlı Maliyet Raporu" yapmaya çalışıyorum...

Aşağıda T-SQL kodunu yazdığım Devreden miktar değerini SQL info kodunu yazacağım...

Belki biriniz benden önce yazmak istersiniz diye konuyu açtım

Kod: [Seç]

SELECT
 STK.CODE [Stok Kodu],
 STK.NAME [Stok Adı],
 ISNULL((SELECT SUM(LINE.AMOUNT) FROM LG_011_01_STLINE AS LINE Where STK.LOGICALREF=LINE.STOCKREF AND LINE.TRCODE IN (1,2,3,13,14,50) AND LINE.CANCELLED=0 AND DATE_ BETWEEN '01.01.2010' AND '08.31.2012'),0) [Giren Miktar],   
 ISNULL((SELECT SUM(LINE.AMOUNT) FROM LG_011_01_STLINE AS LINE Where STK.LOGICALREF=LINE.STOCKREF AND LINE.TRCODE IN (6,7,8,11,12,51) AND LINE.CANCELLED=0 AND DATE_ BETWEEN '01.01.2010' AND '08.31.2012'),0) [Çıkan Miktar],
 ISNULL((SELECT SUM(LINE.AMOUNT) FROM LG_011_01_STLINE AS LINE Where STK.LOGICALREF=LINE.STOCKREF AND LINE.TRCODE IN (1,2,3,13,14,50) AND LINE.CANCELLED=0 AND DATE_ BETWEEN '01.01.2010' AND '08.31.2012'),0) -
 ISNULL((SELECT SUM(LINE.AMOUNT) FROM LG_011_01_STLINE AS LINE Where STK.LOGICALREF=LINE.STOCKREF AND LINE.TRCODE IN (6,7,8,11,12,51) AND LINE.CANCELLED=0 AND DATE_ BETWEEN '01.01.2010' AND '08.31.2012'),0) [Kalan]
 FROM
 LG_011_01_STLINE AS LINE INNER JOIN LG_011_ITEMS AS STK ON STK.LOGICALREF=LINE.STOCKREF
 Where CODE BETWEEN  '100001' AND '100008'
 GROUP BY STK.CODE,STK.NAME,STK.LOGICALREF
 ORDER BY STK.CODE ASC