ZenotiHelp

Review the current stock β€” v1 report

ZTZenoti Docs Team Updated October 20, 2026 11 min readReference

Deprecated: This is a legacy report. Where Enable partial audit of products is on, the Current Stock menu item opens the modern report instead of this screen. Use the V2 Current stock report instead.

Deprecated: The legacy Current Stock report was replaced by the V2 Current Stock report in April 2022. The V2 report provides broader filtering, multiple costing methods, and a larger result window.

Audience: Inventory manager, center admin

The legacy Current Stock report shows the on-hand quantity of each product at a selected center as of a chosen date, together with a stock value derived from a value method you pick (Average or FIFO). Use this report when you need a quick point-in-time check of what is on the shelf and back room and what that stock is approximately worth β€” a counterpart to the procurement, audit, and ledger reports that explain how the on-hand number got there.

This is a legacy report; for organizations without access to it, the modern V2 Current Stock report is the only stock-quantity report exposed. For deeper analysis β€” multiple costing methods side by side, full filtering and grouping, larger result windows β€” use the V2 report linked below.

V2 equivalent: For the current version of this report, see Current stock report.

Tip: If you are trying to reconcile the quantities shown in this legacy report against the V2 Current Stock report, see Current stock report. For the reconciliation rule that governs when this legacy report's on-hand baseline resets β€” and that also governs whether the screen opens at all β€” see Reconciliation and approval.

Data refresh: The on-hand quantity reflects all stock movements completed at the moment you open the report β€” received purchase orders, dispatched and received transfer orders, sales, service consumptions, conversions, bundling, restocks, and any approved audit reconciliations applied since the last reconciliation cycle.


On this page


Before you begin

  • Confirm which screen your Current Stock menu item opens. The menu item is still present and still captioned Current Stock, but while Enable partial audit of products is on it opens the modern Current stock report rather than this legacy screen.
  • Select the center for which you want to run the report. The legacy report is center-scoped: stock quantities are always per center; there is no organization-wide aggregate row.
  • Decide which value method you want to use: Average (current weighted-average cost per unit) or FIFO (First In First Out). Article values shown in the column reference are point estimates and not a substitute for finance-grade valuation; for period-end valuation, use the V2 Current stock report instead.

The audit check that gates this screen

Important: When you open the legacy screen at a center, it loads only if that center has a completed audit of the same product type that started within the last 92 days. Retail audits count for the retail screen, and consumable audits count for the consumable screen. When the check fails, the browser shows Please audit your products every 3 months to view this report., the export buttons are hidden, and no rows load.

What this means in practice:

  • A center that has never completed an audit of that product type is blocked from the screen for that product type.
  • An audit that is still waiting for reconciliation approval does not count until it is approved.
  • The on-screen message refers to three months; the check itself uses a 92-day window measured from the audit's start date.
  • No setting changes the window or turns the check off.
  • The check is not applied when the screen is opened for a zone or for the organization β€” only when it is opened at a center.

If the check blocks you, work through the remedies in this order:

  1. Complete an audit of that product type at that center and, where your organization requires approval to reconcile, get the reconciliation approved. See Inventory audit and physical count and Reconciliation and approval.
  2. Use the modern Current stock report, which has no such check.

Permissions

Permission: Access to the legacy report endpoint requires any role assigned to the user on the selected center. There is no separate report-only permission for the legacy surface β€” to restrict who can see stock data, restrict role assignment to the center.

Permission: Reconcile under Inventory β€” required to reconcile an audit so that it counts toward the audit check described above.

Permission: Current Stock Report under the Inventory group of the Reports(V2) section β€” required to open the modern Current stock report as the alternative route.

