FAQ: Inventory Movement Report

Q: What's the difference between the Inventory Movement and Stock Ledger reports?

A: The Stock Ledger shows every single transaction (purchase receipts, sales, transfers, adjustments) in chronological order, so you can trace exactly what happened. The Inventory Movement report aggregates all those transactions into a summary by item, showing total received, sold, and transferred in a period. Use Stock Ledger for detailed audits; use Movement for trend analysis and volume insights.

Q: Why does the "Net Change" column sometimes show a negative number?

A: A negative net change means you sold or transferred out more inventory than you received during the period. This is normal if you're drawing down safety stock, selling off older inventory, or redistributing between warehouses. If it happens frequently for critical items, consider adjusting your reorder point or increasing purchase orders.

Q: Can I see which transfers went where?

A: The Inventory Movement report shows that a transfer occurred but not the destination warehouse. For detailed transfer information, use the Stock Ledger report with a filter for Transfer type, or check the Transfer document itself. Open in Usystems

Q: How do I identify dead stock?

A: Run the Inventory Movement report for the last 6 or 12 months, filter by Movement Type = Sales only, and sort by quantity low to high. Items with zero or near-zero sales are candidates for writeoff. Cross-check with a physical count to confirm the items still exist.

Q: Can the report show me which customers bought the most?

A: No, the Inventory Movement report shows only items and quantities, not customer details. To see sales by customer, use a Sales report or Customer Aged Balance report instead. Open in Usystems

Q: Why is my report showing transfers I didn't authorize?

A: Transfers may have been created automatically by a reorder process or by another user on your team. Check the original Transfer document for details about who created it and why. All transfers are logged and can be traced to the user and date of creation.

Q: How can I predict future demand using this report?

A: The Movement report is historical. To forecast, export the last 12 months of data to Excel, calculate the average monthly movement, and account for seasonal spikes (compare the same months year-over-year). Your ERP may also have a dedicated forecasting or reorder-point feature—check with your system administrator.

Q: What if the report is too slow to generate?

A: Large date ranges or unfiltered items can slow the report. Try narrowing the date range to a single month or quarter, or filter by warehouse or product category. If it's still slow, contact your system administrator to check if the database needs optimization.