P4 Software
/
logisticaHQ-en
Applies to: every logisticaHQ tenant. The Only expired checkbox and, for 3PL companies, the Client filter arrived in version 2.64.16
Roles required: office users. A user who belongs to a client cannot open this screen; clients use the Expiry report of the client portal
The expiry report lists every stock line that carries an expiry date, bin by bin and pallet by pallet, with how many days it has left. Use it to find stock to sell, move or discard before it expires, and to see which clients and zones hold the most expired stock. On screen it is titled Expiring inventory.
Only stock whose product is controlled by expiry date appears. A product without Expiry control, or stock received without an expiry date, is not listed.
Analytics > Inventory > Expiry
Two filters sit beside the search box, above the grid. They are applied by the server before the row limit, so they cover the whole report and not only the rows the limit let through. The tiles, the grid and the Excel export all follow them.
| Filter | What it does |
|---|---|
| Only expired (checkbox) | Lists only stock whose Expiry cell reads below zero days: its expiry date is at least a day behind now. Stock that expires later today ("0 days") and stock that has not expired are not listed. |
| Client (lookup; type to search, clear it to show every client) | Lists only the stock of one 3PL client. It is shown only on a 3PL company, and only to a user who is not tied to one client. |
Above the grid, five tiles summarise the report. Every figure is measured from the moment the rows arrived, so tiles and grid agree; a page left open overnight moves on Refresh. The tiles follow Only expired and Client. They do not follow the grid's own column filters or search: those narrow the grid only, and the tiles keep summarising every row the report returned.
Click a bar to put a filter on the grid, named in a chip ("Showing: [label] · [n] rows") with a Show all button. A second click on the same bar clears it.
The "units" in every tile are the sum of the Quantity column. On a pack size row that is packs, not single units.
| Column | Meaning |
|---|---|
| Image, Product, Description | The product. The SKU opens the product. |
| LPN, Bin | Where the stock is. Open the pallet or the bin from here. |
| Expiry | "[n] days": whole days from now until the expiry date, cut towards zero. Stock that expired yesterday reads -1 and stock expiring later today reads 0. The list opens sorted by this column, oldest first. |
| Manufacture date | The date the goods were made, when the stock carries one. |
| Quantity, UoM | The quantity of the line; "x12" for a pack size row, otherwise the unit ("Ea" when the product has none). |
| Client, Zone, Warehouse | Whose stock it is and where it stands. |
If your company has popup QR codes turned on, the Expiry and Manufacture date cells show a QR code when you point at them: see Hover QR codes on reports.
| Symptom | Likely cause | What to do |
|---|---|---|
| A "Partial result" warning appears | The report reached the row limit of your company, so only the first rows are shown. | Tick Only expired or pick a Client: both are applied before the limit. Or ask an administrator about the row limit. |
| A product is missing from the report | The product has no expiry control, or its stock has no expiry date. | Check the product's controls and the stock line. |
| "Unauthorized" when opening the screen | You belong to a client. | Use the Expiry report of the client portal. |
| There is no Client filter | Your company is not a 3PL, or you are tied to one client. | Nothing is wrong. |
Was this page helpful?