Historical Stock Valuation

SUGGESTED

I'm using Sage X3 (7.1.6);

I'm writing a crystal report that needs to include the value of all stock as at the end of last month.

Are there any simple ways to get this value? 

Or further still, how would I get the value of stock as at the end of April 2015 (last year)?

Thanks in advance