Running the Inventory Movement report
Generate a summary of inventory activity—inbound, outbound, and transfers—for a period.
The Inventory Movement report summarizes all activity in your warehouses—items received, sold, transferred, or adjusted—during a specific period. Use it to understand volume trends and identify fast-moving or slow-moving items.
Before you start
- You must have permission to view inventory reports.
- Decide on a date range (e.g., last month, last quarter) and which warehouse(s) or item categories to examine.
- Have a clear business question in mind (e.g., "Which items moved the most in Q2?" or "What was received last month?").
Steps
-
Go to Reports → Inventory (or the reports section of your Usystems menu). Open in Usystems
-
Look for Inventory Movement in the list of available reports.
-
Click Inventory Movement to open the report configuration.
-
Set a From Date and To Date to define the period you want to examine.
-
(Optional) Choose a Warehouse to focus on one location, or leave empty to include all warehouses.
-
(Optional) Choose a Product Category or Item to narrow the results. Leave empty to see all items.
-
(Optional) Choose Movement Type: Receipts only, Sales only, Transfers only, or All movements.
-
Click Run Report or Generate to execute the query.
-
The report displays a summary with columns for item name, total quantity received, total quantity sold, total quantity transferred out, and net change.
Tips & common mistakes
- Use monthly or quarterly periods: Reporting on too short a period (e.g., a single day) may not show meaningful patterns. Monthly or longer gives better insights.
- Combine with a Stock Ledger: The Movement report is a summary; if you need transaction-by-transaction details, use the Stock Ledger report instead.
- Watch for transfers: If your organization has multiple warehouses, transfers between them appear in this report. They don't affect company-wide inventory, only distribution.
- Analyze by category: If results are overwhelming, re-run the report filtering by product category to identify which lines of business are driving volume.
Was this helpful?