Logo Sql Insert Into LG_XT1001_001 Parlogref
DELETE LG_XT1001_001;INSERT INTO LG_XT1001_001 (PARLOGREF,MERKEZ,DEPO2 )SELECTITM.LOGICALREF,(SELECT SUM(ONHAND) FROM LV_001_XX_STINVTOT WHERE STOCKREF=ITM.LOGICALREF AND INVENNO=0) AS MERKEZ,(SELECT SUM(ONHAND) FROM LV_001_XX_STINVTOT WHERE STOCKREF=ITM.LOGICALREF AND INVENNO=2) AS DEPO2 FROM LG_001_ITEMS ITMWHERE CARDTYPE<>22 Logo Malzemeler ana ekranına eklenen ek depolardaki stok…













