Reports

Review Expired Products and Remaining Stock

The Expired Product tab is a stock-control worklist, not a disposal record. It reports items whose expiry date falls in the selected range and whose available quantity is still above zero.

Menu path
Reports -> Inventory -> Item -> Expired Product
Verified from
Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence

Live demo Reports -> Inventory -> Item -> Expired Product audited and captured 2026-09-05, frontend/modules/itemReport.html expiry tab table and export, frontend/static/script/js/modules/js/report_items.js date range pagination and CSV export, api/src/repositories/sale.repository.js itemExpiryReportPage date and positive-stock filters, frontend/static/script/js/modules/js/sales.js expired-item discovery filtering

Expired Product reportLive Posnic demo captured 2026-09-05. Choose the expiry-date range and review the resulting item, quantity, category and expiry columns.
Correct the source itemExpiry reporting depends on the date stored on each item record; correct source data before acting on the report.

What the Report Includes

ColumnMeaningCheck
NameSaved item nameMatch the physical product and identifier.
Available quantityRemaining quantity on the item recordCount the physical stock before adjustment.
CategorySaved item categoryUse it to route review to the right owner.
Expiry dateSaved item expiry dateCompare with the package or source document.

Run the Review

  1. Open Reports -> Inventory -> Item.
  2. Choose Expired Product.
  3. Set a date range that covers the expiry dates being reviewed, not merely the sale date.
  4. Review the result count and move through every page.
  5. For each row, compare item name, available quantity, category and expiry date with the physical stock.
  6. Use Export All to CSV when a signed worklist or offline review is required.
  7. Record the action owner before changing stock or item data.

Understand the Filters

  • The report matches expiry dates inside the selected start and end range.
  • Only records with available quantity greater than zero are returned.
  • Branch access limits the result to the active branch context.
  • A blank result can mean no matching dates, no remaining quantity, another branch or missing item expiry data.
  • The current export is a working CSV of report rows; it is not a regulatory disposal certificate.

Control Expired Stock

  1. Quarantine the physical units so staff cannot pick them.
  2. Verify the item is no longer discoverable in New Sale after expiry.
  3. Investigate any mismatch between counted stock and Available quantity.
  4. Use the approved inventory adjustment or return process; do not erase the item merely to clear the report.
  5. Retain the report export and adjustment or supplier-return evidence required by the business.
  6. Rerun the same range and confirm the reviewed quantity no longer remains unresolved.

Do Not Overclaim

This report proves a date-range query against item-level expiry and positive recorded stock. It does not by itself prove batch identity, FEFO picking, disposal, supplier return, recall completion or regulatory compliance.

Troubleshooting

SymptomCheckAction
Expected item is missingDate range, branch, saved expiry and available quantityCorrect the source item or range, then rerun.
Expired item still appears at the tillSaved date format and actual catalog recordStop sale, identify duplicates and escalate before trading.
Quantity is wrongPhysical count and inventory historyReconcile through the approved stock procedure.
Export is disabledWhether the result has rowsWiden the correct expiry range or fix missing dates; do not fabricate a row.
No RecordsNo positive-stock item matchedDocument the range and continue the scheduled review.

Review Record

  • Branch, expiry range and run time.
  • Exported rows and physical count result.
  • Quarantined quantity and location.
  • Adjustment, return or disposal reference.
  • Named reviewer and completion date.

Related Manual Pages

Catalog Manufacturing and Expiry Dates Date-sensitive items need accurate item-master dates before staff rely on expiry reports or sale-screen filtering. Posnic stores both dates on the Details tab and requires expiry to follow manufacturing date. Reports Inventory Reports Inventory reports turn item and category data into operating signals: what sold, what is stocked, what expired and which categories drive sales. Inventory Inventory Logs Inventory Logs are the branch stock ledger. Each row opens a movement detail beside the list, where operators can inspect the reference and follow controlled links to the item, sale or purchase. Inventory Stock Control Stock control starts when items are created and continues through every sale, return, purchase, adjustment and low-stock review. Purchase Purchase Actions Purchase actions change evidence after the purchase is saved. Print and email share the document; returns and voids affect stock and accounting history.