Stock > Inquiries > Stock > Obsolete stock 

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

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

    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. 

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    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.

    Enter the selection start product number. The product ranges limit the report to these products only.

    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).

    Close

     

    Tab Obsolete stock

    Presentation

    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. 

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

    • Description 1 (field ITMDES1)

     

    • Lot (field LOT)

     

    • Sublot (field SLO)

     

    • Major version (field ECCVALMAJ)

     

     

    • Expiration (field SHLDAT)

     

    • UBD (field DLUDAT)

     

    • Recontrol (field NEWLTIDAT)

     

     

    • 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)

     

     

    • 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)

     

    Close

     

    Action icon

    Detailed stock
    Stock Management Data
    Stock by Unit
    Stock by Status
    Serial Numbers
    Stock by Lot
    Traceability
    Product

     

    Close

     

    Specific Buttons

    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

    SEEREFERTTO Refer to documentation Implementation