Date Sensitive Lot Report

Has anyone already developed a fiscal year/period sensitive lot report by location and item that ties to the valuation?  I would love to not recreate the wheel....