Administrator guide
For the person who installs, configures, and supports Base Reports.
Requirements
| Component | Requirement |
|---|---|
| Fishbowl | Any version. Tested on 2026.10. |
| Plugin | ILC CloudPages plugin |
| Network | The Fishbowl client reaches cdn.ilcreports.com |
Each report loads the report engine from cdn.ilcreports.com when it opens.
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 Open Sales Orders and click Run. The report reads data and 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 reports read no Fishbowl access right. Page access is the only control. An administrator grants each report to each user group in CloudPages.
Who to grant access to. A user who can open a report reads everything that report reads, for every customer, vendor and location group. Grant each report to the groups whose work it covers.
These reports show cost. Grant them only to users who may see cost:
| Report | Cost shown |
|---|---|
| Sales Margins | Line cost and margin |
| Inventory Valuation | Average unit cost and extended value |
| Cost Layers | Unit cost and remaining value |
| Part Cost History | Average and standard cost |
| Inventory History | Unit cost and cost of each change |
| Inventory Adjustments | Posted cost of each adjustment |
| Work Order Cost | Material, labor and total cost |
The purchasing reports show what was paid to each vendor.
User Access Rights lists every user, the user groups, and the rights each group grants. User Login Log lists every login. Grant both to administrators only.
Data handling
The reports read with SQL through the CloudPages plugin. They make no Fishbowl API call, and they write nothing to Fishbowl.
| Operation | Against | Right checked |
|---|---|---|
| Query, one for each report run | The tables of that report | None. Page access only. |
| Query, parameter lists | customer, vendor, locationgroup, and status and type tables | None. Page access only. |
| Query, custom field definitions | customfield, tablereference, customlistitem | None. Page access only. |
The definitions query runs only when a user opens Edit custom fields. A report reads a custom field only when a user picks it.
A user can export the loaded rows to XLSX, CSV or Markdown. The save dialog writes the file to the user's computer. Nothing else leaves the Fishbowl client.
Settings
The reports have no settings.
| Placement | Default |
|---|---|
| Path | Reports:Sales, Reports:Inventory, Reports:Purchasing, Reports:Manufacturing or Reports:Operations |
| Modules | None |
| Toolbar button | None |
Change where a report appears in the CloudPages plugin page Edit dialog.
Each report opens at the small table size. A user changes the size with the S, M and L buttons.
These values are fixed and not configurable:
- A table of 100 rows or more shows 50 rows on each page.
- The Help button opens the ILCReports help page for Base Reports.
Troubleshooting
The report shows only Run and Export, with no parameters
- Symptom: The heading shows, but no parameters and no table.
- Cause: The report engine did not load from
cdn.ilcreports.com. - Fix: Make sure that the client can reach
cdn.ilcreports.com. Then click Refresh in the report window.
Inventory History or Dormant Customers does not run
- Symptom: Run does nothing, or the report asks for a date.
- Cause: These reports need a date before they run.
- Fix: Enter the date range, or the "No orders since" date.
A report shows "No data available"
- Symptom: The table is empty.
- Cause: Nothing matches the parameters, or Fishbowl holds no data for the report. Reorder Report and Reorder Points need reorder points. Transfer Orders needs transfer orders.
- Fix: Clear the parameters and run the report again. If the table stays empty, the data does not exist in Fishbowl.
Work Order Cost shows no cost for a work order
- Symptom: The cost columns are 0 on an open work order.
- Cause: Fishbowl posts work order cost when the work order is finished.
- Fix: None. The cost shows after the work order is finished.
The Description column in Available Pages is empty
- Symptom: The reports show a title and a location, but no description.
- Cause: This CloudPages plugin version does not read page descriptions from a folder or a git source.
- Fix: Update the CloudPages plugin.
Before a support request
Collect:
- The Fishbowl version and the commit of
ILC.BaseReports.Pages. - The report name and the parameters. The first sheet of an XLSX export lists the parameters.
- The browser console output.
- A screenshot of the report.