# Item Enquiry

<p class="doc-lead">A complete profile of a single item — stock on hand by center, pricing, recent purchases and sales, pending orders and quotations — all on one screen.</p>

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

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

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

Go to <b>Inventory → Inventory Reports → Item Enquiry</b>.

<p><b>What it shows.</b> Pick an item to open a single-item drill-down (not a plain table): item details, <b>Item Stock</b>, and an inventory summary by center (and variant). When the item has work-in-progress, that summary shows <b>In hand</b>, <b>WIP</b>, and <b>Available</b>. It also lists recent purchases and sales. Where your access allows, pending sale order and purchase order sections are shown. You can narrow the recent activity to a specific customer or supplier.</p>

<p><b>When to use it.</b> Use as a single-screen lookup before quoting, ordering or selling an item, and to answer "how much do we have and at what price?" quickly.</p>

<p><img src="inventory/images/item-enq.webp" alt="Item Enquiry view" loading="lazy"></p>

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

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

<ul>
<li><b>Sales executive</b> — How much of this item is available? Check the item details and the Inventory Summary.</li>
<li><b>Purchase officer</b> — What has recently come in for this item? Review the recent inward transactions.</li>
<li><b>Store keeper</b> — Where is the stock held across centers? See the Inventory Summary panel.</li>
<li><b>Planner</b> — What is committed on pending orders? See the sale order and purchase order sections (shown based on your access).</li>
</ul>

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

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

<b>Item</b> (required), <b>Customer</b> and <b>Supplier</b>. The customer and supplier filters narrow the recent activity shown for the item.

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

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

| **Section** | **What it shows** |
|------------|-----------------|
| Item details | Item name, code, item group, item type, brand, units and price, plus estimated cost where a value can be calculated. See <a href="#/inventory/reports/item-enquiry?id=estimated-cost">Estimated cost</a> below for how estimated cost is calculated. |
| Inventory Summary | Stock per center and variant. <b>In hand</b> is the center total, <b>WIP</b> is work-in-progress at that center, and <b>Available</b> is in hand minus WIP when nothing is reserved. If a reservation exists, the row shows <b>Reserved</b> and <b>Available</b> instead. |
| Item Unit Conversions | Shown in the <b>Inventory</b> tab when you can view item unit conversions. Columns are <b>From Unit</b>, <b>Quantity</b>, <b>Avg Value</b>, and <b>Status</b>. See <a href="#/inventory/reports/item-enquiry?id=avg-value-on-unit-conversions">Avg Value on unit conversions</a>. |
| Recent Inward Transactions | Latest inward movements — Date, Transaction, Transaction ID and Quantity. |
| Recent Outward Transactions | Latest outward movements — Date, Transaction, Transaction ID and Quantity. |
| Sale Orders / Purchase Orders | Pending sale orders and purchase orders (shown based on your access). |

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

<h2 id="avg-value-on-unit-conversions">Avg Value on unit conversions</h2>

<p>The <b>Avg Value</b> column in the <b>Item Unit Conversions</b> table shows the item's average unit value for each <b>From Unit</b>. It is worked out from the average value in the item's stock unit, through the item's unit conversions.</p>

<p>Example: the item is stocked in pieces with an average value of 10 per piece, and 1 box = 12 pieces. The box row shows 120. Conversions chained through other units, such as a carton of boxes, are worked out the same way.</p>

<ul>
<li>Values show to four decimals with the company currency.</li>
<li>A row shows <b>-</b> when no value can be worked out, for example when the item has no stock value or the conversion does not connect to the stock unit.</li>
<li>The column appears only for users who can open the <b>Inventory</b> tab and do not have <a href="#/settings/user-management?id=hide-cost-price">Hide cost price</a> turned on.</li>
</ul>

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

<h2 id="estimated-cost">Estimated cost</h2>

<p><b>Estimated Cost</b> appears in the General tab item details when a value can be calculated. It is for reference on this screen (and on <a href="#/inventory/reports/item-wise-enquiry-report">Item-wise Enquiry Report</a>) — it does not change inventory valuation or sale bill rates.</p>

<p>The system applies the first rule that matches:</p>

<ol>
<li><b>Fixed estimated cost on the item</b> — if <b>Est. cost (value)</b> is set in <a href="#/sales/estimated-cost-margin">Estimated Cost Margin</a>, that amount is shown.</li>
<li><b>Stock on hand</b> — when quantity is greater than zero and the item has an estimated cost margin %, estimated cost = average unit value × (1 + margin % ÷ 100).</li>
<li><b>Zero stock</b> — when quantity is zero, <b>Show estimated cost on zero stock</b> is enabled in <a href="#/sales/sale-settings-config?id=show-estimated-cost-on-zero-stock">Sale Settings → Price</a>, and a last purchase price exists: estimated cost = last purchase price × (1 + add-on % ÷ 100 + margin % ÷ 100). The add-on % comes from <b>Estimated cost add-on % in zero stock</b> in the same settings section; margin % comes from the item's estimated cost margin. Either percentage can be zero if not configured.</li>
</ol>

