Administrator guide

For the person who installs, configures, and supports the product.

Requirements

ComponentRequirement
Fishbowl2026.10 or later
PluginILC CloudPages plugin

The page reads with SQL and writes through the Fishbowl API. It needs no other server component.

Installation

Installation is the same for every ILC catalog page. For the full steps, see https://ilcreports.com/how-to#install.

  1. Buy the page on ilcreports.com.
  2. Install the CloudPages plugin in Fishbowl.
  3. Configure CloudPages with the manifest URL from the purchase.
  4. Confirm that the purchased pages appear in the installation.
  5. Grant page access to the users who need it.

Verify. Open a saved sales order. Click QuickOrder in its toolbar. Click ? to run the guided tour. The tour changes nothing in Fishbowl.

To configure the page, see Settings.

Updates

Updates are the same for every ILC catalog page.

A customer gets the latest stable version of a page by default. To stay on a previous version, or to return to one, choose the version in the ilcreports.com portal.

Fishbowl keeps its own data through an update. The plugin data in Fishbowl holds the access rights, the module placement, and the page settings. This data also survives a page removal.

For what changed in each version, see the release notes.

Security

The page reads no Fishbowl access right. A user who can open the page can add lines to the open sales order.

The Settings dialog opens for two kinds of user:

UserHow the page knows
The Fishbowl user named adminThe user name, from the user table
A member of the user group QuickOrder AdminGroup membership, from the user group tables

To let somebody change the settings without the admin account, create a user group named QuickOrder Admin and add that person to it. Any other user who clicks the gear reads "Settings are open to an administrator only."

This check hides a control. It does not enforce access. It is a query the page runs, not a Fishbowl access right.

Who to grant access to. A user who can open the page can read the open order's customer and everything that customer has bought before, with the last price paid for each product. A query through the bridge is not right-checked. Grant page access to the people who take orders: counter staff and inside sales.

Considerations

The Avg. cost and Margin columns show your cost. They are off until an administrator turns them on, and when they are on, every user of the page sees them. Leave them off if the people who take orders do not see cost elsewhere.

The page adds lines to a sales order. It never changes or deletes a line that is already on the order.

Every added line takes the sales order's own tax code and class, not the product's defaults. Its price is the one the page shows, written on the line explicitly.

Data handling

Every query and API call the page makes:

OperationAgainstRight checked
Queryso, customer, taxrate, qbclass: the order number, customer, tax code, and classNone
Queryso, soitem, product, part, customer, customerparts, uom, uomconversion, qtyinventorytotals, partcost, vendorparts, taxrate: the customer's order historyNone
Querysysuser, usergroup, usergrouprel: whether the user is an administratorNone
Querypricingrule, accountgrouprelation, sysproperties: the pricing rules, when Pricing is Pricing ruleNone
API AddSOItemRqOne call for each item with a quantityNone
Plugin data readQuickOrderPage, for the settingsNone
Plugin data writeQuickOrderPage, from the Settings dialogAdministrator check above

What leaves the Fishbowl client. Nothing. The page saves no file, and it sends nothing to ILC.

Settings

An administrator sets these in the Settings dialog, the gear. A change saves at once, and it applies to every user of the page. The page works before anybody changes a setting.

SettingDefaultWhat changes
PricingProduct priceWhere each item's price comes from. Product price is the product's own price. Last customer price is what this customer paid last time. Pricing rule applies your pricing rules for this customer and quantity.
Order itemsAll itemsOrdered in the last and a number of days hides items the customer has not ordered in that time. The number starts at 30.
Row heightMediumSmall, Medium, or Large.
ColumnsAll offAdds Last qty, Last date, QOH, Avg. cost, and Margin to the grid.

Pricing rule applies the rules that are active and set to apply automatically, for this customer and its account groups. The price changes as a user types a quantity that crosses a rule's minimum. A rule that is not set to apply automatically is not used.

The theme control in the page header switches light and dark for the user who clicks it. The page otherwise follows the theme of the Fishbowl client.

A badge in the page header reads Demo when the page reaches no Fishbowl. Connected to Fishbowl, the page shows no badge, because that is the normal state.

These values are fixed and no one can change them:

LimitValue
HistoryEvery product on this customer's sales orders, except estimates and voided orders.
Last priceThe unit price on the customer's most recent line for that product.
Excluded productsA product on a voided order whose custom field Exclusion SO is true drops out of the history.
QOHOn hand less allocated, in the order's location group, in the product's unit of measure.
Items addedRows with a quantity of 1 or more.
After an addThe window closes, and the sales order reloads.
Window1100 by 725 pixels

Change where the page appears in the CloudPages plugin page Edit dialog:

PlacementDefault
PathApps:ILC Products
ModulesSales Order
Toolbar buttonQuickOrder

Troubleshooting

The page says to open a sales order first

The list is empty

A product the customer bought is missing

A price is 0.00

The last price looks wrong

A user cannot open the gear

An add stopped partway

An item is missing from the order after Add to order

Before a support request

Collect: