Aylara göre stok hareket raporu
Logo Yazılım dan Sql Managent tarafından Aylara göre stok hareket raporu için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT LG_001_ITEMS.CODE AS 'Kod', LG_001_ITEMS.NAME AS 'Açıklama', LG_001_ITEMS.SPECODE AS 'Özel Kod', LG_001_ITEMS.STGRPCODE AS 'Grup Kodu',SUM(LG_001_01_STLINE.AMOUNT) AS 'Miktar', LG_001_UNITSETL.NAME AS 'Birim', CASE LG_001_01_STLINE.TRCODE WHEN 1 THEN 'Satinalma' WHEN 2 THEN 'Perakende Satış iade' WHEN 3 THEN 'Toptan Satış iade' WHEN 4 THEN 'Kons. Çıkış İade' WHEN 5 THEN 'Konsinye Giriş' WHEN 6 THEN 'Satinalma iade' WHEN 7 THEN 'Perakende satış' WHEN 8 THEN 'Toptan Satis' WHEN 9 THEN 'Konsinye çıkış' WHEN 10 THEN 'Konsinye Giriş İade' WHEN 11 THEN 'Fire' WHEN 12 THEN 'Sarf' WHEN 13 THEN 'Üretimden Giris' WHEN 14 THEN 'Devir' WHEN 25 THEN 'Ambar Fisi' WHEN 26 THEN 'MÜstahsil' WHEN 50 THEN 'Sayim Fazlasi' WHEN 51 THEN 'Sayim Eksigi' end AS 'Fis Türü', CASE MONTH(LG_001_01_STLINE.DATE_) WHEN '1' THEN 'OCAK' WHEN '2' THEN 'ŞUBAT' WHEN '3' THEN 'MART' WHEN '4' THEN 'NiSAN' WHEN '5' THEN 'MAYIS' WHEN '6' THEN 'HAZiRAN' WHEN '7' THEN 'TEMMUZ' WHEN '8' THEN 'AĞUSTOS' WHEN '9' THEN 'EYLÜL' WHEN '10' THEN 'EKiM' WHEN '11' THEN 'KASIM' WHEN '12' THEN 'ARALIK' END AS 'Fiş Ayı' FROM LG_001_01_STFICHE LG_001_01_STFICHE, LG_001_01_STLINE LG_001_01_STLINE, LG_001_ITEMS LG_001_ITEMS, LG_001_UNITSETL LG_001_UNITSETL WHERE LG_001_01_STLINE.STFICHEREF = LG_001_01_STFICHE.LOGICALREF AND LG_001_01_STLINE.UOMREF = LG_001_UNITSETL.LOGICALREF AND LG_001_ITEMS.LOGICALREF = LG_001_01_STLINE.STOCKREF AND LG_001_01_STFICHE.PRODSTAT=0 GROUP BY LG_001_ITEMS.NAME , LG_001_ITEMS.CODE , LG_001_ITEMS.SPECODE, LG_001_ITEMS.STGRPCODE , LG_001_UNITSETL.NAME , LG_001_01_STLINE.TRCODE , MONTH(LG_001_01_STLINE.DATE_) |
Paylaş:
