# Daily available-stock report

## Objective

Ship the daily inventory report with an explicit available-stock calculation
and a reviewable exception list.

## Current state

The query is ready for production review. UTC handling is explicit, the agreed
calculation is preserved, and the reviewer note is resolved.

## Decisions

- Available stock is `on_hand - reserved`.
- Snapshot dates are interpreted in UTC.
- Negative inventory remains visible in an exception list.

## Evidence

- Source table: `prod.inventory.daily_snapshots`
- Reservation semantics: deduct reserved units from on-hand units.
- Validation: compare the exception count with the prior day.

## Next action

Run the query against the production snapshot, compare exception counts with
the prior day, and publish the result as revision 4.

## Owner

Successor reporting agent, reviewed by Operations.