Run the report

  1. At the center level, open the legacy screen from either of its two entry points:
    • The Inventory menu's Current Stock item, under Retail or under Consumable. This opens the legacy screen only while Enable partial audit of products is off; once that setting is on, the same menu item opens the modern Current stock report.
    • The Reports dashboard entries Current Stock Retail and Current Stock Consumable. Both open this same legacy screen.
  2. Set the Stock As On date. The report returns the on-hand position at the end of that date in the center's time zone.
  3. Optionally set filters from the Filter reference.
  4. Pick a Value by method β€” Average or FIFO. Leaving this unset returns quantities only; the Value and Tax columns are blank.
  5. To export the results, click Excel or CSV.

Note: If the screen loads no rows and shows Please audit your products every 3 months to view this report., the center has not completed a qualifying audit for that product type. See The audit check that gates this screen.

Note: Click any product name in the result grid to open the Product Transaction History window for that product. The window lists every stock movement that affected the row, in chronological order, with the running quantity and value after each event.

Filter reference

The legacy report exposes the following filter set.

Filter Values Description
Stock As On Date The point-in-time at which on-hand stock is computed. The report rolls back through the stock ledger to reconstruct stock as of this date.
Product type Retail / Consumable / All Determines which quantity columns are populated.
Category Configured product categories Limits results to products in the selected category.
Sub-category Configured sub-categories Further narrows the category filter.
Vendor Configured vendors Limits results to products mapped to the selected vendor.
Search Free text Filters rows by product name or by primary product barcode substring.
Value by Average / FIFO Drives the Value and Tax columns. The underlying value methods supported are FIFO (First In First Out) and Average.

Column reference

The result columns returned by the report are listed below.

Column Type Description
Product Name Text Display name of the product.
Product Code Text Configured product code or SKU (Stock Keeping Unit).
Category Text Parent category for the product.
Sub Category Text Sub-category, if configured.
Vendor Text Default vendor associated with the product at this center. Blank when no default vendor is assigned.
Unit Text Volume per item plus the configured unit-of-measure abbreviation (for example, 30 ml).
On-hand qty β€” Retail Number Aggregate retail on-hand quantity at this center as of Stock As On. Combines back-room and floor positions into a single number.
On-hand qty β€” Consumable Number Aggregate consumable on-hand quantity at this center as of Stock As On.
Total qty Number Sum of Retail and Consumable on-hand quantities.
Value Currency Estimated stock value computed using the selected Value by method (Average or FIFO). Blank when Value by is not selected.
Tax Currency Estimated tax accumulated on the stock at the same Value method. Blank when Value by is not selected.

Note: Earlier deployments may also surface separate Storeroom and Floor columns where the organization still operates on the legacy store-and-floor model (sign-ups before April 2020). The modern data model unifies these into a single on-hand quantity. The transition from store-and-floor to on-hand is a one-way migration handled by Zenoti Support; there is no self-service toggle.

What updates the on-hand quantity

The on-hand quantity shown in this report reflects the cumulative effect of every recorded stock movement up to Stock As On. The categories of events that move the on-hand number, in summary:

  • Opening quantity is set by the most recent Approved reconciliation (or Auto-reconciliation) for the center. Each new reconciliation cycle re-baselines opening quantity.
  • Inflow events that increase on-hand quantity: a delivered purchase order, a Retail-to-Consumable or Consumable-to-Retail conversion that lands stock in the target bucket, an Unbundle that returns kit components to stock, and a Restock recorded against a return.
  • In-transit events (transfer orders): stock dispatched from the source center reduces the source's on-hand quantity at dispatch; stock received at the destination increases the destination's on-hand quantity at receipt.
  • Outflow events that decrease on-hand quantity: dispatched transfer orders, product sales at checkout, service consumption (manual and Appointment Product Consumption (APC)), Retail-to-Consumable conversions out of the source bucket, and Bundle operations that consume kit components.

For a transaction-by-transaction breakdown, run the Stock ledger report, which exposes every individual ledger entry rather than only the closing position.

Worked example

A center admin wants to verify retail stock on a single category as of the end of yesterday before placing today's auto-PO run.

  1. Open Inventory > Retail > Current Stock.
  2. Set Stock As On to yesterday's date.
  3. Set Category to Hair Care.
  4. Set Value by to Average.

