What you'll do: find the stock that expires soon so you can sell it first, and see what is left of each lot.
Before you start:
- Your role needs View stock report.
- Stock Expiry Report needs Product Expiry on (Business Settings → Products & Stock); Lot Report needs Lot Number on (Business Settings → Purchases). See Track lot numbers and expiry dates.
- Filters, print and export work as in How reports work.
Open Reports & Analytics → Reports → Stock Expiry Report.
Press Filter (Filter Products): branch, category, brand and unit, the Expiry Window, and a Date Range of expiry dates.
1 Filter · 2 Stock Left · 3 Expiry Date Read the report:
- Product, SKU, Ref. No. (the purchase) and Location;
- Stock Left, Lot No., Expiry Date and Mfg. Date;
- Edit Expiry in the Action column corrects a wrong expiry date (Edit Expiry Date).
Use Export CSV, Export Excel (XLSX) or Print above the table (Current Page Only or All Records). See How reports work.
Lot report
Section titled “Lot report”Open Reports & Analytics → Reports → Lot Report. Press Filter (Filter Stock) for branch, category, brand and unit. Each row shows the Product, SKU, Lot Number, Expiry Date, Stock, Total Sold and Total Adjusted of one lot.