# Negative Inventory Transactions

<p class="doc-lead">A diagnostic report that lists points where an item's running stock balance went negative. Use it to find and correct transactions that issued more stock than was on hand.</p>

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

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

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

Go to <b>Inventory → Inventory Reports → Negative Inventory Transactions</b>.

<p><b>What it shows.</b> One row per ledger point where the stock balance for an item went below zero in the selected period. Each row shows the transaction that caused it, the item, center, batch, bin, variant and work-in-progress flag involved, and the negative <b>Balance</b> reached. Click a row to open the underlying item transactions, or click the transaction reference to open the document.</p>

<p><b>When to use it.</b> Use it as a clean-up and audit tool — negative balances usually mean stock was issued before it was received, or a back-dated entry pushed the balance below zero. Investigate and correct these before closing a period or trusting stock valuation.</p>

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

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

<ul>
<li><b>Inventory controller</b> — Where did stock go negative and which document caused it? Generate for the period and review each row.</li>
<li><b>Finance</b> — Are there negative balances that would distort stock valuation? Clear them before period close.</li>
<li><b>Store keeper</b> — Was an issue entered before the matching receipt? Open the transaction to check and re-date it.</li>
<li><b>Support / implementation</b> — Are back-dated entries breaking the stock ledger? Use this to locate the offending transactions.</li>
</ul>

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

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

<b>Date</b> (date range). The report can also be opened scoped to a specific item, center, transaction type or batch when launched from another screen.

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

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

| **Column** | **Description** |
|------------|-----------------|
| # | Row number. |
| Date | Date and time of the transaction. |
| Transaction Type | Type of transaction that caused the negative balance (or Journal). |
| Transaction Id | Reference of the transaction. Click to open the document. |
| Item Id | Item involved. |
| Center Id | Center where the balance went negative. |
| Batch Id | Batch involved, if batch tracked. |
| Inventory Bin Id | Bin involved, if bin tracking is used. |
| Item Variant Id | Item variant involved, if variants are used. |
| WIP | Whether the balance relates to work-in-progress stock. |
| Balance | The negative running balance reached at that point. |

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

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

<ul>
<li><b>Generate</b> — run the report for the selected period</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>clear</b> — reset an active scope filter</li>
</ul>

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

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

<p><b>What causes a negative inventory balance?</b><br>Usually stock issued before the matching receipt, or a back-dated transaction that pushes the running balance below zero at some point in time.</p>

<p><b>How do I fix a negative balance?</b><br>Open the transaction from the row, check its date and quantity against the receipts, and correct the date or quantity so stock is received before it is issued.</p>

<p><b>What does the WIP column mean?</b><br>It indicates the negative balance relates to work-in-progress stock rather than finished/normal stock.</p>

<p><b>Why does a row show "Journal" as the transaction type?</b><br>When the entry is not tied to a standard inventory document, it is shown as a journal-level ledger entry.</p>

<p><b>Why does the date range fail validation?</b><br>This report allows a maximum range of about one month. Narrow the from/to dates and generate again.</p>

<p><b>Why is my report empty?</b><br>No negative running balances occurred in the period for approved ledger rows, or filters exclude all items.</p>

<p><b>Does the system allow negative stock going forward?</b><br>By default issues are blocked when stock is insufficient; negative rows here usually indicate back-dated or historical data issues to correct.</p>