This function is used to display the stock status of the product-warehouses of a site.   

It displays, by warehouse:

  • the list of products with an available stock inferior to the reorder threshold defined in the warehouse record,
  • the missing quantity,
  • the supplier warehouse defined in the warehouse record.

The available stock corresponds to the warehouse stock, with the status A or Q - (allocated stock + shortage quantity for this warehouse).

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

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

    Close

     

    Fields

    The following fields are present on this tab :

    Close

     

    Tab Product-whs avail.

    Presentation

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

    By default, the table returns a line reporting the stock status of each selected warehouse or product, specifying in particular:

      The physical stock of the product.

    *  Its allocated stock.

    *  The suspended issues.

    *  Its available stock (stock of the warehouse in A and in Q - [detailed allocated stock + shortage quantity for this warehouse])

    Close

     

    Fields

    The following fields are present on this tab :

    Close

     

    Action icon

    Stock by Lot

    Click this action to access the inquiry of Stocks by lot for the selected product.

    Detailed stock

    Click this action to access the inquiry of Detailed stock for the selected product.

    Stock transactions

    Click this action to access the inquiry of Stock transactions by product.

    Detailed allocated

    Click this action to access the inquiry of Detailed allocations for the selected product.

    Global allocated

    Click this action to access the inquiry of Detailed allocations for the selected product.

    Shortage

    Click this action to access the inquiry of Stock shortages for the selected product.
    This action is available if allocations resulted in shortages.

    In-transit stock
    Transferred stock

    This action is available if the product is the object of an inter-site transfer.

    Loan stock

    Click this action to access the inquiry of Loan stock for the selected product.

    Available Stock

    Click this action to access the inquiry of Available stock for the selected product.

    Stock by Unit

    Click this action to view the stock situation in stock unit and packaging unit, by stock status, or for all status.

    Stock by Status

    Click this action to view the stock of the product by status.

    Stock Management Data

    Click this action to display all the data relative to the product stock management.

     

    Close

     

    Specific Buttons

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

    * enter criteria by range:

    - products
    - product categories
    - buyer codes
    - product lines
    - statistical groups
    - search key
    - EAN code         

    * enter a calculation formula, of the "Stock selection" type, and only using the following tables: ITMMASTER (master product), ITMFACILIT (site product) and ITMWRH (product-warehouse). (see  Calculation formula documentation),

    * specify if null stocks must be ignored and if "Q statuses and pending in available stock" must be taken into account.

    Sorting and display criteria are also available, and a screen code can be added.

    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 personalization is used notably, to choose what information should be shown on the screen and in what order it should be positioned in the table. It is possible to save one or more sets of criteria by saving the codes.   that can be subsequently recalled  or deleted  .

     When the inquiry function is used, the parameters stored with the STD code are recalled by default if they exist.

    Menu Bar

    Requirements / Requirements not allocated

    This menu option focuses toward the inquiry, requirements not allocated for the product for one or more sites concerned by the inquiry.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation