mrb üstadlar öncelikle burada bana ve benim gibi daha bu programı yeni kullanmaya başlayanlara verdiğiniz bilgilerden dolayı çok teşekkür ederim. Benim şöyle bir problemim var, firmamızda kullanmak üzere bir arkadaştan stok durumlarını görebileceğim bir qery kodu aldım fakat ben bunu kendi firmama göre uyarladığımda 4 ncü ambardan sonra yanlış veriyor (bu arada benim firmamdaki ambar sayısı 11) bunun için ne yapmalıyım şimdiden ilginizden dolayı teşekkür ederim,
SELECT URUN.CODE AS 'ÜRÜN KODU',
URUN.NAME AS 'ÜRÜN ADI',
'GENEL '= CASE WHEN (AMBARM.MIKTAR IS NULL) THEN '0' WHEN (AMBARM.MIKTAR IS NOT NULL) THEN AMBARM.MIKTAR END,
'AMBAR 0'= CASE WHEN (AMBAR0.MIKTAR IS NULL) THEN '0' WHEN (AMBAR0.MIKTAR IS NOT NULL) THEN AMBAR0.MIKTAR END,
'AMBAR 1'= CASE WHEN (AMBAR1.MIKTAR IS NULL) THEN '0' WHEN (AMBAR1.MIKTAR IS NOT NULL) THEN AMBAR1.MIKTAR END,
'AMBAR 2'= CASE WHEN (AMBAR2.MIKTAR IS NULL) THEN '0' WHEN (AMBAR2.MIKTAR IS NOT NULL) THEN AMBAR2.MIKTAR END,
'AMBAR 3'= CASE WHEN (AMBAR3.MIKTAR IS NULL) THEN '0' WHEN (AMBAR3.MIKTAR IS NOT NULL) THEN AMBAR3.MIKTAR END,
'AMBAR 4'= CASE WHEN (AMBAR4.MIKTAR IS NULL) THEN '0' WHEN (AMBAR4.MIKTAR IS NOT NULL) THEN AMBAR4.MIKTAR END,
'AMBAR 5'= CASE WHEN (AMBAR5.MIKTAR IS NULL) THEN '0' WHEN (AMBAR5.MIKTAR IS NOT NULL) THEN AMBAR5.MIKTAR END,
'AMBAR 6'= CASE WHEN (AMBAR6.MIKTAR IS NULL) THEN '0' WHEN (AMBAR6.MIKTAR IS NOT NULL) THEN AMBAR6.MIKTAR END,
'AMBAR 7'= CASE WHEN (AMBAR7.MIKTAR IS NULL) THEN '0' WHEN (AMBAR7.MIKTAR IS NOT NULL) THEN AMBAR7.MIKTAR END,
'AMBAR 8'= CASE WHEN (AMBAR8.MIKTAR IS NULL) THEN '0' WHEN (AMBAR8.MIKTAR IS NOT NULL) THEN AMBAR8.MIKTAR END,
'AMBAR 9'= CASE WHEN (AMBAR9.MIKTAR IS NULL) THEN '0' WHEN (AMBAR9.MIKTAR IS NOT NULL) THEN AMBAR9.MIKTAR END,
'AMBAR 10'= CASE WHEN (AMBAR10.MIKTAR IS NULL) THEN '0' WHEN (AMBAR10.MIKTAR IS NOT NULL) THEN AMBAR10.MIKTAR END,
'AMBAR 11'= CASE WHEN (AMBAR11.MIKTAR IS NULL) THEN '0' WHEN (AMBAR11.MIKTAR IS NOT NULL) THEN AMBAR11.MIKTAR END,
'A.FIYAT'= CASE WHEN (ALIS.MIKTAR IS NULL) THEN '0' WHEN (ALIS.MIKTAR IS NOT NULL) THEN ALIS.MIKTAR END,
'S.FIYAT'= CASE WHEN (SATIS.MIKTAR IS NULL) THEN '0' WHEN (SATIS.MIKTAR IS NOT NULL) THEN SATIS.MIKTAR END,
'A.DEGER'= CASE WHEN (AMBARM.MIKTAR * ALIS.MIKTAR IS NULL) THEN '0' WHEN (AMBARM.MIKTAR * ALIS.MIKTAR IS NOT NULL) THEN AMBARM.MIKTAR * ALIS.MIKTAR END,
'S.DEGER'= CASE WHEN (AMBARM.MIKTAR * SATIS.MIKTAR IS NULL) THEN '0' WHEN (AMBARM.MIKTAR * SATIS.MIKTAR IS NOT NULL) THEN AMBARM.MIKTAR * SATIS.MIKTAR END
FROM {oj LG_004_ITEMS URUN LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=-1 GROUP BY STOCKREF)
AMBARM ON URUN.LOGICALREF = AMBARM.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=0 GROUP BY STOCKREF)
AMBAR0 ON URUN.LOGICALREF = AMBAR0.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=1 GROUP BY STOCKREF)
AMBAR1 ON URUN.LOGICALREF = AMBAR1.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=2 GROUP BY STOCKREF)
AMBAR2 ON URUN.LOGICALREF = AMBAR2.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=3 GROUP BY STOCKREF)
AMBAR3 ON URUN.LOGICALREF = AMBAR3.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR4 ON URUN.LOGICALREF = AMBAR4.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR5 ON URUN.LOGICALREF = AMBAR5.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR6 ON URUN.LOGICALREF = AMBAR6.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR7 ON URUN.LOGICALREF = AMBAR7.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR8 ON URUN.LOGICALREF = AMBAR8.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR9 ON URUN.LOGICALREF = AMBAR9.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR10 ON URUN.LOGICALREF = AMBAR10.STOCKREF LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LG_004_01_STINVTOT WHERE INVENNO=4 GROUP BY STOCKREF)
AMBAR11 ON URUN.LOGICALREF = AMBAR11.STOCKREF LEFT JOIN ((SELECT MAX(PRICE) AS 'MIKTAR',CARDREF FROM LG_004_PRCLIST WHERE PTYPE=1 GROUP BY CARDREF)) ALIS ON URUN.LOGICALREF = ALIS.CARDREF LEFT JOIN ((SELECT MAX(PRICE)
AS 'MIKTAR',CARDREF FROM LG_004_PRCLIST WHERE PTYPE=2 GROUP BY CARDREF)) SATIS ON URUN.LOGICALREF = SATIS.CARDREF } WHERE URUN.CARDTYPE<>'22' ORDER BY URUN.CODE
