store last report date per product subcase
rough knowledge of reporting periods and due dates