Administrator guide

For the person who installs, configures, and supports Base Reports.

Requirements

ComponentRequirement
FishbowlAny version. Tested on 2026.10.
PluginILC CloudPages plugin
NetworkThe 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.

  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 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:

ReportCost shown
Sales MarginsLine cost and margin
Inventory ValuationAverage unit cost and extended value
Cost LayersUnit cost and remaining value
Part Cost HistoryAverage and standard cost
Inventory HistoryUnit cost and cost of each change
Inventory AdjustmentsPosted cost of each adjustment
Work Order CostMaterial, 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.

OperationAgainstRight checked
Query, one for each report runThe tables of that reportNone. Page access only.
Query, parameter listscustomer, vendor, locationgroup, and status and type tablesNone. Page access only.
Query, custom field definitionscustomfield, tablereference, customlistitemNone. 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.

PlacementDefault
PathReports:Sales, Reports:Inventory, Reports:Purchasing, Reports:Manufacturing or Reports:Operations
ModulesNone
Toolbar buttonNone

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:

Troubleshooting

The report shows only Run and Export, with no parameters

Inventory History or Dormant Customers does not run

A report shows "No data available"

Work Order Cost shows no cost for a work order

The Description column in Available Pages is empty

Before a support request

Collect: