Batch Item Expiry Status

Batch Item Expiry Status lists each batch with its item, the quantity still in stock, the expiry date and the days remaining, and flags batches already expired. Quantities come from Stock Ledger Entries per batch; the expiry comes from the Batch record. It is the monthly discipline for pharmacies, food distributors and cosmetics shops: sell, return to supplier or write off stock before it becomes unsellable, and never let an expired batch reach a customer. Items set to block expired batches cannot be delivered after the date, so the report also explains why a delivery is refused. Write offs are posted with a Stock Entry Material Issue or a Stock Reconciliation, not from the report.

Days to expiry = batch expiry date - today; status Expired when the result is negative

1. 01Go to Stock > Batch Item Expiry Status.
2. 02Set From Date and To Date; filter by Item or Warehouse if needed.
3. 03Read Expiry Date, Expires In days and the quantity per batch.
4. 04Sort by Expires In and act on batches under 60 days: discount, return or transfer.
5. 05Write off expired stock with a Material Issue Stock Entry to Stock Adjustment - YFF.

Open monthly to sell or clear stock before it expires.

A batch expiring 2026-12-31 with 20 units left shows about 70 days remaining.