Has anyone successfully found a way to search the

inventorycostrevaluation

record type?

Have you tried: select * from Transaction where Type = 'InvReval'?

Yes, it's not the same thing. The icr record type has fields that aren't on the transaction record.

Is it possible that you need to query it as a transaction and then join to the InventoryCostRevaluation from the item table? It is a curious design - I can't seem to query InventoryCostRevaluation directly at all.