Inventory aging report

GET /api/v1/inventory/reports/aging

Bucket remaining cost-lot quantities (and dollars) by lot age (0-30 / 31-60 / 61-90 / 91-180 / 180+ days). Optionally returns the per-variant detail with the oldest received_at.

Operation ID: get_aging_api_v1_inventory_reports_aging_get · View as markdown · OpenAPI slice

Authentication

Bearer token authentication. Pass your DayZero API token in the Authorization header and the target business UUID in x-business-id.

Parameters

Query

detail boolean default: False

Include per-variant breakdown sorted by oldest lot age.

detail_limit integer default: 100

Cap on per-variant detail rows when detail=true.

Responses

200 Successful Response

total_value_cents integer
total_on_hand_units number
buckets array · AgingBucket AgingBucket
4 fields
bucket string required

Aging band: 0-30 / 31-60 / 61-90 / 91-180 / 180+.

on_hand_units number required
total_value_cents integer required
lot_count integer required
variants array · AgingVariantRow AgingVariantRow
8 fields
variant_id string required
variant_name string
sku string
product_name string
oldest_received_at string · date-time
days_oldest integer
on_hand_units number required
total_value_cents integer required

401 Unauthorized - Authentication required

403 Forbidden - Insufficient permissions

422 Validation Error

detail array · ValidationError ValidationError
5 fields
loc array · string | integer required
msg string required
type string required
input object
ctx object