Stock and estimated-cost snapshot for each item. Lists current stock, reservations and available stock alongside estimated cost and margin, in one searchable list — including items with zero stock.
What it shows. One row per item with its code, name, description, estimated cost and (where permitted) estimated margin percent, plus current Stock, Reservation and Available Stock. Available stock is highlighted when it falls below zero. Type an item name or code to search, sort by name or sort order, and click an item code or name to open its full enquiry.
Zero-stock items. Items with no stock on hand are included by default. Use More → Hide Zero Lines to list only items that currently have stock. When zero-stock estimated cost is enabled in Sale Settings, estimated cost can still be calculated for those rows from last purchase price (see Estimated cost).
Performance. The report loads one page at a time (100, 500 or 1000 rows per page). Stock, reservations and estimated cost are calculated only for items on the current page, so large item catalogs stay responsive.
Inventory scope. Stock and estimated cost use the same centre-based inventory scope as Item Enquiry — including your data-filter default inventory, production or sale-return centre when configured. Use the Center advanced filter to narrow further.
When to use it. Use for a quick stock-and-cost lookup across items (including out-of-stock SKUs), to spot items with negative available stock, and to check estimated cost or margin before quoting.
The showZero URL parameter (1 = show zero-stock rows, 0 = hide) reflects the More → Show/Hide Zero Lines toggle. Default is show zero-stock items (showZero=1).
Pagination controls at the bottom let you change page and rows per page (100, 500 or 1000).
Estimated Cost uses the same priority rules as Item Enquiry:
If none of these rules produce a value, Estimated Cost shows —.
Values are calculated on the server and rounded to two decimal places. The same formula applies on Estimated Cost Margin (By Value column) and Item Enquiry.
What is the difference between Stock and Available Stock?
Stock is the quantity on hand. Available Stock is what remains after the Reservation against orders is removed.
Why is an Available Stock value highlighted?
It is highlighted when it is below zero, meaning more is reserved than is physically on hand.
Why can't I see the margin column?
The Est. Margin % column appears only for users with access to estimated-cost margin.
How do I open the full item details?
Click the item code or name to open the item enquiry.
Why don't I see zero-stock items?
Choose More → Show Zero Lines. Zero-stock rows are hidden when Hide Zero Lines is active.
Why is my report empty?
No items match the search text, item type, or advanced filters. If Hide Zero Lines is on, only in-stock items are listed — try showing zero lines or widening filters.
How is this different from Item Enquiry?
This report lists many items with stock and margin columns (paginated). Item Enquiry is a single-item drill-down with orders, purchases and pricing panels. Estimated cost rules are the same on both screens.
Does reservation reduce available stock here?
Yes. Available stock subtracts open Stock Reservations from on-hand quantity.
Why is Estimated Cost blank for a zero-stock item?
Same rules as Item Enquiry: enable Show estimated cost on zero stock in Sale Settings → Price, ensure a last purchase price exists on an approved purchase invoice, and check that a fixed Est. cost (value) on the item is not already overriding the calculation. If Item Enquiry shows a value but this report does not for the same item, regenerate the report after saving Sale Settings.
Does Export include all items?
Export writes the rows currently visible on screen (the active page). Move through pages or adjust filters to export other sets.
Related