logisticaHQ Client Portal
Expiry report
The Expiry report lists your stock that carries an expiry date and tells you which of it has expired or is about to. Use it to answer "what is about to expire?" It is for any user whose warehouse has turned on View reports.
Who can use this
You need the View reports switch. See Inventory and reports.
How to get there
Reports > Expiry
The subtitle reads "Your stock that carries an expiry date, bin- and LPN-stored."

The Expiry report.
The summary band above the table
Above the table you see three tiles and a chart. They appear only when at least one line has an expiry date; if there is none, there is no band at all (not zeros).
| Tile | What it counts |
| Expired | Units whose expiry date is before today (red number). |
| Expiring ≤ 30 days | Units that expire from today up to 30 days from today, both days included (amber number). Units that have already expired are not counted here. |
| Units | All the units that carry an expiry date. This is not your total stock: units without an expiry date are not counted. |
The tiles count units (the quantity), not rows. For example, a line of 100 units that expired last week and a line of 40 units that expires in ten days give Expired 100 and Expiring ≤ 30 days 40. The numbers are whole numbers with a comma for thousands.
The chart is titled On-hand by expiry window. It is a column chart with one column for each time window, in date order, and the columns show units (the series is named Units). A window with no units is left out.
| Window | Which units | Colour |
| Expired | Expiry date before today | Red |
| ≤ 30 days | Expire today up to 30 days from today | Amber |
| 31–60 days | Expire in 31 to 60 days | Light amber |
| 61–90 days | Expire in 61 to 90 days | Light blue |
| 90+ days | Expire in more than 90 days | Blue |
Important: The tiles and the chart count all the lines in the report. They do not change when you search or filter the table below. They do change when you tick Only expired: they then count only the expired lines (see the Only expired section below).
Columns
| Column | What it means |
| SKU | The product's SKU. |
| Description | The product description. |
| Status | A coloured label: Expired, Expiring soon or OK. See the table below. |
| Expiry | The expiry date, for example Sep 24, 2026. |
| Days to expiry | How many days are left, written as shown below. |
| Warehouse | The warehouse, shown as code, a dot and name (for example 1001 · Main warehouse). |
| Bin | The bin code. For stock on an LPN it is the bin the LPN is in. |
| LPN | The LPN code. Empty when the stock sits loose in a bin. |
| Qty | The quantity with that expiry date, with two decimals, aligned to the right. |
| UoM | The product's unit of measure. |
There are no Lot or Serial columns here. For those, use the Inventory detail report. The cells are plain text, not links. Empty cells are left blank.
Status
| Status | Colour | When |
| Expired | Red | The expiry date is before today. |
| Expiring soon | Amber | The expiry date is today, or up to 30 days from today. |
| OK | Green | The expiry date is more than 30 days from today. |
Days to expiry
The example below assumes today is Sep 24, 2026.
| Expiry date | Days to expiry shows | Status |
| Sep 19, 2026 | Expired 5d ago (bold, red) | Expired |
| Sep 24, 2026 | Today (bold, amber) | Expiring soon |
| Sep 25, 2026 | 1 day | Expiring soon |
| Oct 24, 2026 | 30 days | Expiring soon |
| Oct 25, 2026 | 31 days | OK |
Important: "Today" is the date on your own computer. The report compares calendar days only, never the time of day. If the date on your computer is wrong, the status, the days and the tiles shift with it. Two people whose computers show different dates, for example around midnight, can see different values.
How the rows are split
- Only lines that have an expiry date are listed. Stock in bins and stock on LPNs are both included.
- There is one row for each stock detail that has an expiry date, and Qty is the quantity of that detail. A product with several expiry dates has several rows.
- Unlike the Inventory list, this report does not leave out lines with a quantity of 0, so a line with Qty 0 may appear.
Important: A report shows at most 10,000 lines. If your warehouse holds more lines for you than that, only the first 10,000 are shown, and the page does not warn you that some are left out. Your warehouse sets this limit. If you think lines are missing, use Filters to narrow the report (for example by SKU or warehouse code) and ask your warehouse to check the limit. Only expired is also a way past the limit: it narrows the report before the limit is applied, so the limit is applied to the expired lines (oldest expiry date first) instead of to every line. A few lines that expire today or tomorrow can take part of that room before the page leaves them out. If the expired lines are still more than the limit, the newest of them are not shown and the page does not warn you.
Only expired
Next to the search box there is a checkbox named Only expired. Tick it to see only the stock that has already expired; untick it to see the whole report again.
- "Expired" means the same as in the Status column: the expiry date is before today, by the date on your own computer.
- The narrowing is done by the warehouse system, not only on the rows you can see, so it covers the whole report, not only the rows that fit under the limit above. The limit still applies, but it is applied to the list of expired lines, oldest expiry date first. If you have more expired lines than the limit, you see the oldest ones.
- The summary tiles, the chart, the table and the Excel file all follow the checkbox. While it is ticked, Expiring ≤ 30 days shows 0 and Units equals Expired.
- If nothing has expired, the table is empty and there are no tiles. That is good news, not an error.
- If the report cannot be refreshed, the checkbox goes back to how it was, the previous list stays on the screen and a red message says so.
- The portal does not remember the checkbox when you leave the page.
Search, filter, sort and export
- The toolbar has the search box (Search...), the Only expired checkbox, Filters, Columns and Export. After you filter or search, Clear filters appears with the number of active filters in brackets. The toolbar shows up once the rows have loaded; until then you see only a spinner.
- The whole report is loaded into your browser, so searching, filtering and sorting are quick and happen on your computer. Each column header can open a list of its values (Filter values), including (Blanks) for empty cells. Click a header to sort; you can sort by more than one column. The full how-to is in Searching, filtering and exporting lists.
- The Warehouse column shows the code and the name, but filtering, the list of values and search work with the warehouse code alone. To filter by warehouse, use the code (for example 1001), not the name.
- The report shows 20 rows per page. At the bottom you can choose 10, 20, 50 or 200.
- Export creates an Excel file named PortalReportExpiry.xlsx. It holds every row that matches your current filter and sort, not only the page you see, and only the columns you are showing.
- The Excel file is built from the values behind the columns, so it may look different from the screen: for example, Warehouse may show only the code. Check the file before you rely on it.
- The portal remembers your columns, their order and width, and the sort. It does not remember filters or search text.
- You cannot sort, filter or search the Status column by its text. To see the lines that are about to expire, sort or filter by Days to expiry or Expiry.
- The Expiry filter shows a calendar. Picking a day shows the lines that expire on that day. Use the clear button in the filter to remove it.
- In the Excel file, Status may be empty and Days to expiry may appear as a plain number (negative when expired).
Messages you may see
| Message or situation | What it means | What to do |
| "You don't have access to this section." | Your user does not have the View reports switch. | Ask your warehouse to turn it on. |
| A spinner and no toolbar | The report is still loading. | Wait a moment. |
| "The report could not be refreshed. Showing the previous list." | You ticked or unticked Only expired, but the new list could not be loaded. The checkbox went back to how it was. | Try again in a moment. If it keeps failing, tell your warehouse. |
| An empty report | There are no lines for you, or your search or filters match nothing, or the report could not be loaded. The portal shows no error message in that case. | Click Clear filters. If you expect data, reload the page. If it stays empty, tell your warehouse. |
Good to know
- Units in the band is the number of units with an expiry date, not your whole stock.
- Quantities use a comma for thousands, and dates use the English month abbreviation (Sep), whatever language you use.
Related pages