“What's our inventory worth by warehouse?”

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
   Read Fishbowl notes · INVENTORY.md
4. 4
   Read Fishbowl notes · ACCOUNTING.md
5. 5
   Total inventory value broken down by warehouse (location group), at average cost

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT lg.name AS locationGroup, COUNT(DISTINCT q.PARTID) AS parts, ROUND(SUM(q.QTY), 2) AS qtyOnHand, ROUND(SUM(q.QTY * pc.avgCost), 2) AS valueAtAvgCost, SUM(CASE WHEN pc.partId IS NULL OR pc.avgCost = 0 THEN 1 ELSE 0 END) AS partsWithNoCost
   FROM qtyonhand AS q
   JOIN locationgroup AS lg ON lg.id = q.LOCATIONGROUPID
   LEFT JOIN partcost AS pc ON pc.partId = q.PARTID
   WHERE q.QTY <> @zero
   GROUP BY lg.name
   ORDER BY valueAtAvgCost DESC
   LIMIT 101

   4 rows · 256 ms
6. 6
   Confirm the costing method and company-wide inventory value to cross-check the by-warehouse totals

   Cross-check: costing method plus company-wide totals from partcost and open cost layers

   ✓ passed read-only checkrow cap applied

   Show the SQL

   ? rows · ? ms
7. 7
   Confirm the costing method and company-wide inventory value to cross-check the by-warehouse totals

   Retry of cross-check after a connection error: costing method plus company-wide totals from partcost and open cost layers

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT (SELECT sysValue
   FROM sysproperties
   WHERE sysKey = @k) AS costingMethod, (SELECT ROUND(SUM(totalCost), 2)
   FROM partcost) AS partcostTotal, (SELECT ROUND(SUM(totalCost), 2)
   FROM costlayer
   WHERE statusId = @open) AS openLayerTotal
   LIMIT 101

   1 row · 190 ms