Open Inventory → Reports with the Bar Chart 3 icon. This screen is a current product-level inventory snapshot, not a dated movement report. It has five visible tabs and include/exclude filters; it currently has no date range, variant/location drill-down, export, Save Report, or working row regrouping. Use Inventory → Movements for historical stock activity and Inventory → Saved Reports only for configurations created by a supported save flow elsewhere.
Step by step
- Go to Inventory → Reports. The page title is Inventory Reports even though the browser title currently says Report Center. Only products with Track inventory enabled participate; untracked catalog products are excluded before any report filter is applied.
- Start on Summary. Products is the number of filtered tracked product records. Total Units adds stock_on_hand across every returned location-stock row. Total Value adds each location quantity multiplied by the product’s current Supply price. Negative stock can reduce both totals and value.
- Read each Summary row as one master product: product name, base SKU, aggregate units across its location-stock rows, and aggregate cost value using the base product supply price. The current screen does not expand variants or locations and does not open the product from the row.
- Choose Add Filter. Select Product Name, SKU, Supplier, Brand, Category, Tag, or Location, then choose Include or Exclude and type to search. Suggestions are limited to the first 10 matches for the chosen type; choose the exact suggestion to create a filter chip.
- Understand filters of the same type and mode as a group. Multiple Include chips for the same dimension work as OR: a product can match any chip in that group. Separate include dimensions work together as AND because each dimension group is applied in turn. Multiple Exclude chips remove a product if it matches any excluded value in that group.
- Understand Location filtering precisely. A product matches a Location chip only when it has a location-stock row for that location with stock_on_hand greater than zero. Include Location therefore does not show zero or negative stock at that location, and Exclude Location removes only products with positive stock there. The totals still aggregate all returned location rows for products that survive; they are not recalculated to only the selected location.
- Remove one chip with its X, or choose Clear all to remove every filter. The tab, filters, and nondefault group selector are encoded in the page URL, so a copied authenticated link can restore those controls for a permitted user. It does not preserve a historical inventory snapshot.
- Choose Replenishment to list a product when any location-stock row has a non-null Reorder point and stock_on_hand is less than or equal to that threshold. The row shows aggregate stock as “remaining,” not the specific triggering location or its reorder point. Use Live Inventory or the product/location record to identify the actual exception before ordering.
- Choose Performance to sort the filtered products by the stored Margin field from highest to lowest. Each row shows margin, aggregate units, and aggregate cost value. This is not sales velocity, profit earned, turns, or sell-through; no sales date window is queried on this screen.
- Choose Out of Stock to list products whose aggregate stock across all returned location rows equals exactly zero. A product with negative aggregate stock is not included, and one positive location can offset a negative location to produce zero. The row does not identify which location is empty.
- Choose Dusty to list products with aggregate stock greater than zero, ordered from the oldest product updated_at timestamp to the newest. The “days idle” number is days since the product record was updated, not days since last sale, receipt, transfer, count, or stock movement. Treat it as catalog-record staleness rather than proven slow-moving inventory.
- On desktop, choose Summary, Replenishment, Performance, Out of Stock, or Dusty from the tab row. On mobile, use the single report dropdown; the header collapses after scrolling to leave more room for results.
- The screen initially renders 50 result rows. Choose Load more to add the next 50 until all rows for the active tab and filters are visible. Changing the tab or any filter resets the visible count to the first 50.
- Treat the By Product, By Brand, By Category, and By Location selector as nonfunctional for row grouping in the current implementation. It changes the group parameter in the URL, but the calculations and rows remain product-level. Do not describe or screenshot the unchanged rows as a brand, category, or location grouping.
- Interpret empty states in context. No products currently below reorder point means the current replenishment/filter result is empty. All products are in stock means no filtered product has aggregate stock exactly zero. No results found covers Summary, Performance, or Dusty when filters or source records produce no rows.
- For location-specific stock, variants, reorder points, or available quantity, open Inventory → Live Inventory. For dated sales, receipts, transfers, counts, returns, fulfillments, or adjustments, open Inventory → Movements. For audit-quality purchasing decisions, trace the product and exact location instead of relying only on aggregate product rows.
- There is no Export, Print, Save Report, scheduled report, row detail, or chart control on this screen today. Do not tell a user to save or export this view. If a repeatable report is required, preserve the authenticated URL for the current controls or use another supported reporting surface until Inventory Reports exposes a real save/export action.
Screen and contract reference
| Control or area | What it means |
|---|---|
| Bar Chart 3 icon | The exact CentriPOS navigation icon for Inventory → Reports. |
| Tracked products only | The source list begins with products whose Track inventory setting is enabled. |
| Summary | Current product-level quantities and supply-cost value for the active filters. |
| Products | Count of filtered tracked master-product records, not variants or location rows. |
| Total Units | Sum of stock_on_hand across every location-stock row belonging to filtered products. |
| Total Value | Sum of stock_on_hand × current base product Supply price across location-stock rows; negative stock can reduce it. |
| Product row | Master product name, base SKU, aggregate units, and product-level cost value; it is not interactive. |
| Add Filter | Opens filter type, Include/Exclude mode, and a searchable suggestion list. |
| Product Name filter | Matches one exact product ID selected from suggestions. |
| SKU filter | Matches the exact base product SKU; variant SKUs are not offered by this screen’s filter source. |
| Supplier / Brand / Category / Tag filter | Matches relationships attached to the master product. |
| Location filter | Matches only a location-stock row whose stock_on_hand is greater than zero; totals remain aggregated across the surviving products’ rows. |
| Include chip group | OR within the same dimension; different dimension groups are applied together. |
| Exclude chip group | Removes products matching any excluded value in that dimension. |
| Filter-chip X | Removes one exact include or exclude filter. |
| Clear all | Removes every active filter without changing the selected report tab. |
| Replenishment | Products having any location row at or below a non-null reorder point; the displayed remaining quantity is aggregate. |
| Performance | Products sorted by stored margin descending, with units and cost value; it is not dated sales performance. |
| Out of Stock | Products whose aggregate stock equals exactly zero; negative aggregate inventory is excluded. |
| Dusty | Positive aggregate-stock products ordered by product-record updated_at; days idle does not represent last inventory movement or sale. |
| Mobile report dropdown | Mobile replacement for the five desktop tab buttons. |
| Load more | Adds 50 more product rows for the active result. |
| By Product / Brand / Category / Location | Currently writes URL group state only and does not regroup or recalculate the displayed product rows. |
| URL state | Stores tab, filters, and nondefault group choice for an authenticated permitted user; it is not a saved historical snapshot. |
| No products currently below reorder point | Completed empty Replenishment result for current filters. |
| All products are in stock | Completed empty Out of Stock result under the exact aggregate-zero rule. |
| No results found | Completed empty result for the active source, tab, and filters. |
| Not available here | No date range, movement history, variant/location drill-down, export, print, chart, Save Report, or scheduled report control. |
Expected result
The active tab and include/exclude chips return the intended tracked master products; aggregate units and supply-cost value reconcile to their location-stock rows; replenishment, exact-zero, margin, and product-update-age rules explain every exception; and no dated movement, variant/location drill-down, export, save, or regrouping behavior is inferred from controls that do not provide it.
Troubleshooting
- Confirm the exact product variant and stock location before posting a quantity change.
- Use the movement ledger to identify the source workflow instead of correcting history directly.
- Avoid a manual adjustment when receiving, transfer, count, sale, or return is the correct workflow.
CentriPOS API explorer · API Center administration