asset_register_report
Fetch a filterable fixed-asset register with totals for cost, depreciation, and net book value. Use filters for status, category, location, year, cost, and responsible user; results are paginated.
Instructions
The complete, filterable fixed-asset register (H09, US-H09.1): one row per asset (number, name, category code/name, status, acquisitionDate, acquisitionCostRappen, accumulatedDeprRappen, netBookValueRappen, residualValueRappen, method, usefulLifeMonths, location, responsible, serial/barcode, lastDepreciationPeriod, disposedAt) with a totals footer (count, sum cost, sum accum, sum NBV) computed over the WHOLE filtered set, not just the returned page. filter carries status[] (default hides archived), categoryIds[], locationIds[], acquisitionYearFrom/To (YYYY), costMinRappen/costMaxRappen, responsibleUserId and a case-insensitive q over number/name/serial/barcode/notes. Optional columns subset (id/number always kept), sort ({ field, dir }) over a whitelisted column, and cursor/limit pagination (default 500, max 5000; follow nextCursor until absent). An empty match is a success ({ rows: [], zero totals, message: "no_assets_matching" }), never an error. Pure read, §H-TENANT.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | ||
| limit | No | ||
| cursor | No | ||
| filter | No | ||
| columns | No | ||
| workspaceId | Yes |