# Day Wise Item Movement Report

<p class="doc-lead">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.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/inventory/reports/day-wise-item-movement?id=overview">Overview</a>
<a href="#/inventory/reports/day-wise-item-movement?id=use-cases">Use Cases</a>
<a href="#/inventory/reports/day-wise-item-movement?id=filters">Filters</a>
<a href="#/inventory/reports/day-wise-item-movement?id=columns">Columns</a>
<a href="#/inventory/reports/day-wise-item-movement?id=actions">Actions</a>
<a href="#/inventory/reports/day-wise-item-movement?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Inventory → Inventory Reports → Day Wise Item Movement Report</b>.

<p><b>What it shows.</b> 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 <b>Grand Total</b> row sums movement for the period. A bar chart plots daily inward vs outward quantity.</p>

<p><b>When to use it.</b> 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 <a href="#/inventory/reports/month-wise-item-movement">Month Wise Item Movement</a>.</p>

<p><i>Screenshot pending — Day Wise Item Movement Report view.</i></p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Inventory controller</b> — On which day did this item's stock drop? Run for the item and scan the daily outward column.</li>
<li><b>Auditor</b> — Reconcile opening and closing stock for an item over a date range, day by day.</li>
<li><b>Store manager</b> — Review daily replenishment vs consumption for a fast-moving item.</li>
<li><b>Production planner</b> — Include internal transfers to see WIP and production issue/receipt movement alongside sales and purchases.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<b>Item</b> (required), <b>Center</b>, <b>Date</b> range (defaults to the current month), and a <b>Show/Hide Internal Transfers</b> toggle to include or exclude internal movements (inventory transfer, WIP transfer, and issue/receipt from production; off by default). The date range is limited to about 90 days.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

The table groups columns under <b>Inwards</b>, <b>Outwards</b>, and <b>Closing Balance</b>, each with a quantity and value.

| **Column** | **Description** |
|------------|-----------------|
| Particulars | The day (date), plus an <b>Opening Balance</b> row first and a <b>Grand Total</b> 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. |

<b>Chart</b> — a bar chart of <b>Inward Qty</b> vs <b>Outward Qty</b> per day (screen only, not printed).

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected item and period</li>
<li><b>Show / Hide Internal Transfers</b> — include or exclude internal movement</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>Why do I need to select an item?</b><br>The report traces movement for a single item. Choose an item before clicking Generate, or you will be prompted that an item is required.</p>

<p><b>What counts as an internal transfer?</b><br>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 <b>Show Internal Transfers</b> to include them.</p>

<p><b>How is this different from Month Wise Item Movement?</b><br><a href="#/inventory/reports/month-wise-item-movement">Month Wise Item Movement</a> summarizes inward and outward quantity by month. This report breaks the same movement down to individual days with value and a running closing balance.</p>

<p><b>What does the Opening Balance row show?</b><br>The item's stock quantity and value at the start of the selected period, before the first day's movement.</p>

<p><b>Why is my report empty?</b><br>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.</p>

<p><b>Why does the date range fail validation?</b><br>This daily report allows a maximum span of about 90 days. Select a shorter period and generate again, or use <a href="#/inventory/reports/month-wise-item-movement">Month Wise Item Movement</a> for a longer range.</p>
