Skip to Content
0
Former Member
Jun 03, 2008 at 08:29 AM

Stock Adjustment

411 Views

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