Administrator guide
For the person who installs, configures, and supports the product.
Requirements
| Component | Requirement |
|---|---|
| Fishbowl | 2026.10 or later |
| Plugin | ILC 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.
- Buy the page on ilcreports.com.
- Install the CloudPages plugin in Fishbowl.
- Configure CloudPages with the manifest URL from the purchase.
- Confirm that the purchased pages appear in the installation.
- 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:
| User | How the page knows |
|---|---|
| The Fishbowl user named admin | The user name, from the user table |
| A member of the user group QuickOrder Admin | Group 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:
| Operation | Against | Right checked |
|---|---|---|
| Query | so, customer, taxrate, qbclass: the order number, customer, tax code, and class | None |
| Query | so, soitem, product, part, customer, customerparts, uom, uomconversion, qtyinventorytotals, partcost, vendorparts, taxrate: the customer's order history | None |
| Query | sysuser, usergroup, usergrouprel: whether the user is an administrator | None |
| Query | pricingrule, accountgrouprelation, sysproperties: the pricing rules, when Pricing is Pricing rule | None |
API AddSOItemRq | One call for each item with a quantity | None |
| Plugin data read | QuickOrderPage, for the settings | None |
| Plugin data write | QuickOrderPage, from the Settings dialog | Administrator 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.
| Setting | Default | What changes |
|---|---|---|
| Pricing | Product price | Where 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 items | All items | Ordered in the last and a number of days hides items the customer has not ordered in that time. The number starts at 30. |
| Row height | Medium | Small, Medium, or Large. |
| Columns | All off | Adds 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:
| Limit | Value |
|---|---|
| History | Every product on this customer's sales orders, except estimates and voided orders. |
| Last price | The unit price on the customer's most recent line for that product. |
| Excluded products | A product on a voided order whose custom field Exclusion SO is true drops out of the history. |
| QOH | On hand less allocated, in the order's location group, in the product's unit of measure. |
| Items added | Rows with a quantity of 1 or more. |
| After an add | The window closes, and the sales order reloads. |
| Window | 1100 by 725 pixels |
Change where the page appears in the CloudPages plugin page Edit dialog:
| Placement | Default |
|---|---|
| Path | Apps:ILC Products |
| Modules | Sales Order |
| Toolbar button | QuickOrder |
Troubleshooting
The page says to open a sales order first
- Symptom: The page shows "Open a sales order first." and no grid.
- Cause: The page opened with no saved sales order behind it. A new order that is not saved yet has no number.
- Fix: Save the order. Then click QuickOrder in the sales order toolbar.
The list is empty
- Symptom: The grid has no rows for a known customer.
- Cause: The customer has no sales order other than estimates and voided orders. Or Order items hides everything older than its number of days.
- Fix: Set Order items to All items. A customer with no orders has nothing to show.
A product the customer bought is missing
- Symptom: One product does not appear in the history.
- Cause: The product was only ever on an estimate or a voided order. Or a voided order marked Exclusion SO excludes it.
- Fix: None, when the order was voided on purpose.
A price is 0.00
- Symptom: An item comes in at 0.00.
- Cause: The pricing source has no price for it. A product with no price, on Product price. A customer that never paid for it, on **Last customer price**.
- Fix: Change Pricing, or set the price on the line after it is added.
The last price looks wrong
- Symptom: A last price is far from the product price.
- Cause: The page shows what is on the customer's most recent line for that product.
- Fix: None in the page. Check that line on its sales order.
A user cannot open the gear
- Symptom: The gear reports "Settings are open to an administrator only."
- Cause: The user is not admin, and is not in the QuickOrder Admin group.
- Fix: Add the user to a user group named QuickOrder Admin.
An add stopped partway
- Symptom: An error shows after Add to order, and the window stays open.
- Cause: Fishbowl refused one item. Items before it were added. Items after it were not.
- Fix: Close the page and check the sales order. Then add the remaining items again.
An item is missing from the order after Add to order
- Symptom: The window closed, and one item is not on the sales order.
- Cause: Fishbowl refused the line. This version of the page does not report every refusal.
- Fix: Add the item on the sales order directly, where Fishbowl shows its reason.
Before a support request
Collect:
- The Fishbowl version and the page version.
- The sales order number and the customer.
- The Pricing and Order items settings.
- The error text, when there is one.
- The browser console output.
- A screenshot of the page.