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 control

Expiry control
← Back to Products

An expiry-controlled product records an expiry date on every receipt. LogisticaHQ keeps stock with different expiry dates apart, refuses deliveries that are too close to expiry, never allocates stock that would expire too soon for the customer, and can pick the oldest stock first (FEFO: first expired, first out). Use it for food, pharmaceuticals, cosmetics, chemicals and anything with a shelf life.

This page explains how to configure a product with expiry dates, every field and setting involved, and what changes on the floor.

How to configure a product with expiry dates

  1. In the left menu, open Setup > Products.
  2. Open the product (click its SKU), or click New to create it first (see Products).
  3. In the Attributes section, set Expiry controlled to Yes. Two fields appear: Inbound allowance and Outbound allowance.
  4. Optional: fill in the allowances (in days), explained below. Leave them empty to use the vendor's, the customer's or the company's values.
  5. Most expiry-controlled Products are also lot controlled: set Lot controlled to Yes if each batch has a lot number (see Lot control).
  6. Save the product. When Expiry controlled is set back to No, the two allowances are cleared.

The Attributes section of a product with Expiry controlled set to Yes

Decide before the first receipt

Expiry control cannot be changed while the product has stock ("Cannot change lot, serial, expiry, manufacture date, packsize, catch weight or unit of measure control while [SKU] has inventory..."), nor while it is on an open purchase order, pick ticket, production order or customer return ("Attribute control cannot be changed. Product has open transactions") unless Allow Attribute Change is on (Setup > System > Configuration, Business > Products; default No).

Fields

FieldValuesDefaultWhat it does
Expiry controlledYes / NoNoEvery receipt records an expiry date. Stock with different dates is kept apart.
Inbound allowanceDaysEmptyShown only when Expiry controlled is Yes. The days of shelf life a Delivery must still have left, or it is refused at Receiving. Empty uses the vendor's Expiry allowance, then the company setting.
Outbound allowanceDaysEmptyShown only when Expiry controlled is Yes. The days of shelf life stock must still have left to be allocated to an order. Empty uses the customer's Outbound expiry allowance, then the company setting.

Receiving: which deliveries are accepted

  • After the product (and the lot, if lot controlled), the Handheld asks Enter/Scan expiry. A GS1 barcode fills the date in from the product scan (settings Default Barcode Standard and Udi Autofill, see Serial control). A receipt without a date is refused: "Expiry is missing for product [SKU]".
  • Inbound allowance. A Delivery whose expiry date is fewer days away than the allowance is refused: "Cannot receive product. Product expiry allowance is [N] days". The allowance is taken from the first of these that is filled in:
    1. the product's Inbound allowance;
    2. the vendor's Expiry allowance (Vendor screen);
    3. Expiry Allowance in Setup > System > Configuration, Business > Receiving > Operations (default 0). A positive number requires that many days of shelf life left; a negative number admits product that expired up to that many days ago.
  • Expired product. Stock that has already expired is refused when it is received or adjusted in: "Cannot add expired product [SKU]", unless Allow Expired Product is on (Business > Products; default No). Cycle counts are exempt, so a count records expired stock that is really there.
  • Customer Returns use the same rule with the product's Inbound allowance, then the customer's Inbound expiry allowance (Customer screen), then Expiry Allowance in Business > Returns > Operations (default 0).

Storage: one date or several per bin and license plate

  • A bin holds one expiry date of a product unless the bin allows more: on the Bin screen, section Product handling, Allow multiple expiries (Inherit, Yes, No); when the bin inherits, the zone decides (Zone screen, Allow multiple expiries per bin). Otherwise: "Bin [bin] cannot contain product with multiple expiry dates".
  • A license plate holds one expiry date unless Allow Multiple Expiries is on (Business > License Plates; default No): "LPN [lpn] cannot contain product with multiple expiry dates".

Allocation: which stock an order gets

  • Outbound allowance. Stock whose expiry date is fewer days away than the allowance is not allocated to orders. The allowance is the product's Outbound allowance, else the customer's Outbound expiry allowance (Customer screen), else Expiry Allowance in Business > Fulfillment > Allocation (default 45 days). If an order stays unallocated although stock is on hand, check whether that stock is within the allowance.
  • Order of dates. Expiry Allocation Precedence (Business > Fulfillment > Allocation) decides which dates go first: NoPrecedence (default: the general Allocation style decides), OldestFirst (FEFO, the earliest expiry first) or NewestFirst. It wins over the Lot Allocation Style.
  • Production orders use their own settings in Business > Production > Allocation: Expiry Allowance (default 145 days) and Expiry Allocation Precedence (default OldestFirst).
  • Replenishment (restock) moves use the Fulfillment Expiry Allowance and precedence too.

Picking

The Handheld shows the expiry date that was allocated and asks the picker to scan or enter it. A different date is refused: "Invalid Expiry [scanned], [allocated] expected".

Where to see expiry dates

  • Analytics > Inventory > Expiry: stock listed by expiry date. Since version 2.64.16 the report has the Only expired checkbox and, for 3PL companies, a Client filter. See Expiry report.
  • Analytics > Inventory > Inventory detail: stock by bin, license plate, lot, serial and expiry.
  • Analytics > Inventory > Lot trace & recall: a lot's receipts, stock on hand with expiry, and shipments.

Related settings

All in Setup > System > Configuration; only administrators can change them.

GroupSettingDefaultWhat it does
Business > ProductsAllow Expired ProductNoAllows Receiving and adjusting in stock that has already expired.
Business > ProductsExpiry FormatyyyyMMddThe format of expiry dates.
Business > ProductsAllow Attribute ChangeNoLets tracking choices change while the product is on open orders (never while it has stock).
Business > Receiving > OperationsExpiry Allowance0Days of shelf life a Delivery must have left. A vendor's Expiry allowance or the product's Inbound allowance replaces it.
Business > Returns > OperationsExpiry Allowance0The same for customer Returns. A customer's Inbound expiry allowance or the product's Inbound allowance replaces it.
Business > Fulfillment > AllocationExpiry Allowance45Days of shelf life stock must have left to be allocated to an order. A customer's Outbound expiry allowance or the product's Outbound allowance replaces it.
Business > Fulfillment > AllocationExpiry Allocation PrecedenceNoPrecedenceNoPrecedence, OldestFirst (FEFO) or NewestFirst.
Business > Production > AllocationExpiry Allowance / Expiry Allocation Precedence145 / OldestFirstThe same choices for Production orders.
Business > License PlatesAllow Multiple ExpiriesNoWhether one license plate may hold several expiry dates.

Troubleshooting

Message or symptomCauseWhat to do
Cannot receive product. Product expiry allowance is [N] daysThe Delivery expires sooner than the inbound allowance allows.Refuse the Delivery, or lower the allowance on the product, the vendor or the company setting.
Cannot add expired product [SKU]The date entered is already past.Check the date; to accept expired stock, an administrator turns on Allow Expired Product.
An order is not allocated although stock is on handThe stock is within the outbound allowance (default 45 days).Check the expiry dates in Analytics > Inventory > Expiry, and the allowance on the product, the customer or the company setting.
Bin [bin] cannot contain product with multiple expiry datesThe bin already holds another date of the product.Use another bin, or allow multiple expiries on the bin or its zone.
Invalid Expiry [x], [y] expectedThe picker entered a different date than the one allocated.Pick the stock with the allocated date.

Related pages

Was this page helpful?