Administrator guide

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

Requirements

ComponentRequirement
Fishbowl2026.6
PluginILC CloudPages plugin
Nightly part cost captureEnabled, and running across every period to report

The nightly capture writes the partcosthistory table. The report reads its opening and closing figures from that table. If the capture is disabled, the report has no data to anchor on.

Installation

Installation is the same for every ILC catalog page. For the full steps, see TBD (public documentation URL).

  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 the page. Set Period to a month that is already closed, then click Run. The bridge appears above the table, and it states the two capture timestamps it used. The page 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. It checks no right, and it changes its behavior for no right. Page access is the only control.

Who to grant access to. A user who can open the page reads company-wide inventory quantity and inventory value, for every part, for any period that the nightly capture covers. Grant access to the people who close periods and to the people who audit them. The page suits a controller, an accountant, and an inventory manager. It does not suit a user who must not see company valuation.

Considerations

The report is company-wide by design. It cannot restrict a reader to one location group, because the source table records no location.

The page reads history. A user with access reads every period the capture covers, not only the current one.

Data handling

The page runs one query for each run. It makes no Fishbowl API call, and it writes nothing.

OperationAgainstRight checked
Querypartcosthistory, inventorylog, part, uomNone

The query binds the period with named parameters. It joins no user input into the statement.

Nothing leaves the Fishbowl client unless a user exports. An export holds every column, including the two hidden ones, plus one company total row. That file holds part numbers, quantities, and inventory values.

Settings

The page has no configurable setting. The values below are fixed in the page and an administrator cannot change them.

ValueFixed atEffect
Row limit5000 partsA period with more parts than this reports the first 5000, ordered by variance and then by size of value change
Rows per page50The table pages at 50 rows
Row densitySmallThe table opens with dense rows. A user changes this with the S M L control, and the choice is remembered in that browser
Opening periodLast MonthThe page opens on last month. A user changes the period before running
Capture-close rule12 hoursA capture taken before noon closes the previous business day. A capture taken after noon closes its own day
Excluded movement typeyldYield records mirror pick and ship movement, so the report excludes them and reports the excluded total

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

PlacementDefault
PathReports:ILC Products
ModulesNone
Toolbar buttonNone

Troubleshooting

The report is empty for a period that definitely had activity

The two capture timestamps are not the dates that were asked for

The badge reads "Quantity is out by"

A large revaluation figure

The report takes several seconds

Before a support request

The page has no debug button. Turn on the two hidden columns with Columns before you collect anything: Opening capture and Closing capture name the exact snapshots the run used, and Yield mirror (excluded) shows what the report left out.

Collect: