Could anyone please advise me how to generate a report for stock valuation.

My real time (automated) stock valuation has never worked due to incorrect configuration so the stock input account has not taken sales into account.  

I would like to generate a report showing:

Product name / part number

Quantity on hand

Cost price

Total cost price of all stock on hand