UPDATE ProductionMasterItemFP SET COST=PURHRATE FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG15888'

UPDATE ProductionMasterItemFP SET COST=PURHRATE FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG12608'

UPDATE ProductionMasterItemFP SET COST=PURHRATE FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG3229'


UPDATE ProductionMasterItemFP SET COST=PURHRATE FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG06597'
UPDATE ProductionMasterItemFP SET COST=0 FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG12746'
UPDATE PURCHASEITEM SET STORESHOP='SHOP'
UPDATE ProductionMasterItemFP SET COST=470.95 FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG15888'
UPDATE ProductionMasterItemFP SET COST=0 FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='nescafe 190g' AND DOCNO='1154'

UPDATE ProductionMasterItemFP SET COST=0 FROM ITEM WHERE ITEM.ITEMCODE=ProductionMasterItemFP.ITEMCODE AND ITEM.ITEMCODE='IBG06602' AND DOCNO='1133'