Every degree matters. Every alert accounted for.

Each freezer-type storage location in NovexERP has a configurable temp_alert_threshold, defaulting to 32°F. When a logged temperature reading exceeds the threshold, an alert is automatically generated. Alert listings support filtering by threshold value, unacknowledged-only mode, storage location, and pagination with up to 200 results per page.

The acknowledgment workflow requires a user_id, a timestamp that defaults to now, and optional notes capped at 500 characters. A unique constraint enforces one-time acknowledgment per alert -- once acknowledged, the alert no longer appears in the unacknowledged list. This creates an auditable record that proves a specific person reviewed a specific temperature excursion at a specific time.

Each alert response includes lots_at_risk -- a list of raw material lots and finished product lots currently stored in the affected freezer. Each entry shows the lot code, quantity, unit, and expiration date, giving the responder immediate visibility into what inventory may be compromised. Unacknowledged alerts are surfaced on the main dashboard for immediate visibility, ensuring nothing goes unaddressed. For temperature logging, see Compliance Logs. For inventory details, see Inventory.