Skip to content
P4 Software P4 Software / logisticaHQ-en

Add these docs to Claude

Ask Claude questions about these docs. Claude reads the published pages and links you back to them. Copy this address:

https://p4-software.opendocs.page/mcp

In claude.ai or Claude Desktop: open Settings, then Connectors, choose Add custom connector and paste the address.

In Claude Code, run:

claude mcp add --transport http docs https://p4-software.opendocs.page/mcp

Expiry report

Analytics / INVENTORY
Expiry report
← Back to Analytics

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

Overview

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.

Navigation

Analytics > Inventory > Expiry

The two filters

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.

The five tiles

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.

  • Expired (Act now): a gauge with expired units as a share of all units that carry an expiry date, with the number of lots and rows. A lot here is one SKU with one expiry date.
  • Runway: a bar of the units by time left: expired, 7 days or less, 8 to 30 days, 31 to 60 days, 61 to 90 days and later. A pill shows the units within 30 days.
  • Next 12 weeks: the units expiring in each of the next twelve weeks, with the units due this week.
  • At risk by client (At risk by product for a client user): the five clients (or products) that hold the most units that are expired or expire within 30 days.
  • Where expired stock sits: the five zones that hold the most expired units, how many zones hold any, and how old the oldest expired row is.

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.

The grid

Column Meaning
Image, Product, DescriptionThe product. The SKU opens the product.
LPN, BinWhere 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 dateThe date the goods were made, when the stock carries one.
Quantity, UoMThe quantity of the line; "x12" for a pack size row, otherwise the unit ("Ea" when the product has none).
Client, Zone, WarehouseWhose 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.

Troubleshooting

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.

Related features

Was this page helpful?