Invnetory ageing report

I am in search of a report builder report that will give me part
number, bin location, onhand quantity and date last shipped or of the
last inventory transaction for that part.

Does any one have such a report that they could send me?

Does any one know what table and files refers to the last transaction
date or shipdate for a part number

Thank you