We have been making old and obsolete items inactive for roughly a year with out realizing that the inventory remains associated with the item even if the item is inactive.  It explains why we have had some variation with our last inventory valuation report.  We have roughly 300 items that show either a negative 1 or positive 1 for quantity on hand.

So here is my question: is there a way to adjust all these to Zero with out making them active then doing an adjustment one at a time.

I tried bulk update- but there is no quantity on hand option for updating it.