Hi Laura,

If you print the Item Valuation report and change the date to something earlier than today, the report subtracts all historical transactions it finds, dated between the report date and today. This means that for a back-dated Item Valuation to report the correct quantities, all transactions related to the item must be in IC History. Can you confirm this? You can check the Transaction History tab from the Item Inquiries with Sales and Costs function, for that item.

For example, if your current Qty on Hand of an item is 100, and there is a transaction history record for a shipment of 24 on Nov 26th, then if you backdate the report to Nov 25th the report calculates the Qty On Hand on that date as 124. If your history is incomplete, the report cannot correctly calculate the QOH as of that day.

Certainly a Data Integrity Check that fails could be a cause, as Steve noted.