# Day Wise Item Movement Report
Day-by-day inward and outward movement of a single item — quantity and value per day with a running closing balance, plus a chart of daily inward vs outward quantity.
Overview
Go to Inventory → Reports → Day Wise Item Movement.
Report title in ERP: Day Wise Item Movement Report
What it shows. For one selected item, a row per day with inward quantity and value, outward quantity and value, and the closing balance quantity and value. The first row shows the opening balance; a Grand Total row sums movement for the period. A bar chart plots daily inward vs outward quantity.
When to use it. Trace exactly when an item moved in or out within a period, investigate stock discrepancies day by day, or review daily consumption and replenishment for a fast-moving item. For a monthly summary instead of daily, use Month Wise Item Movement.
Screenshot pending — Day Wise Item Movement Report view.
Use Cases
- Inventory controller — On which day did this item's stock drop? Run for the item and scan the daily outward column.
- Auditor — Reconcile opening and closing stock for an item over a date range, day by day.
- Store manager — Review daily replenishment vs consumption for a fast-moving item.
- Production planner — Include internal transfers to see WIP and production issue/receipt movement alongside sales and purchases.
Filters
- Item — required. The item to trace.
- Center — optional. Limit movement to one inventory center.
- Date range — period to report on (defaults to the current month).
- Show Internal Transfers / Hide Internal Transfers — toggle to include or exclude internal movements (inventory transfer, WIP transfer, and issue/receipt from production). Off by default.
Columns
The table groups columns under Inwards, Outwards, and Closing Balance, each with a quantity and value.
| **Column** | **Description** |
|------------|-----------------|
| Particulars | The day (date), plus an Opening Balance row first and a Grand Total row last. |
| Inwards — Quantity | Quantity received that day. |
| Inwards — Value | Value of inward movement that day. |
| Outwards — Quantity | Quantity issued that day. |
| Outwards — Value | Value of outward movement that day. |
| Closing Balance — Quantity | Running stock quantity at the end of the day. |
| Closing Balance — Value | Running stock value at the end of the day. |
Chart — a bar chart of Inward Qty vs Outward Qty per day (screen only, not printed).
Actions
- Generate — run the report for the selected item and period
- Show / Hide Internal Transfers — include or exclude internal movement
- Export — export to Excel
- Print — print the report
FAQ
Why do I need to select an item?
The report traces movement for a single item. Choose an item before clicking Generate, or you will be prompted that an item is required.
What counts as an internal transfer?
Inventory transfers between centers, WIP transfers, and issue/receipt from production. They are hidden by default so the report shows external movement (purchases, sales, returns) only. Click Show Internal Transfers to include them.
How is this different from Month Wise Item Movement?
Month Wise Item Movement summarizes inward and outward quantity by month. This report breaks the same movement down to individual days with value and a running closing balance.
What does the Opening Balance row show?
The item's stock quantity and value at the start of the selected period, before the first day's movement.
Why is my report empty?
The selected item had no movement in the period, or no item was selected. Adjust the date range or enable internal transfers if the only activity was internal.