Stock >  Inquiries >  Stock >  Stock by product  

Display all Hide all

The objective of this function is the presentation on the screen of the stock for a group of products and for a site.

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 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 status for all the products for the site.

Quantity choice: 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).

Close

 

Fields

The following fields are present on this tab :

Selections

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.

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

Enter the selection end product number.

Block number 2

  • Sort order (field SRTKEY)

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

This choice only concerns products that are potency managed or managed with international units.

- Quantity in stock unit Choice: all products are displayed in stock unit.

- Active quantity choice: products that are potency managed or managed with international units will be displayed in active units and other products will be displayed in stock unit.

Close

 

Tab Stock by product

Presentation

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

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

    The physical stock of the product,

  *  Its stock in quality control and rejected,

  *  Its available stock,

   *Its allocated stock.

Close

 

Fields

The following fields are present on this tab :

Grid

 
  • Description (field ITMDES1)

 
  • Description 1 (field DES1AXX)

 

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

 

 

 

 
  • Search key (field SEAKEY)

 

 

 

 

 

 

Close

 

Action icon

Stock by Lot

This button is used to access the stock inquiry by lot for the selected product.

Detailed Stock

This button is used to access the detailed stock inquiry for the selected product.

Stock Transactions

This button is used to access the stock movements inquiry for the selected product.

Detailed Allocated

This button is used to access the detailed stock allocations inquiry for the selected product.

Global Allocated

This button is used to access the detailed stock allocations inquiry for the selected product.

Shortage

This button is available if allocations resulted in shortages.
This button is used to access the missing stock inquiry for the selected product.

In-transit Stock
Transferred Stock

The button is available if the product is the object of an inter-site transfer.

BP Stock

This button is used to access the Loaned stock inquiry for the selected product.

Available to Promise

This button is used to access the Available stock inquiry for the selected product.

Stock by Unit

This button is used to open the window of stock inquiry by unit.

Stock by Status

This button is used to open the window of stock inquiry by unit.

Stock Management Data

This button opens a window displaying all the data relative to the product stock management.

 

Close

 

Menu Bar

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

* - Categories,

* - Product categories,

* - Buyer codes,

* - Product lines,

* - Statistical groups,

* - Search key,

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

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 the information is shown in the table. It is possible to memorize one or more sets of criteria by saving the codes   that can be subsequently recalled  or deleted  .

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