Sample result rows:

Product Name Product Code Unit On-hand qty Value Tax
Shampoo β€” Smoothing 250ml SHA-SM-250 250 ml 12 240.00 14.40
Conditioner β€” Smoothing 250ml CON-SM-250 250 ml 5 110.00 6.60
Hair Serum β€” Repair 50ml SER-RP-50 50 ml 0 0.00 0.00

The admin sees that Hair Serum β€” Repair 50ml is at zero on-hand quantity, exports the category, and uses the export as a checklist when raising the day's purchase order.

Tips

  • Keep a retail and a consumable audit inside the window. The screen gates each product type separately, so a center that audits only retail stock loses access to the consumable screen once 92 days pass since the last consumable audit started.
  • Pair with the ledger. When an on-hand number looks wrong, run the Stock ledger report for the same product and date range β€” it lists every movement so you can find the entry that explains the difference.
  • Treat the Value column as an estimate. For period-end valuation, switch to the V2 Current stock report, which exposes Perpetual Average Cost and FIFO (First In First Out) as the standard costing methods. The legacy Average and FIFO values are point estimates and are not equivalent to the finance-grade valuation used in the V2 surface.
  • Comparing against the V2 report? Quantities should agree; values are expected to differ. See Current stock report.
  • Use Stock As On for back-dated checks. The legacy report can roll back to a historical date, which is useful when reconciling an audit dispute or verifying the closing position at month-end.
  • The reconciliation rule determines opening quantity. If a completed reconciliation was approved after your Stock As On date, the baseline used in this report may differ from a more recent reconciliation. Always confirm the latest approved reconciliation date when investigating discrepancies. For details on how the reconciliation cycle works, see Reconciliation and approval.

Troubleshooting

Issue Cause Resolution
Please audit your products every 3 months to view this report. appears, the export buttons are hidden, and no rows load The center has no completed audit of that product type that started within the last 92 days. Either no audit of that type has ever been completed at the center, or the most recent one is still waiting for reconciliation approval. No setting changes the window or turns the check off. Complete an audit of that product type at that center and, where your organization requires approval to reconcile, get the reconciliation approved β€” see Inventory audit and physical count and Reconciliation and approval. Until then, use the Current stock report, which has no such check.
The audit check blocks the retail screen but not the consumable screen (or the reverse) The check matches the product type of the screen: retail audits count for the retail screen, and consumable audits count for the consumable screen. Complete an audit for the product type whose screen is blocked.
Current Stock in the Inventory menu opens a different report Your organization has Enable partial audit of products turned on, so the menu item opens the modern report. The menu item is not removed β€” it is still present and still captioned Current Stock. The setting cannot be turned off. Use the Current stock report, or open Current Stock Retail / Current Stock Consumable from the Reports dashboard if legacy reports are enabled.
Vendor column is blank The product has no default vendor assigned at this center. Assign a vendor on the product's center-level configuration.
Value and Tax columns are blank Value by is not selected, or the product has no procurement history that can be valued at the chosen method. Select Average or FIFO from the Value by filter. For a product with no procurement history, raise an opening-stock entry or wait for the first delivery to populate cost.
On-hand quantity differs from a physical count A pending reconciliation has not been approved, or a recent movement has not been recorded. Run the Stock ledger report for the affected product to identify the missing or unapproved event, then complete the reconciliation cycle.
Empty result with broad filters The Stock As On date is earlier than the center's go-live date, or the user's role has no center assignment. Move the Stock As On date forward, or confirm the user is assigned a role on the selected center.
Legacy report shows different quantities than the V2 Current Stock report The two reports may use different reconciliation baselines or costing methods. Quantities should agree if the same date and center are selected; values will differ by design. If quantities also differ, contact Zenoti Support to review the reconciliation history for the center.
Was this article helpful?
Your feedback helps us improve our documentation.