Purchase Price vs. Valuation

The “Purchase Price” is the price entered on the Inventory Item record. It is entered manually

It does not change to reflect purchases or sales

I have a feeling that the average price is not stored anywhere but I could be wrong

See this thread Inventory Cost Detail Report - URGENT