LOGO HAREKET GOREN MALZEME BIRIM DEISTIRME

SELECT LOGICALREF,CODE,NAME FROM LG_211_UNITSETF BIRIMLER WITH(NOLOCK)

UPDATE LG_211_ITEMS SET UNITSETREF=6 WHERE CODE='yem-069' AND UNITSETREF=35
UPDATE LG_211_ITEMS SET UNITSETREF=6 WHERE CODE='yem-070' AND UNITSETREF=35


SELECT *
FROM LG_211_ITMUNITA WITH(NOLOCK) WHERE ITEMREF=MALZEMENIN LOGICALREFI

UPDATE LG_211_ITMUNITA  SET UNITLINEREF=UOMREF WHERE ITEMREF=MALZEMENIN LOGICALREFI