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