Last In House Use column
Currently, to run a report based on the in-house use date (e.g. staff want to weed items that haven't been checked out or checked in via in house in 2 years) I need to create a custom report for them that pulls off the transactions database. Staff who use SimplyReports for weeding must use the LastCircTransactionDate if they want to account for in house use - but that field also gets incremented when an item is modified in any way (including the inventory date being updated and unrelated fields being changed in the record). It would be great if there could be a field in the circitemrecords table like LastInHouseUseDate that gets updated when an item is checked in via in house.