Stok Aktif /Pasif Rapor
Logo Yazılım dan Sql Managent tarafından Stok Aktif /Pasif rapor için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT LV_001_01_GNTOTST.INVENNO AS 'AmbarNo', LG_001_ITEMS.CODE AS 'Kod', LG_001_ITEMS.NAME AS 'Açıklama', LV_001_01_GNTOTST.ONHAND AS 'Stok Miktarı', LG_001_UNITSETL.CODE AS 'Birim', LG_001_ITEMS.SPECODE AS 'Özel Kod', LG_001_ITEMS.STGRPCODE AS 'Grup Kodu', LG_001_ITEMS.PRODUCERCODE AS 'Üretici Kodu', CASE LG_001_ITEMS.ACTIVE WHEN 0 THEN 'Kullanimda' WHEN 1 THEN 'Kullanim Disi' END AS 'STATU' FROM LG_001_ITEMS, LG_001_ITMUNITA, LG_001_UNITSETL, LV_001_01_GNTOTST WHERE LG_001_ITEMS.LOGICALREF = LV_001_01_GNTOTST.STOCKREF AND LG_001_ITMUNITA.ITEMREF = LG_001_ITEMS.LOGICALREF AND LG_001_ITMUNITA.UNITLINEREF = LG_001_UNITSETL.LOGICALREF AND ((LG_001_UNITSETL.LINENR='1')) And Not LV_001_01_GNTOTST.INVENNO=-1 Order By LG_001_ITEMS.CODE Asc |
Paylaş:
