Israel Lopez Consulting
News

Fishbowl 2026.5: Transfer Order API, secure REST calls from BI reports, and the QBO price-mismatch fix

Israel LopezMay 20, 2026

Fishbowl shipped version 2026.5 (26.5), the biggest release of the year so far, with roughly a dozen features and over two dozen fixes. The theme for anyone building on Fishbowl: the REST API keeps absorbing what used to require the legacy socket API. Our read is that Fishbowl is positioning to eventually retire that legacy socket XML/JSON API, and we think that’s the right call. REST is easier to test, easier to secure, and far more approachable for the average dev team. We just wish the coverage were already complete.

What’s new

  • REST API Transfer Order operations. Retrieve a Transfer Order, search with pagination, and full memo CRUD, with access rights and location-group restrictions enforced. Combined with 26.3’s shipments and 26.4’s tracking data, the REST API now covers most of the warehouse-movement surface.
  • REST API Get Pick. GET /api/picks/:id returns the full Pick object with calculated fields matching the client, including source tag information.
  • apiFetchAsync for BI reports. Report authors can now call REST API endpoints from inside a BI report, running under the viewing user’s session so the server enforces their access rights automatically. This replaces the old pattern of calling the legacy socket API from reports, which bypassed access rights and field validation entirely. If you have reports built on socket calls, this is the sanctioned migration path, and worth taking.
  • BI drill-downs into Picks and Receipts. openModule("Picking", pickNum) and a compact receipt format ("S122", "P234", "T456") open the matching record straight from a report.
  • Intuit Enterprise Suite (IES) integration. A dedicated IES button in the Accounting module, using the same authorization flow and sync logic as QuickBooks Online. From the Fishbowl side it’s essentially QBO with a different badge, and that matches what we hear from people evaluating IES: mostly the same product at a different service tier. If you’re multi-entity, IES is genuinely up your alley; if standard QBO is working for you, this doesn’t change your math.
  • Two new Accounting module options: always use the customer’s default email on invoice exports (regardless of which contact ordered), and a QuickBooks Desktop Canadian tax-rounding toggle, so shops whose orders originate in an e-commerce system can make totals match across all three systems.
  • Faster client on slow networks. The client now checks whether server-side updates exist before fetching them, cutting round-trips on every interaction.
  • Email Report API accepts custom subject and body, so integrators sending reports can finally make the email presentable.

Fixes worth noting

The headline fix: QuickBooks Online’s “Amount is not equal to UnitPrice * Qty” export error is resolved. When associated pricing changed after a Sales Order was issued, the export recalculated a price that no longer matched the line, and QBO rejected it. The export now uses the price stored on the line item. We’ve been called in on this exact error more than once, and it usually meant digging through what Fishbowl’s export logic produced versus what QuickBooks actually received. Under the hood there’s a new priceLocked column on soitem, backfilled on upgrade so already-issued orders keep exporting. That’s a schema change worth noting if you query that table in custom reports, especially around partial shipments.

Also notable:

  • Xero split credit returns export correctly. Credit Return Sales Orders received in multiple batches were failing Xero export with line-total mismatch errors.
  • Backdated receiving now backdates the inventory tag. Receiving with a past Receive Date used to stamp the tag with today’s date, which made FIFO pick the wrong tag for lot-tracked parts. Costing accuracy fix, plain and simple.
  • Products search defaults to Active Only again. A 26.3 regression had it returning inactive products on initial load.
  • Landed cost corrections replace instead of accumulate, ending the “Please balance your debits and credits” export error after fixing a mistyped amount.
  • A long list of report fixes: Sales Order Summary filters (product tree, carrier, single-day fulfilled), Reverse Lot History on old upgraded databases, Packing Slip date fields, barcode centering, and more.

If the report-to-REST migration or the QBO export fix touches your setup, get in touch.