Saturday, 23 February 2019

Update Querry Batch Management,Inventory Item,Sale Item, Cancel Document (GRPO)

Batch Management -N
UPDATE OITM SET ManBtchNum='N' WHERE ITEMCODE='ITEMCODE'

Batch Management -Y
UPDATE OITM SET ManBtchNum='Y' WHERE ITEMCODE='ITEMCODE'

Inventory Item-N
UPDATE OITM SET InvntItem='N' WHERE OnHand=0 AND ITEMCODE='ITEMCODE'

Inventory Item-Y
UPDATE OITM SET InvntItem='Y' WHERE OnHand=0 AND ITEMCODE='ITEMCODE'

Sale Item-N
UPDATE OITM SET SellItem='N' WHERE OnHand=0 AND ITEMCODE='ITEMCODE'

Sale Item-Y
UPDATE OITM SET SellItem='Y' WHERE OnHand=0 AND ITEMCODE='ITEMCODE'

 Cancel Document (GRPO)
update OPDN set DocStatus = 'C' where DocNum = '2'

Update Warehouse Branch
Update OWHS Set BPLid='3' where WhsCode='STR_NAP'