calculate_inventory_value
Calculate total inventory value with filtering by status, category, location, or price range. Get item count, average value, and breakdowns by category, location, or account for consignment business analysis.
Instructions
Calculate total inventory value with comprehensive filtering and grouping. Returns total value, item count, average value, and optional breakdown by category, location, account, inventory type, or status.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | No | Filter by status (available, sold, processing, removed) | |
| category | No | Filter by category ID | |
| account | No | Filter by account ID | |
| location | No | Filter by location ID | |
| inventory_type | No | Filter by inventory type | |
| tag_price_gte | No | Filter items with price >= this value (in cents) | |
| tag_price_lte | No | Filter items with price <= this value (in cents) | |
| date_from | No | Filter items created on or after this date (ISO 8601: YYYY-MM-DD) | |
| date_to | No | Filter items created on or before this date (ISO 8601: YYYY-MM-DD) | |
| batch | No | Filter by batch ID | |
| group_by | No | Group results by field for detailed breakdown |