Inventory Valuation Report - Get Item Value for Crystal Report

Hi Everyone,

I've been working on a couple of custom reports for my current company and I ran into only one issue which I can't figure out.

I need to create a report pretty much like the Inventory Valuation Report but with other fields that are not in the current sage report. I've been able to get all the fields I need except the Item Value (which I know has to do with the item costing report). I was wondering, is there a way to actually get this value in crystal report with a given date (same as the original sage report filter)? I wasn't to find a formula or anything online that could help me out.

Thanks in advance,

Miguel Martorell