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.