We have some down-costing to do on old stock and trying to find the best method.

We would like to get it done in advance of year end since the physical count and subsequent data entry is an overwhelming amount of work.

I thought I could kill 2 birds with one stone by creating a clearance list in Excel that was produced with Adagio Inventory's F6 finder, however, "Average Unit Cost" is not available to add to the grid.

How then can we produce a report that shows the average unit cost and quanties on hand so that we can down-cost?

Also, to do the data entry on the down-costing we run into the nightmarish problem of the multiple lots. Can these lots be merged to one?

Please let me know if I'm on the right track or if there is a better method for down-costing.