Blog

Build a Fishbowl Purchasing Dashboard with AI (Open & Late POs, Top Vendors)

Israel LopezOctober 31, 20263 min
The Purchasing Pulse Dashboard, built live in one chat with ILC MCP.

Purchasing lives in the gap between what’s ordered and what’s landed. Fishbowl tracks every PO, but seeing the whole pipeline at once means a report nobody has time to build.

In this video I don’t build a report. I ask ILC MCP for the Purchasing Pulse Dashboard and it builds it live, against a Fishbowl database, writing the queries itself. No Jasper editor, no paid reporting add-on, no ticket to a consultant.

That’s the point of the dual approach: Fishbowl’s built-in reporting is rigid, and anything custom usually means iReport/Jasper or a third-party tool. Here the AI reads the live data through the MCP and lays the numbers out for you.

The Purchasing Pulse Dashboard puts the purchasing questions on one screen:

  • Open POs and their expected dates
  • Late and at-risk POs
  • Top vendors by spend
  • Average lead time by vendor

The demo runs on representative sample data, so nothing here is a real customer’s numbers — but it’s the same build you’d run against your own Fishbowl.

More on building live against Fishbowl this way: How to write 4 reports with AI in Fishbowl.