Handling books on the shelf that didn't get checked in
When a book on the shelf was accidentally not checked in and another user brings it to the desk, it clears the original checkout and adds a fine without generating a message to let us know. In most cases, we would waive those fines, since the book had obviously been returned. We would love to see a pop-up when that happens so we can go and waive the fine on the previous customer's record

-
K Floyd commented
Depending on your volume of loans, the report described in this linked document might work: https://docs.google.com/document/d/1NoFIW7Rw_awuGHuFHLVesk_EjhWdpg4IF4QaNGm8SnU/edit?usp=sharing
-
K Floyd commented
A flag similar to the in-house loan indicator on a transaction would be very helpful, e.g. Returned through automatic handling. We had the automatic handling turned off, which did create a pop-up about the item not being returned. Unfortunately, that left resolving the situation to student workers, who did not always handle the situation correctly or notify supervisors about it.
I'm working on identifying these transactions based on having a loan date/time that matches another item's return date/time but it must be limited by date because it runs through several sub-queries and is slow.