“Why is our cost for chocolate chips different from what we paid on the last purchase order?”

Every step the AI took

1. 1
   Read the Fishbowl notes index
   13 topic notes
2. 2
   Checked the saved queries
   6 saved queries
3. 3
   Find the chocolate chips part and its standard cost

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT p.id, p.num, p.description, p.stdCost, p.activeFlag, p.uomId, u.code AS uom
   FROM part AS p
   LEFT JOIN uom AS u ON u.id = p.uomId
   WHERE p.num LIKE @q OR p.description LIKE @q
   LIMIT 101

   6 rows · 248 ms
4. 4
   Current average cost record for chocolate chips part CR403

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT pc.*
   FROM partcost AS pc
   WHERE pc.partId = @pid
   LIMIT 101

   1 row · 261 ms
5. 5
   Purchase order lines for chocolate chips CR403, newest first, with unit cost and UOM

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT po.num AS poNum, po.dateIssued, po.dateCompleted, pos.name AS poStatus, v.name AS vendor, poi.id AS poItemId, poi.poLineItem, poi.partNum, poi.vendorPartNum, poi.qtyToFulfill, poi.qtyFulfilled, poi.unitCost, poi.totalCost, u.code AS poUom, pis.name AS itemStatus, poi.typeId
   FROM poitem AS poi
   JOIN po ON po.id = poi.poId
   LEFT JOIN postatus AS pos ON pos.id = po.statusId
   LEFT JOIN poitemstatus AS pis ON pis.id = poi.statusId
   LEFT JOIN vendor AS v ON v.id = po.vendorId
   LEFT JOIN uom AS u ON u.id = poi.uomId
   WHERE poi.partId = @pid
   ORDER BY po.dateIssued DESC, po.id DESC
   LIMIT 101

   2 rows · 189 ms
6. 6
   Cost layers for chocolate chips CR403

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT cl.*
   FROM costlayer AS cl
   WHERE cl.partId = @pid
   ORDER BY cl.dateCreated DESC
   LIMIT 101

   11 rows · 247 ms
7. 7
   UOM conversions involving lbs, the stocking unit of chocolate chips

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT uc.id, fu.code AS fromUom, tu.code AS toUom, uc.multiply, uc.factor, uc.description
   FROM uomconversion AS uc
   JOIN uom AS fu ON fu.id = uc.fromUomId
   JOIN uom AS tu ON tu.id = uc.toUomId
   WHERE uc.fromUomId = @u OR uc.toUomId = @u
   LIMIT 101

   8 rows · 295 ms
8. 8
   Inventory transaction history for chocolate chips CR403 with cost per event

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT il.id, il.eventDate, il.dateCreated, ilt.name AS logType, il.changeQty, il.qtyOnHand, il.cost, il.recordId, il.tableId, il.info, lg.name AS locGroup, l.name AS location
   FROM inventorylog AS il
   LEFT JOIN inventorylogtype AS ilt ON ilt.id = il.typeId
   LEFT JOIN location AS l ON l.id = il.begLocationId
   LEFT JOIN locationgroup AS lg ON lg.id = il.locationGroupId
   WHERE il.partId = @pid
   ORDER BY il.id
   LIMIT 301

   69 rows · 428 ms
9. 9
   Which inventory costing method the company uses

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT sp.sysKey, sp.sysValue
   FROM sysproperties AS sp
   WHERE sp.sysKey LIKE @k
   LIMIT 101

   5 rows · 190 ms
10. 10
    Receipt lines for chocolate chips CR403 including billed and landed cost

    ✓ passed read-only checkrow cap applied

    Show the SQL

    SELECT ri.id, r.id AS receiptId, ri.poItemId, ri.qty, ri.dateReceived, ri.dateReconciled, ri.billedTotalCost, ri.landedTotalCost, ri.dateLastModified, ris.name AS status
    FROM receiptitem AS ri
    JOIN receipt AS r ON r.id = ri.receiptId
    LEFT JOIN receiptitemstatus AS ris ON ris.id = ri.statusId
    WHERE ri.partId = @pid
    ORDER BY ri.id
    LIMIT 101

    2 rows · 287 ms