I am looking for a tool to provide me with a simple report of which items have been in inventory the longest.
Does this currently exist?
Out of curiosity, do you subscribe to Lightspeed Analytics? There are quite a few reports in there, and all of them can be customized as well.
As @gregarican said, Lightspeed Analytics has a lot of reports that can help you with that: