I need to figure out a way to create inventory reports that shows the Actual Cost. In IC I can use the F6 search feature and add columns to the grid to get all the info I need except for Actual Cost. I can create something similar in Gridview with the Table "I/C Items (1,3) Master", however, it still doesn't give me the Actual Cost. Is there a table or calculation I can use in Gridview to get the Actual Cost???

We are dealing with an inventory of more than 5,000 items and we need to produce clearance lists regularly. The first thing we need to look at are the items that aren't moving, the selling price, and our Actual Cost on those items. Then we can easily mark down the pricing on those items accordingly.