ERP Sistemleri İçin SQL Sorguları, KPI Formülleri ve Ücretsiz Araçlar

SELECT s.STOKKODU, s.STOKADI, SUM(h.MIKTAR) AS TOPLAM_SATIS, AVG(s.BAKIYE) AS ORT_STOK, ROUND( SUM(h.MIKTAR) / NULLIF(AVG(s.BAKIYE),0), 2 ) AS DEVIR_HIZI FROM LG_STOK s LEFT JOIN LG_HAREKET h ON s.LOGICALREF = h.STOCKREF WHERE h.DATE_ >= DATEADD(month,-3,GETDATE()) GROUP BY s.STOKKODU, s.STOKADI ORDER BY DEVIR_HIZI DESC

SELECT c.UNVAN AS MUSTERI, f.FISNO AS FATURA_NO, f.DATE_ AS TARIH, f.TOTALDISCOUNTED AS TUTAR, DATEDIFF(day, f.DATE_, GETDATE()) AS GECEN_GUN FROM LG_CLCARD c JOIN LG_INVOICE f ON c.LOGICALREF = f.CLIENTREF WHERE f.TRCODE = 8 AND f.CANCELLED = 0 AND DATEDIFF(day, f.DATE_, GETDATE()) > 30 ORDER BY GECEN_GUN DESC

SELECT wo.WO_NO, wo.PART_NO, wo.QTY_DEMAND AS PLANLANAN, wo.QTY_COMPLETE AS TAMAMLANAN, ROUND( wo.QTY_COMPLETE * 100.0 / NULLIF(wo.QTY_DEMAND,0), 1 ) AS TAMAMLANMA_PCT, wo.REAL_SHIP_DATE FROM SHOP_ORD wo WHERE wo.OBJSTATE = 'Released' AND wo.REAL_SHIP_DATE IS NULL ORDER BY wo.WO_NO

SELECT kostl AS MALIYET_MERKEZI, ktext AS ACIKLAMA, SUM(wkgbtr) AS TOPLAM_MALIYET, gjahr AS YIL, poper AS DONEM FROM COSP JOIN CSKT ON COSP.kostl = CSKT.kostl WHERE gjahr = YEAR(GETDATE()) AND CSKT.spras = 'TR' GROUP BY kostl, ktext, gjahr, poper ORDER BY TOPLAM_MALIYET DESC