User guide

For the person who runs the report. The book control in the page header shows this file.

What it shows

The report answers one question about a period: does the inventory you started with, plus everything that moved, equal the inventory you ended with? It shows the company figures at the top and one row per part below them. The quantity side balances. The value side ends on a revaluation figure, which is the part of the change in value that no transaction explains.

Parameters

ParameterWhat it doesDefault
PeriodSets the period to report. The page picks the nightly capture that closes the day before the period starts, and the capture that closes the last day of the period.Last Month

The page opens on Last Month, which is the usual period at a close. To report a different one, choose another entry in the preset list or type the two dates. Typing a date switches the preset to Custom.

Columns

The table opens with ten columns: the bridge itself. Every other column is one click away under Columns, and an export always holds all of them.

ColumnShownWhat it meansSource
Part, Description, UOMyesThe partpart, uom
Opening qty (captured)noWhat the opening capture recordedpartcosthistory
Opening restated bynoMovement dated on or before the opening capture, but entered after it raninventorylog
Opening qtyyesCaptured plus restated. This is the figure the bridge starts fromboth
Opening valueyesThe value the opening capture recordedpartcosthistory
Received, Shipped, Consumed, Transferred, Adjusted, OthernoThe same movement, split by kindinventorylog
AddedyesEverything that increased stock in the periodinventorylog
RemovedyesEverything that decreased it, shown negativeinventorylog
Net movementnoAdded plus Removedinventorylog
Closing qty (captured)noWhat the closing capture recordedpartcosthistory
Closing restated bynoMovement dated on or before the closing capture, but entered after it raninventorylog
Closing qtyyesCaptured plus restated. This is the figure the bridge ends onboth
Closing valueyesThe value the closing capture recordedpartcosthistory
VarianceyesClosing qty less opening qty less movement. Normally zerocalculated
Value movednoThe cost of the period's movementinventorylog
RevaluationyesThe change in value that the movement does not explaincalculated

The capture timestamps and the excluded yield movement are also there, under Columns.

A description never wraps. A long one is cut short with an ellipsis so that one row stays one line. Search still matches the whole description.

The rows are dense by default. Use the S M L control in the page header to make them larger.

How the numbers work

Both ends are a real capture. Fishbowl captures part quantity and value every night. The page never estimates a figure between two captures. It uses the capture that closes the day you asked for, and it prints both capture timestamps at the top right of the bridge. If your site has a night with no capture, the page steps back to the last one before it, and the printed timestamp tells you that happened.

The capture time decides which day a capture closes. A capture that runs at 01:00 closes the previous business day. A capture that runs at 22:00 closes its own day. The page works this out from the timestamp, so a period is correct even if your capture time changed part way through the history.

Added and Removed are split by the sign of each record, not by its kind. A kind of record is not a direction. An adjustment goes both ways, and so does a transfer. The page adds up the records that increased stock and the records that decreased it, which stays correct when Fishbowl adds a record type.

A net figure hides the size of a period. In one month at one site, 159,551 units came in and 154,135 went out to leave a net of 5,416. The two columns show the month; the net alone does not. Turn on Net movement under Columns if you want the single figure as well.

Yield movement is excluded. Fishbowl writes a yld record that mirrors pick and ship movement. Counting it books the same stock twice. The page excludes every yld record and reports the total it excluded, so you can see the size of what was left out. Turn on the Yield mirror (excluded) column to see it per part.

Late entry restates both ends, on quantity only. A capture is a photograph. Movement entered after the photograph is legitimately missing from it, even when the movement is dated inside the period. The page adds that movement back to the capture it missed, and shows the amount it added in the two "restated by" columns. A large figure there means your keying is running behind.

The page does not restate value the same way. A capture's value was calculated at the average cost of that night. Adding a later transaction's cost into it would mix two different cost bases and give a number that agrees with neither. Value is reported exactly as captured.

Revaluation is the value the movement cannot explain. When average cost changes, Fishbowl revalues stock that is already on the shelf. No transaction records that, so it cannot be rebuilt from the movement. The page reports it as one figure instead of hiding it inside another column.

Reading the result

A normal result shows Quantity closes in green, and every part has a Variance of zero. Opening qty plus Added plus Removed equals Closing qty, on every row.

If the badge reads Quantity is out by a figure, the parts responsible are sorted to the top of the table. Read the Variance column down from the first row.

An empty result means there is no capture in the period you chose. Check that the period is not earlier than your oldest capture, and that the nightly capture was running.

A large Revaluation figure is not an error. It means cost moved under stock you already held. Compare it with the Value moved column to see how much of the change in value came from movement and how much did not.

To export, click Export. The file holds every column, including the hidden ones, and a final COMPANY TOTAL row with the same figures as the bridge at the top of the page.