Israel Lopez Consulting
Warehouse · asked in Claude

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

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.

Fishbowl MCP connectedin Claude
What's sitting in Receiving that hasn't been put away?
✓Checked your Fishbowl data · 1 read-only query · 0.2 s

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)

PartDescriptionQtyUOMDays
B200Cocoa Powder1,226oz85
B201All Purpose Flour100lbs85
B203Chocolate Syrup235oz85
BP204White egg384ea85
CR403Chocolate Chips69lbs85
P702Cranberry Juice23floz85
B202Baking Soda730oz84
B204Salt1,200oz84
BB2005Chocolate Chip2,100ea84
BD302Vanilla Extract151.961oz84
C501Oats54lbs84
C502Brown Sugar78lbs84
CR402Ground Cinnamon80oz84
F102Cream of Tartar, Brand Z46oz84
H901Coconut Shavings25lbs84
H902Chopped Walnuts25lbs84
H903Sliced Almonds400oz84
H904Chopped Peanuts400oz84
V101Vegetable Oil558oz84
BB2002Chocolate Fudge2ea80
BB2003Oatmeal Chocolate Chip2ea80
BB2004Snickerdoodle22ea80
FG2200Sugar Cookie12ea80
MB2200Sugar Cookie Dough100lbs34

SLC (4 lines)

PartDescriptionQtyUOMDays
B200Cocoa Powder1oz80
B202Baking Soda1oz80
B204Salt1oz80
FG2200Sugar Cookie1ea80

LA (2 lines)

PartDescriptionQtyUOMDays
BB2003Oatmeal Chocolate Chip1ea80
FG2200Sugar Cookie2ea80

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.
A real 22-second session on our demo Fishbowl, replayed faster.

Behind the scenes

What your admin sees in the query log for this conversation.

1read-only queries
0.2 stotal query time
0changes to your data
0rows stored

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

Every query is checked before it runs: reads only, no system tables or password fields, and a row cap on every result. The question and the SQL are logged for your admins. The data itself is not stored.

More questions

What else your team could ask

“Where are our chocolate chips stored?”

349.5 lbs across four locations in three warehouses.

Watch the answer →

“what were my top product sales, and who bought them?”

Three cookies make up about 77% of your $29,544.54 in product sales, and Allen's Groceries is the main buyer of all three.

Watch the answer →

“What has Allen's Groceries ordered from us, and how often?”

Five orders between July 10 and August 30, netting to $17,638.80, with no regular ordering pattern.

Watch the answer →

See all questions →

Ask this about your own Fishbowl

We'll set up ILC MCP on your Fishbowl and build the queries your team needs.