Is there a reason the Item Valuation Report will only calculate and display the four valuations (actual, mrc, selling and std cost, or whatever you choose) when the valuation date is set to the current (actual system) date? When you backdate the valuation date field, even one day, the only valuation you get is the actual cost. (ver 81A 070825)
Thank you for your help.

Hello Ed,

The 1 line per item, Item valuation report was added because of suggestions made to improve Inventory Control.

If you want the extra information, I suggest that you use Crystal Reports for Adagio to create a Custom Report

Thanks for the info, but what I meant to say is that the report does produce the information just like the old Plus IC, which was sufficient, but only when the valuation date is the system/current date. If you simply change the valuation date to say the last day of the previous month, holding everything else constant, the report drops out the other valuations and gives you only the actual cost valuation. Seems strange that it would do that. Can't really see the need for a custom Crystal report.

Hi Ed,

If you look at the information stored in the Item History file, you'll see that only changes to actual cost are recorded there. We do not store changes to Standard Cost or Most Recent Cost or the price changes. We have no way of knowing what the most recent cost was on the date you select, when it is in the past.

This report is designed to allow you to print a report where the cost of inventory will agree to the number in the general ledger, if you forgot to print your item valuation report at month end. The number is calculated by backing out the historical transactions from the current numbers stored with the inventory item.

Why would the other columns be useful?

PS - This capability did not exist at all in ACCPAC Plus.

That sounds reasonable enough. I'll pass the info along.
Thanks again.