The objective of this function is the "dormant" stock inquiry, that is to say the stock that has not moved since an entered date. This inquiry is multi site and multi product.

Prerequisite

See also Refer to documentation Implementation

Screen management

 

Header

The header information is used to specify the principal selection criteria for the inquiry used:

Site: the stock site on which the inquiry will be carried out

Date : selection of products that have not had a movement since this date. By default the system proposes an inquiry on a horizon for one year up to today's date. This horizon is modifiable.

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.

Block number 2

Inactive start date (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.
field FIL0
Physical stock empty (field STONUL)

Tab Inactive Inventory

As a function of the selection criteria entered, the system searches all the products for those where the last issue date, last receipt date or last stock count date is before the inquiry date, plus all products that have never has a movement at all.

Grid

Site (field STOFCY)
Product (field ITMREF)
Description 1 (field ITMDES1)
Last receipt (field LASRCPDAT)
Last issue date (field LASISSDAT)
Last count D (field LASCUNDAT)
STK (field STU)
Total internal stock (field PHYSTO)
Total stock pending put-away (field PLFSTO)
Total loan stock (field BPRSTO)
Total subcon. stock (field SCOSTO)
Total allocated (field ALLSTO)
Detail shortage (field DETSHT)
Global allocated (field GLOALL)
Global shortage (field GLOSHT)
In-transit stock (field TRFSTO)
Transferred stock (field TRASTO)
On order/manufacturing (field ORDSTO)
BP stock (field SCCLNDSTO)
On sales orders (field SALSTO)
Pending issues (field WAISTO)
Stock Management Data

Used to inquire the management data.
Stock by Lot

Used to inquire the stock by lot.
Stock by Unit

Used to inquire the stock by unit.
Stock by Status

Used to inquire the stock by status.
Product

Criteria

This button is used to access the additional selection criteria for the screen.

Here the proposed additional functionalities are only a screen code.

Screen code : as a general rule, inquiries can be set up (for further details, see the Inquiry screens documentation. It is possible to call upon customized inquiry screens via the screen code. This personalization 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 memorize one or more screens by saving Memo that can be subsequently recalled or deleted  . 

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation