The objective of this function is the display on the screen of all the expired products for a given date. This inquiry is single site or multi-site, single product or multi-product.

Prerequisites

See also Refer to documentation Implementation

Screen management

Header

The header information is used to specify the main selection criteria for the inquiry used.

Site : it is possible to choose a site for the expired stock inquiry for this site. It is possible to specify that the inquiry should display the expired lots for all sites...

Product : It is possible to enter a range of products to be examined. If no range is entered, the inquiry will be made for all products at the selected site.

Expiration reference : date to which the expired lots are to be displayed. By default this date is loaded with the current date. 

Block number 1

Site (field FCY)

Enter or select the storage site where the selected product is active.

The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.
From product (field ITMREFSTR)

Enter the selection start product number. The product ranges limit the report to these products only.
To product (field ITMREFEND)

Enter the ending product number for the selection. Product ranges are used to restrict the report to these products only.

Block number 2

Reference (field TYPREF)
field REFPER

Reference date used as selection in the following inquiries:

  • Expired stock
    Lots that have an expiring date inferior to this reference date will be displayed in the inquiry.
  • Stock movements
    Movements that have a posting date inferior to this reference date will be selected for the inquiry.
  • Stock on a given date.
    The reference date corresponds the date for which the user wants to know the stock status.
Margin (days) (field MARPER)
Quantity type (field CRIQTY)

The selection quantity choice is used to change the quantity type displayed for the products managed with a title.

  • Physical quantiyty: the quantity displayed in STK are the physical quantities entered in the entries.
  • Active quantitiy: the quantities in STK displayed are the active quantities = physical quantity multiplied by the coefficient of active product (title).

Tab Obsolete stock

The columns present in this table depend on the setup of the chosen screen code.

The inquiry displays for the selected elements all the products / lots that are expired at the chosen reference date, with as default principal information:

  • The product, lot, sublot, major version number.
  • Its expiry date,
  • The lot quantity, broken down by stock status.
  • The original document number and type for the expired lot. 

Grid

Product (field ITMREF)
Description 1 (field ITMDES1)
Lot (field LOT)
Sublot (field SLO)
Major version (field ECCVALMAJ)
Storage site (field STOFCY)
Expiration (field SHLDAT)
UBD (field DLUDAT)
Recontrol (field NEWLTIDAT)
STK (field STU)
Total qty. (field LOTQTY)
Accepted qty. (field AAACUMQTY)
Control qty. (field QQQCUMQTY)
Rejected qty. (field RRRCUMQTY)
Total allocated (field CUMALLQTY)
Potency (field POT)
IU potency (field ACT)
Supplier (field BPSNUM)
Entry type (field VCRTYP)
Entry (field VCRNUM)
Line no. (field VCRLIN)
Supplier lot (field BPSLOT)
Last receipt (field LASRCPDAT)
Last issue date (field LASISSDAT)
Last count D (field LASCUNDAT)
Detailed stock
Stock Management Data
Stock by Unit
Stock by Status
Serial Numbers
Stock by Lot
Traceability
Product

Specific Buttons

Criteria

This button is used to access the additional selection criteria with respect to the criteria entered in the inquiry header.

Safety margin expiry: by default, this margin is not taken into account by the expired stock inquiry. Checking this box means asking to inquire the stock that will become obsolete within a specified time limit.

 Screen code: the inquiries can be set up in a general manner (for more detail, see the Inquiry screens documentation). It is possible to call upon customized inquiry screens via the screen code. This customization is used notably, to choose what information should be shown on the screen and in what order it should be positioned in the grid.

It is possible to save one or several sets of criteria by recording [Memo] codes that can be called later on [Call memo] button or deleted [Delete memo] button. 

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation