Hi people,
I have over 4000 items in the system that are neither Purchase nor Sales items but they all have stocks in various branches. I want to adjust all the stocks for these items to zero but they are so many. Is it possible to come up with a query to achieve this or is there any other quicker way out than going item by item????
Tried the query below without any success.
update oitm set oitm.OnHand ='0' where oitm.sellItem ='N' and oitm.prchseitem ='N'
Any solution will be highly appreciated.
Regards,
Henry