The main reason we are adjusting the cost is for accounting purposes. We are required to adjust (write off) the value of our inventory items to their current market value, before submitting the year end cost value of our inventory to our accountant.

It kills 3 birds with one stone to do the cost write off, reduce the selling price and produce a clearance list for our customers at the same time.

I think I can accomplish this with Gridview producing the initial report. Edit the spreadsheet with new costs and new selling prices. Import/Items to change the selling price and Import/Adjustments to lower/write off the costs.

We don't need to use a "sale price" in this case because the new price is permanentantly lowered, not temporary.