Stock >  Inquiries >  Stock >  Inactive stock  

Display all Hide all

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

SEEREFERTTO Refer to documentation Implementation

Screen management

 

Header

Presentation

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.

Close

 

Fields

The following fields are present on this tab :

Block number 1

Enter or select a storage site at which 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)

 

Close

 

Tab Inactive Inventory

Presentation

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.

Close

 

Fields

The following fields are present on this tab :

Grid

 

 
  • Description 1 (field ITMDES1)

 
  • Last receipt (field LASRCPDAT)

 
  • Last issue date (field LASISSDAT)

 
  • Last count D (field LASCUNDAT)

 

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

 

Close

 

Action icon

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.

 

Close

 

Menu Bar

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

SEEREFERTTO Refer to documentation Implementation