“What's sitting in Receiving that hasn't been put away?”

Every step the AI took

1. 1
   Checked the saved queries
   6 saved queries
2. 2
   Read the Fishbowl notes index
   13 topic notes
3. 3
   What's sitting in Receiving that hasn't been put away?

   Saved query receiving_not_put_away, approved by your admin

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT p.num AS part, p.description, ROUND(SUM(t.qty), 4) AS qty, u.code AS uom, lg.name AS locationGroup, l.name AS location, DATE(MIN(t.dateCreated)) AS oldestTagCreated, DATEDIFF(CURDATE(), MIN(t.dateCreated)) AS daysInReceiving
   FROM tag AS t
   JOIN part AS p ON p.id = t.partId
   JOIN location AS l ON l.id = t.locationId
   JOIN locationgroup AS lg ON lg.id = l.locationGroupId
   JOIN uom AS u ON u.id = p.uomId
   WHERE l.typeId = 30 AND t.qty > 0 AND (@location_group IS NULL OR lg.name = @location_group)
   GROUP BY p.num, p.description, u.code, lg.name, l.name
   ORDER BY daysInReceiving DESC, p.num
   LIMIT 1001

   30 rows · 194 ms