Administrator guide
For the person who installs, configures, and supports the product.
Requirements
| Component | Requirement |
|---|---|
| Fishbowl | 2026.6 |
| Plugin | ILC CloudPages plugin |
| Nightly part cost capture | Enabled, 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).
- 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 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.
| Operation | Against | Right checked |
|---|---|---|
| Query | partcosthistory, inventorylog, part, uom | None |
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.
| Value | Fixed at | Effect |
|---|---|---|
| Row limit | 5000 parts | A period with more parts than this reports the first 5000, ordered by variance and then by size of value change |
| Rows per page | 50 | The table pages at 50 rows |
| Row density | Small | The table opens with dense rows. A user changes this with the S M L control, and the choice is remembered in that browser |
| Opening period | Last Month | The page opens on last month. A user changes the period before running |
| Capture-close rule | 12 hours | A capture taken before noon closes the previous business day. A capture taken after noon closes its own day |
| Excluded movement type | yld | Yield 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:
| Placement | Default |
|---|---|
| Path | Reports:ILC Products |
| Modules | None |
| Toolbar button | None |
Troubleshooting
The report is empty for a period that definitely had activity
- Symptom: The page runs, and no rows appear.
- Cause: The nightly capture wrote no row that closes a day in the period. The capture was disabled, or the period is earlier than the oldest capture.
- Fix: Enable the nightly capture. A period before the oldest capture cannot be reported, and no setting changes that.
The two capture timestamps are not the dates that were asked for
- Symptom: The bridge states a capture timestamp from a different day.
- Cause: No capture closes the requested day, so the page stepped back to the last capture before it.
- Fix: None. This is correct behavior. The page reports a real capture rather than an estimate, and it states which one it used.
The badge reads "Quantity is out by"
- Symptom: The quantity column does not close.
- Cause: Movement exists that the report cannot account for. A part with a variance is sorted to the top of the table.
- Fix: Read the Variance column from the first row. Report the part numbers and the period in a support request. This is a finding, not a page fault.
A large revaluation figure
- Symptom: The Revaluation badge shows a large amount.
- Cause: Average cost changed under stock that was already held. Fishbowl records no transaction for that.
- Fix: None. This is expected, and it is the reason the report states the figure separately.
The report takes several seconds
- Symptom: The table appears a few seconds after Run.
- Cause: The query reads the full capture history to find the two anchor captures.
- Fix: None. A four second run against a database with 1.1 million capture rows is normal.
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:
- The Fishbowl version and the page version.
- The period that was requested.
- The two capture timestamps the bridge printed.
- An export of the result.
- The browser console output.