Fishbowl ERP

July 20, 2026

Summary

Fishbowl is a pre-built ERP/accounting integration in Flxpoint. It connects to your Fishbowl server through an approved Flxpoint app and a dedicated API user. Flxpoint supports four Fishbowl operations: the accounting operations Send Accounting Orders (creating one or more Fishbowl Purchase Orders per Flxpoint order) and Send Accounting Shipments (recording shipment confirmations and tracking against those orders), plus the source operations Get Inventory & Products and Get Shipments, which are covered in Fishbowl as a Source. The Orders operation uses a mapping template for vendor, line items, cost, and custom aggregate fields; contact support@flxpoint.com for extended setup guidance.

What this integration does

Send Accounting Orders

Creates one or more Fishbowl Purchase Orders per Flxpoint order.

Send Accounting Shipments

Sends shipment confirmations and tracking for orders already sent.

Fishbowl supports four operations in Flxpoint. Two are accounting operations, configured under Accounting and documented on this page: Send Accounting Orders and Send Accounting Shipments. Two are source operations, configured on a Source: Get Inventory & Products (GIP) and Get Shipments. For the source side, see Fishbowl as a Source.

How to connect - credentials you need

Fishbowl connects through an approved Flxpoint app on your Fishbowl server with a dedicated API user. Before connecting, approve the Flxpoint app in Fishbowl under Setup → Settings → Integrated Apps. Add a Fishbowl connection, enter the values below, then Test Connection → Save Connection.

Connection NameRequired

A friendly label for this connection (for example Fishbowl ERP).

API URLRequired

The URL to your Fishbowl API server.

Server PortRequired

The port your Fishbowl API listens on.

App NameRequired

Must match the app name used to approve the Flxpoint app in Fishbowl.

App IDRequired

Must match the App ID used to approve the Flxpoint app in Fishbowl.

User NameRequired

Your dedicated Fishbowl API user (case-sensitive).

PasswordRequired

The password for the dedicated API user (case-sensitive).

Before connecting, prepare a dedicated Fishbowl API user and group with Customer, Product, Data, Purchase Order, Sales Order, and Vendor permissions, and approve the Flxpoint app under Setup → Settings → Integrated Apps. App Name and App ID must match what was used to approve the app. For extended operation setup and field mapping guidance, contact support@flxpoint.com.

Important - read before configuring

Approve the Flxpoint app first

A 401 error on Test Connection usually means the Flxpoint app is not approved in Fishbowl. Approve it under Integrated Apps and confirm App Name and App ID match what you entered in Flxpoint.

Send Accounting Shipments has no template

The Shipments operation does not use its own mapping template. It relies on shipments created in Flxpoint (with tracking and quantities) and the order data previously sent via Send Accounting Orders. You choose what sends by selecting Channels and Sources.

Vendors and items must exist in Fishbowl

The mapped vendor must match an existing Fishbowl vendor and the mapped SKU must exist as an active Fishbowl item, or the PO will not be created.

Operations - fields to know

Send Accounting OrdersSend Accounting Shipments

Flxpoint Field	Maps To (Fishbowl PO) — Notes
Source / Supplier	→ Vendor. Required. Must match an existing Fishbowl vendor.
Order Date	→ Order Date. Required.
Master SKU / Vendor SKU	→ Item Number. Required. Must match an active Fishbowl item.
Quantity	→ Qty Ordered. Required.
Cost	→ Unit Cost. Required.
Order ID / Channel Order Number	→ PO Number / Customer PO. Optional reference.
Custom aggregate fields	→ PO custom summary fields. Optional name/value pairs (e.g. Channel, Order Total) added without a per-row field.

Field mapping for this operation is configured with Flxpoint Support.

Common issues

401 error: the integrated application has not been approved

Approve the Flxpoint application in Fishbowl's Integrated Apps screen and confirm the App Name/App ID match the connection, then re-test.

No Purchase Order created

Confirm the operation is scheduled or run manually and that the selected channels have orders in the correct status for accounting.

Vendor or item not found

Make sure the mapped vendor matches an existing Fishbowl vendor and the mapped SKU exists and is active in Fishbowl.

FAQs

How many Purchase Orders does one order create?▸

One or more per Flxpoint order, typically one per supplier, based on the mapping template.

Do I need to send orders before shipments?▸

Yes. Send Accounting Shipments only records shipments for orders already sent via Send Accounting Orders, and the same channels should be selected for both.

Can multiple channels use one Fishbowl connection?▸

Yes, if they share the same accounting setup.

Which operations does Fishbowl support?▸

Four. On the accounting side, Send Accounting Orders and Send Accounting Shipments, both covered on this page. On the source side, Get Inventory & Products (GIP) and Get Shipments, covered in Fishbowl as a Source. All four use the same Fishbowl connection details (approved Flxpoint app plus a dedicated API user).

Back to ERP & Accounting Integrations