Dakota Softwware has a "Clear Item Quantities and Costs" function as part of the Toolkit.

I've not used it, so I can't say whether it will help for your scenario, but it may be worth a look.

http://www.dakotasoftware.com/toolkit.html