Item Movement Report
The Item Movement Report in OrderEazi gives you full visibility into how stock has moved for a specific product over a given period. This is essential for auditing, investigating discrepancies, and un
π Running the Report
When generating the report, the user must provide:
SKU (Stock Keeping Unit) β the item being investigated
Date Range β the period to report on
Optional filters include:
Warehouse β restrict the report to a specific warehouse
Location β narrow the search down further within a warehouse
π Report Columns Explained
The report displays all movements of the selected item within the filters applied. The following columns are included:
π
Date
The date the stock movement occurred.
π Item Code
The SKU or code of the product being tracked.
π’ Warehouse
The warehouse where the movement took place.
π Area / Location
The area and storage location within the warehouse.
Helps pinpoint exactly where the stock was moved.
π€ User
The system user who performed or triggered the movement.
Ensures accountability and traceability.
π Document Number
A reference number linked to the transaction.
This number is clickable and opens the related document (e.g., sales order, purchase order, adjustment).
π§βπ€βπ§ Customer
The customer associated with the movement, if applicable (e.g., sales order fulfillment).
π Changed Qty
The quantity that was added or removed from stock in this movement.
Positive values = stock added.
Negative values = stock removed.
π Detailed Movement View
For deeper insight, you can open the detailed movement view. This includes all the same information above, but also adds:
Before Stock Level β the quantity in stock before the change occurred.
After Stock Level β the updated quantity after the change was applied.
This makes it easy to see how each transaction affected the overall stock balance.
β
Why Use the Item Movement Report?
Audit Trail: Provides a complete history of stock movements.
Discrepancy Investigation: Quickly identify when and how stock differences occurred.
Accountability: See which user performed each movement.
Linked Documentation: Access original transaction documents with one click.
Last updated