These SSRS reports are designed to help locate items that have been too long In-Transit, Hold In-Transit, or Held, so that staff can do a self-check for any identified items. The first looks based on Assigned Branch, and the other by shipping or holding branch (I could probably combine these at some point, but separate reports made sense when discussed initially.)
Missing In-Transit Shelf-Check (by Assigned Branch).rdl (43.9 KB)
SILS_RPT_In-Transit_Shelf-Check_Owner.sql (2.1 KB)
Missing In-Transit Shelf-Check (by Shipping or Holding Branch).rdl (42.6 KB)
SILS_RPT_In-Transit_Shelf-Check.sql (2.2 KB)