Wednesday, 20 September 2017

Check or Uncheck Item Master Data (Inventory,Sale,Purchase)

update table name
set (inventory,sale,purchase)=Y
where itemcode =rem0012 and inventroy=N

update OITM
set InvntItem ='N'
where itemcode ='SFG0920'  and InvntItem = 'Y'

No comments :

Post a Comment