<p>If none of these rules produce a value, the <b>Estimated Cost</b> row is hidden on Item Enquiry and shows <b>—</b> on <a href="#/inventory/reports/item-wise-enquiry-report">Item-wise Enquiry Report</a>. The same calculated value appears in the <b>By Value</b> column on <a href="#/sales/estimated-cost-margin">Estimated Cost Margin</a> when margin % drives the cost (rounded to two decimal places).</p>

<p>Stock quantity and average unit value on both screens use centre-based inventory scope (your data-filter default centres when configured). Item-wise Enquiry Report lists zero-stock items by default; Item Enquiry always shows the selected item regardless of stock.</p>

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

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

<ul>
<li><b>Generate</b> — load the enquiry for the selected item</li>
<li><b>More → Show Item transactions</b> — open the item's full transaction history</li>
<li><b>More → Show Bill Item Wise Sale</b> — open bill item-wise sale for the item</li>
<li><b>More → Show Bill Item Wise Purchase</b> — open bill item-wise purchase for the item</li>
<li><b>More → Show Serial Number Stock</b> — open serial number stock for the item</li>
</ul>

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

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

<p><b>Why don't I see the order sections?</b><br>The pending sale order and purchase order sections appear based on your access. If you don't have sales or purchase access, those panels are hidden.</p>

<p><b>What do In hand, WIP, and Available mean?</b><br><b>Item Stock</b> at the top is the item's total quantity, including work-in-progress. In the inventory summary, <b>In hand</b> is the center total, <b>WIP</b> is the work-in-progress portion, and <b>Available</b> (when nothing is reserved) is in hand minus WIP — that is the normal stock a sale invoice, transfer, or similar document uses. Use the <b>WIP</b> column for a production voucher or a receipt from production. If stock is reserved, the row shows <b>Reserved</b> and <b>Current Available</b> as well.</p>

<p><b>How do I see batch, bin, and WIP together?</b><br>Item Enquiry is the basic view. For the layer a document posts against, open <a href="#/inventory/reports/inventory-summary">Inventory Summary</a>, turn on every <b>Group by</b> button (<b>Item</b>, <b>WIP</b>, <b>Center</b>, <b>Variant</b>, <b>Batch</b>, <b>Inv Bin</b>), and search the item.</p>

<p><b>How do I see the detailed movement of the item?</b><br>From the <b>More</b> menu choose <b>Show Item transactions</b> to open <a href="#/inventory/reports/item-transactions">Item Transactions</a>.</p>

<p><b>Can I limit the activity to one customer or supplier?</b><br>Yes. Set the <b>Customer</b> or <b>Supplier</b> filter before generating.</p>

<p><b>Why is my report empty?</b><br>The item may have no open orders or recent activity in the filtered scope, or you lack access to hidden panels.</p>

<p><b>Which document statuses appear in pending panels?</b><br>Open sale orders, purchase orders, and receipt/delivery documents use approved and in-progress statuses per panel configuration.</p>

<p><b>How is this different from Stock Report?</b><br>Item Enquiry is a operational snapshot for one SKU; Stock Report lists many items' on-hand quantities.</p>

<p><b>Why is Estimated Cost blank when the item has no stock?</b><br>Zero-stock estimated cost is optional. Enable <b>Show estimated cost on zero stock</b> in <a href="#/sales/sale-settings-config?id=price">Sale Settings → Price</a>, ensure the item has a recorded last purchase price, and that no fixed <b>Est. cost (value)</b> already overrides the calculation. You can also set <b>Estimated cost add-on % in zero stock</b> for extra cost loading on top of last purchase price.</p>

<p><b>How is estimated cost different from Purchase Price on this screen?</b><br><b>Purchase Price</b> is the item master's default cost price. <b>Estimated Cost</b> is a calculated reference for margin and enquiry, using inventory average value, item margin settings, or last purchase price when stock is zero.</p>

<p><b>Why are purchase price and estimated cost missing?</b><br>The user has <a href="#/settings/user-management?id=hide-cost-price">Hide cost price</a> on. That also hides average unit value, recent purchases, unit and variant cost, and the <b>Avg Value</b> on unit conversions on this screen. Stock, sale price, and MRP stay visible. The user must log in again after the setting is saved.</p>

<p><b>Related</b></p>

<ul>
<li><a href="#/sales/sale-settings-config?id=price">Sale Settings — Price</a></li>
<li><a href="#/sales/estimated-cost-margin">Estimated Cost Margin</a></li>
<li><a href="#/inventory/reports/item-wise-enquiry-report">Item-wise Enquiry Report</a></li>
</ul>
