While there are several posts going on about deleting parts, I have a larger question.  I have thousands of parts that I want to remove.  My plan is to create a guide file of the items that I want to remove an run SQL deletes to the files that contain these items.  BKICMSTR, BKICLOC, BKAPPOL, INVTXN, etc.  I plan to ensure that the quantity fields are all zero.  Delete them all, them re-index all of the files.  My desire is too totally throw away all of the stuff that's not currently generating revenue.  Some of these items we saw activity in 1999 and will never see again.  I have no need to keep history or anything on the system.  I want to chop our item master, bom, routing and all from the 38000 items to about 15000 that have had activity in the past couple years or that have active quotes.  My questions: (probably for the tech folks)  
1. does this seem like a logical approach?
2. has anyone done this is the past
3. is there a way to do this without deleting one item at a time
 
In advance, thank you for your comments.
 
Rod         By the way we are still on DBA Classic due to company buyout and transition.

I agree with GG on the two step process, but you might want to consider exporting you inventory to Excel, identify the items for deletion then reimport the inventory back into DBA.  This gives you more flexibility in your editing.  I used the Category to identify the ones I wanted to get rid of by entering "ZZZZ" in this field, but "D" in the status will work also.  Remember to back up before doing anything of this nature.  I even made a seperate copy of the files being modified so that if I screwed up at least I could get back to my starting point.
 
I think you also need to make changes to MTICMSTR during this process.