The Usage Trend Report shows monthly usage by part across the report's month range, with expandable per-part usage summaries.
What this report is for
Use Usage Trend Report to review monthly usage patterns by active inventory part.
This report is useful for planning, reorder review, work order planning, and spotting changes in demand.
Screen path
Dashboard > Inventory > Reports > Usage Trend Report
Filters and actions
| Control | What it does |
|---|---|
| Search | Filters by part number or description. |
Current partial month |
Includes the current partial month in the report range. |
A-Z |
Sorts by part number ascending. |
Z-A |
Sorts by part number descending. |
Total |
Sorts by total usage descending. |
Copy for Excel |
Copies filtered report rows to the clipboard. |
Report columns
| Column | What it shows |
|---|---|
Part Number |
Inventory part number. |
Description |
Inventory description. |
UOM |
Stocking unit of measure. |
| Month columns | Usage quantity for each month in the report range. |
Total |
Total usage across the displayed months. |
The footer totals usage by month and grand total for the filtered rows.
Expanded part detail
Select a part row to expand it.
The expanded view shows:
- Average per month.
- Total usage.
- Highest usage month.
- Lowest usage month.
- A small usage bar chart across the displayed months.
Select the row again to collapse it.
What happens behind the scenes
PAX reads active inventory items and inventory usage history.
By default, the report uses completed months. Selecting Current partial month includes the current month and marks it as partial.
Running, expanding, filtering, sorting, or copying the report does not update usage history, inventory, reorder settings, work orders, or purchase orders.
Troubleshooting
Usage is zero for a part
Likely cause: No usage history exists for the displayed months, or usage has not been recorded for that part.
Safe fix: Review the date range shown in the report footer and the part's usage history source.
Contact support if: Known usage should appear but does not.
Current month looks low
Likely cause: Current partial month includes only usage recorded so far in the current month.
Safe fix: Compare current partial month to completed months carefully.
Contact support if: Completed month usage appears wrong.