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

> A real Claude session on a Fishbowl database (ILC's demo company, sample data), connected through ILC MCP for Fishbowl. The answer below is what the AI said; the queries are what it ran. Page: https://israellopezconsulting.com/fishbowl-mcp/questions/receiving

## Question

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

### Answer

There are 30 part/location lines sitting in Receiving across three warehouses, and none of it is recent: the newest has been there 34 days and everything else 80 to 85 days.

**Main (24 lines)**

| Part | Description | Qty | UOM | Days |
|---|---|---|---|---|
| B200 | Cocoa Powder | 1,226 | oz | 85 |
| B201 | All Purpose Flour | 100 | lbs | 85 |
| B203 | Chocolate Syrup | 235 | oz | 85 |
| BP204 | White egg | 384 | ea | 85 |
| CR403 | Chocolate Chips | 69 | lbs | 85 |
| P702 | Cranberry Juice | 23 | floz | 85 |
| B202 | Baking Soda | 730 | oz | 84 |
| B204 | Salt | 1,200 | oz | 84 |
| BB2005 | Chocolate Chip | 2,100 | ea | 84 |
| BD302 | Vanilla Extract | 151.961 | oz | 84 |
| C501 | Oats | 54 | lbs | 84 |
| C502 | Brown Sugar | 78 | lbs | 84 |
| CR402 | Ground Cinnamon | 80 | oz | 84 |
| F102 | Cream of Tartar, Brand Z | 46 | oz | 84 |
| H901 | Coconut Shavings | 25 | lbs | 84 |
| H902 | Chopped Walnuts | 25 | lbs | 84 |
| H903 | Sliced Almonds | 400 | oz | 84 |
| H904 | Chopped Peanuts | 400 | oz | 84 |
| V101 | Vegetable Oil | 558 | oz | 84 |
| BB2002 | Chocolate Fudge | 2 | ea | 80 |
| BB2003 | Oatmeal Chocolate Chip | 2 | ea | 80 |
| BB2004 | Snickerdoodle | 22 | ea | 80 |
| FG2200 | Sugar Cookie | 12 | ea | 80 |
| MB2200 | Sugar Cookie Dough | 100 | lbs | 34 |

**SLC (4 lines)**

| Part | Description | Qty | UOM | Days |
|---|---|---|---|---|
| B200 | Cocoa Powder | 1 | oz | 80 |
| B202 | Baking Soda | 1 | oz | 80 |
| B204 | Salt | 1 | oz | 80 |
| FG2200 | Sugar Cookie | 1 | ea | 80 |

**LA (2 lines)**

| Part | Description | Qty | UOM | Days |
|---|---|---|---|---|
| BB2003 | Oatmeal Chocolate Chip | 1 | ea | 80 |
| FG2200 | Sugar Cookie | 2 | ea | 80 |

MI has nothing in Receiving.

- **How days are counted:** from when the oldest inventory tag for that part in that location was created, so a part topped up since then still shows its oldest date.
- **Still on hand:** all of this counts toward on-hand quantity even though it hasn't been put away.
- **Perishables:** the 384 eggs (BP204) at 85 days and the 100 lbs of cookie dough (MB2200) at 34 days are the lines I'd check first.

## Behind the scenes

Every step the AI took, as recorded in the query log. All queries are read-only and row-capped.

1. Checked the saved queries — 6 saved queries
2. Read the Fishbowl notes index — 13 topic notes
3. Ran saved query `receiving_not_put_away`: What's sitting in Receiving that hasn't been put away? — 30 rows, 194 ms

   ```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
   ```

Learn more: https://israellopezconsulting.com/fishbowl-mcp · More examples: https://israellopezconsulting.com/fishbowl-mcp/questions