How to make items with QTY=0 Inactive ?

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date How to make items with QTY=0 Inactive ? Robert 03-27-2007
Posted by Robert on March 27, 2007, 10:07 pm Please log in for more thread options I'm trying to cleanup my database for few reasons. Is there a way to make all items that On hand QTY of 0 Inactive ? This would help me i generating reports and printing labels. I tired inventory wizard and filters but the On hand qty is not one of the filter options. Seems this should be easy to run as SQL Query but i do not know the command Thanks for all help Thanks Robert Similar Threads Posted RE: How to make items with QTY=0 Inactive ? March 27, 2007, 7:55 pm RE: How to make items with QTY=0 Inactive ? March 27, 2007, 8:05 pm make items inactive November 9, 2007, 1:38 pm sql - make items inactive May 15, 2008, 11:27 am Delete Items and Make Items Inactive January 27, 2009, 10:57 am Make Inactive & May Not Be Placed on PO September 22, 2008, 3:37 pm make item inactive January 12, 2008, 3:20 am Inactive Items May 16, 2007, 6:47 pm Making Items Inactive October 18, 2006, 2:27 pm Delete inactive items November 3, 2006, 4:56 pm