Use this function to display the stock situation for a given group of products and site.

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 mandatory to enter a site.

Product: it is possible to enter a range of products. If no product is entered, the inquiry displays the stock situation for all the products for the site.

Quantity selection: it is possible to display the stock in STK (stock unit) quantity or in active quantity (in this case, the products managed in 'potency' or international units are displayed in active quantity and the others in STK quantity).

Selections

Stock 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

Sort order (field SRTKEY)

Select the sort criteria to be applied to the display.
Quantity selection (field QTYTYP)

Select the quantity type for which you want to display the stock.

  • By default, it corresponds to the physical quantity.
  • For products managed in stock with a ‘potency’ expressed in percentage, you can also request the active quantity to be displayed.
Note For products managed in stock with a ‘potency’, the Available stock is always displayed as an active quantity, irrespective of the selected quantity type.

Tab Stock by product

The columns of this grid depend on the setup of the selected screen code.

By default the table reproduces for the chosen product, a summary line for its stock status for the site selected specifying

 Bullet point  The physical stock of the product,

  Bullet point Its stock in quality control and rejected,

  Bullet point Its available stock,

   Bullet point Its allocated stock.

Grid

Product (field ITMREF)
Description (field ITMDES1)
Description 1 (field DES1AXX)
STK (field STU)
Quantity type (field QTYTYP)
Internal 'A' (field PHYSTO)
Internal 'Q' (field CTLSTO)
Internal 'R' (field REJSTO)
Total internal stock (field TOTSTO)
Stock pending put-away 'A' (field PLFPHYSTO)
Stock pending put-away 'Q' (field PLFCTLSTO)
Stock pending put-away 'R' (field PLFREJSTO)
Total stock pending put-away (field PLFSTO)
Loan stock 'A' (field BPRPHYSTO)
Loan stock 'Q' (field BPRCTLSTO)
Loan stock 'R' (field BPRREJSTO)
Total loan stock (field BPRSTO)
Subcon. 'A' (field SCOPHYSTO)
Subcon. 'Q' (field SCOCTLSTO)
Subcon. 'R' (field SCOREJSTO)
Total subcon. stock (field SCOSTO)
BP stock (field SCCLNDSTO)
Int. allocated 'A' (field PHYALL)
Int. allocated 'Q' (field CTLALL)
Int. allocated 'R' (field REJALL)
Alloc. subcon. 'A' (field SCOPHYALL)
Alloc. subcon. 'Q' (field SCOCTLALL)
Alloc. subcon. 'R' (field SCOREJALL)
Total allocated (field ALLSTO)
BP stock allocated (field SCCALL)
Detail shortage (field DETSHT)
Global allocated (field GLOALL)
Global shortage (field GLOSHT)
Available stock (field AVASTO)
On sales orders (field SALSTO)
On order (field ORDSTO)
Pending issues (field WAISTO)
In-transit stock (field TRFSTO)
Transferred stock (field TRASTO)
Category (field TCLCOD)
Product line (field CFGLIN)
Buyer (field BUY)
Search key (field SEAKEY)
field TSICOD1
field TSICOD2
field TSICOD3
field TSICOD4
field TSICOD5
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.

Product

Criteria

Click this action to access the additional selection criteria with respect to the criteria entered in the inquiry header.
You can specify:

  • Criteria by range:
    • Products
    • Product categories
    • Buyer codes
    • Product lines
    • Statistical groups
    • Search key
    • EAN code
  • A calculation formula of the 'Stock selection' type: It must only apply to tables ITMMASTER (master product) and ITMFACILIT (product-site).
    Please refer to the Calculation formula documentation.
  • A screen code: as a rule, inquiries can be set up. You can use this customization feature to specify what information should be displayed and how to display it in the table. You can call upon customized inquiry screens using the screen code.
    Please see the Inquiry screens documentation.

You can save the selection criteria under a memo code in order to recall them later on.
The STD memo code is specific since it is the one that is systematically applied upon entering the inquiry.

Click this action to display the requirements that have not been allocated for the selected product, and for the relevant site(s).

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation