Stok Devir Rakamları Raporlama
no
| SELECT STITOTS.INVENNO As 'Ambar No', ITMSC.CODE AS 'Kod', ITMSC.NAME AS 'Açıklama', ITMSC.STGRPCODE AS 'Grup Kodu', ITMSC.SPECODE AS 'Özel Kod', STITOTS.STOCKREF, SUM(STITOTS.TRANSFERRED) As 'Devir Miktarı' FROM LV_001_01_STINVTOT STITOTS WITH(NOLOCK) LEFT OUTER JOIN LG_001_ITEMS ITMSC WITH(NOLOCK) ON (STITOTS.STOCKREF = ITMSC.LOGICALREF) Where Not INVENNO=-1 GROUP BY ITMSC.CODE, ITMSC.NAME, ITMSC.STGRPCODE, ITMSC.SPECODE, STOCKREF, INVENNO |
Paylaş:
