Report that breaks out allocated cost

SUGGESTED

We need a report (preferably one that would easily import into Excel) that breaks out the allocated cost for inventory receipts by lot.  You can look at this information in the cost detail tab, but I cannot find a report that shows this information separately in any of the canned reports in the inventory module (inventory receipts history, inventory detail transaction).  Am I missing something, or are we going to have to have a custom report done?  The inventory item listing shows the last allocated cost, but I need to be able to show allocated costs for all lots received in a given date range.