Description

Returns orders at a POS location whose customer reservations have expired and whose items are ready to be returned to available stock. An order is considered expired when it has been in accepted or on-hold status without an active reservation record for longer than the configured expiry period. The expiry period is determined by the location's ResExpDays setting, or falls back to the system-wide ReservationExpiry setting (default 14 days).

Request Parameters

#	Name	Type	Required	Example	Description
1	LocationId	string	1	W01	POS location ID to check for expired reservations. Must be provided — passing NULL returns an empty result set.

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiGetExpiredReservations>
         <dem:LocationId>W01</dem:LocationId>
      </dem:pixiGetExpiredReservations>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Expired Reservations

One row per order with an expired reservation. Returns an empty result set if no expired reservations exist for the location.

#	Name	Type	Description
1	ordernr	int	pixi order number for which the reservation has expired.
2	CustRef	int	pixi customer reference number for the customer whose reservation has expired.

Additional Notes

An order is included in the results when ALL of the following conditions are met:
  - The order is at the specified LocationId.
  - The order status is ANG (accepted) or HAL (on hold).
  - No active Reservation record exists for any order line.
  - The number of days since the order date exceeds the expiry threshold.
  - All order items are location-specific (items without location-specific records are excluded).

Expiry threshold (in days):
  - If the reservation location linked to the POS location has a ResExpDays value set, that value is used.
  - Otherwise, the system setting ReservationExpiry is used (default: 14 days).

Passing NULL for LocationId returns an empty result set.