Merhaba ,
Yol göstermesi dilegiyle
kendinize göre uyarlayın..
SELECT MLZ.NAME ,
STITOTS.STOCKREF ,
SUM(STITOTS.RESERVED - STITOTS.SHIPPED) AS [ALINAN_ŞİPARİŞLER] ,
SUM(STITOTS.ONHAND) AS [FİİLİ_STOK] ,
SUM(STITOTS.ACTPORDER) AS [VERİLEN_SİPARİŞLER] ,
( STITOTS.ONHAND + STITOTS.ACTPORDER ) - STITOTS.RESERVED AS [FARK]
FROM LV_FFF_FF_STINVTOT STITOTS WITH ( NOLOCK )
JOIN dbo.LG_FFF_ITEMS AS MLZ ON MLZ.LOGICALREF = STITOTS.STOCKREF
WHERE ( STITOTS.INVENNO <> -1 AND STITOTS.INVENNO <> 3 )
AND ( STITOTS.DATE_ > CONVERT(DATETIME, '01-01-2000', 101) )
AND ( STITOTS.DATE_ <= CONVERT(DATETIME, GETDATE(), 101) )
AND MLZ.CARDTYPE = 1
GROUP BY MLZ.NAME ,
STITOTS.STOCKREF ,
( STITOTS.ONHAND + STITOTS.ACTPORDER ) - STITOTS.RESERVED;