“can you set up a new part for us and get a small starter order placed with one of our vendors for it?”

Every step the AI took

1. 1
   Checked its write permissions
   48 import types you're allowed to write
2. 2
   List active vendors with recent purchase order activity so the user can pick one for a starter order

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT v.name, COUNT(p.id) AS po_count, MAX(p.dateIssued) AS last_po
   FROM vendor AS v
   LEFT JOIN po AS p ON p.vendorId = v.id
   WHERE v.activeFlag = 1
   GROUP BY v.id, v.name
   ORDER BY last_po DESC
   LIMIT 15

   14 rows · 294 ms
3. 3
   Checked the available import types
4. 4
   Check that part DARK-COCOA doesn't exist yet, find the pound unit of measure, and confirm the exact vendor name for Brent's Food Supply

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT (SELECT COUNT(*)
   FROM part
   WHERE num = @num) AS part_exists, (SELECT GROUP_CONCAT(CONCAT(name, '|', code))
   FROM uom
   WHERE code IN ('lb', 'lbs') OR name LIKE '%pound%') AS lb_uoms, (SELECT name
   FROM vendor
   WHERE name LIKE 'Brent%'
   LIMIT 1) AS vendor_name
   LIMIT 101

   1 row · 175 ms
5. 5
   Read Fishbowl notes · IMPORT_Parts.md
6. 6
   Read Fishbowl notes · ORDER_PurchaseOrder.md
7. 7
   Get remit-to, ship-to, carrier and location group from recent Brent's Food Supply POs to reuse on the new bid request

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT p.num, p.remitToName, p.remitAddress, p.remitCity, p.remitZip, rs.code AS remitState, p.shipToName, p.shipToAddress, p.shipToCity, p.shipToZip, ss.code AS shipState, c.name AS carrier, lg.name AS locationGroup
   FROM po AS p
   JOIN vendor AS v ON v.id = p.vendorId
   LEFT JOIN stateconst AS rs ON rs.id = p.remitStateId
   LEFT JOIN stateconst AS ss ON ss.id = p.shipToStateId
   LEFT JOIN carrier AS c ON c.id = p.carrierId
   LEFT JOIN locationgroup AS lg ON lg.id = p.locationGroupId
   WHERE v.name = @vendor
   ORDER BY p.dateCreated DESC
   LIMIT 3

   3 rows · 188 ms
8. 8
   Find the company's own address to use as the ship-to on the purchase order

   ✓ passed read-only checkrow cap applied

   Show the SQL

   ? rows · ? ms
9. 9
   Prepared the import (preview)

   Show the file it prepared parts-import.csv

   Exactly what you saw and approved before anything was written.

   PartNumber	PartDescription	UOM	PartType	POItemType	Active
   DARK-COCOA	Dark Cocoa Powder	lbs	Inventory	Purchase	true

   Parts: 1 row, setting Active, POItemType, PartDescription, PartNumber, PartType, UOM.
10. 10
    Committed the import
    committed
11. 11
    Prepared the order (preview) · admin

    Show the file it prepared purchase_order.json

    Exactly what you saw and approved before anything was written.

    {
      "items": [
        {
          "uom": "lbs",
          "part": "DARK-COCOA",
          "price": 1,
          "quantity": 100
        }
      ],
      "vendor": "Brent's Food Supply",
      "carrier": "Will Call",
      "ship_to": {
        "zip": "00000",
        "city": "none",
        "name": "Default Address",
        "state": "UT",
        "address": "Main Street"
      },
      "remit_to": {
        "zip": "84111",
        "city": "Salt Lake City",
        "name": "Brent's Food Supply",
        "state": "UT",
        "address": "777 South Delivery Lane"
      },
      "location_group": "Main"
    }

    Purchase order to Brent's Food Supply, 1 line(s), total 100.00, status Bid Request.
12. 12
    Committed the order
    order 232 created