You can find the source tables associated with a report by adding a temp UDF (don't save...) to the work table and review the list of linked tables available as a data source.

Thanks. That gave me a list of available linked tables to add to the work file, but did not tell me where it is pulling it's history from by period for the valuation.

Sorry... that usually works.  Try:

IM_ItemWhseHistoryByPeriod

Thanks. That's not it either. I have pretty much looked at all the "byPeriod" tables and can't seem to tie anything together for an item. I have run the report in MAS for one item and period and am trying to figure out how the report is deriving it's numbers.

Ah.  I was probably thinking about the Turnover report, not Valuation.

Have you looked at IM_ItemTransactionHistory?

I think that is it! I was hoping for a summary by period but it appears to be summing all transactions for a givin item/whse.

Thanks for your time.

I think that is it! I was hoping for a summary by period but it appears to be summing all transactions for a givin item/whse.

Thanks for your time.