Stock >  Inquiries >  Stock >  Stock by lots  

Display all Hide all

The objective of this function is the presentation on the screen of the report for the stock by product and for a site, detailed by lot.

Prerequisite

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 possible to choose a site for the stock inquiry per product for this site. If no product is entered, the inquiry displays the stock status for all the sites for which the product is defined.

Product : it is mandatory to enter a product code.

It is possible to specify a sort criteria for the presentation of lines reproduced.

By lot: lot number in alphabetic order

*FIFO

*FEFO

It is possible to request the presentation in this display of the lots for which the stock is zero: by default, these lots are not suggested.

It is possible to filter the internal stock, the stock waiting put away, the loan stock and the sub contractor stock.

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 reference of the product for which the stock needs to be inquired.

  • field ITMDES1

 

Block number 2

  • Stock internal (field LOCCAT001)

Takes into account the internal locations.

  • Stock pending put-away (field LOCCAT002)

Takes into account the locations pending put-away.

  • Loan stock (field LOCCAT003)

Takes into account the customer locations.

  • Subcon. stock (field LOCCAT004)

Takes into account the sub-contracting locations.

Block number 3

  • Zero lots (field ZERLOT)

 

  • Lots not null (field NOTZERLOT)

Tick so that the null lots not purged can be displayed.

Block number 4

  • Sort (field CRITRI)

The choix of classification is used to sort the selected product's lots in stock in an order chosen among:

  • Total (field CUMFLG)

This checkbox must be ticked to display to cumulated total at the bottom of the page.

Close

 

Tab Stock by Lot

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 summary line for its stock status for each lot by specifying notably:

*The major and minor versions, when they are managed.

*The physical stock of the lot, as well as the breakdown of the quantities validated, under control or rejected.

*The quantity allocated to the lot

*The expiry date of the lot if appropriate

*The number of the document that created the lot

Close

 

Fields

The following fields are present on this tab :

Grid

 

  • Lot (field LOT)

 

  • Sublot (field SLO)

 

  • Major version (field ECCVALMAJ)

 

  • Minor version (field ECCVALMIN)

 

 

  • Accepted qty. (field AAACUMQTY)

 

  • Control qty. (field QQQCUMQTY)

 

  • Rejected qty. (field RRRCUMQTY)

 

  • Total qty. (field TOTCUMQTY)

 

  • Allocated qty. (field ALLCUMQTY)

 

  • Active accepted qty. (field AAACUMQTP)

 

  • Active QC quantity (field QQQCUMQTP)

 

  • Active rejected qty. (field RRRCUMQTP)

 

  • Total active qty. (field TOTCUMQTP)

 

  • Active allocated qty. (field ALLCUMQTP)

 

  • Lot creation (field LOTCREDAT)

 

  • Expiration (field SHLDAT)

 

  • UBD (field DLUDAT)

The use-by date (UBD) is the target date for issuing a product.
It cannot be modified. 
UBD = Reference expiry date + UBD lead time.

  • Recontrol (field NEWLTIDAT)

La date de recontrôle est associée à un lot en stock. Elle indique une date d'analyse de la marchandise, une fois le délai de péremption atteint.

SEEINFO Warning The new control date cannot go beyond the limit date of lot use.

  • Potency (field POT)

 

  • IU potency (field ACT)

 

  • Supplier lot (field BPSLOT)

 

 

  • Entry (field VCRNUM)

 

  • Entry line no. (field VCRLIN)

 

  • Last receipt (field LASRCPDAT)

 

  • Last issue date (field LASISSDAT)

 

  • Last count date (field LASCUNDAT)

 

  • field USRFLD1

 

  • field USRFLD2

 

  • field USRFLD3

 

  • field USRFLD4

 

Close

 

Action icon

Detailed Stock
Stock Transactions
Stock by Unit
Stock by Status
Serial Numbers
Traceability

 

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 if the inquiry should display aggregated lots.

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 customization 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 save one or several sets of criteria by recording [Memo] codes that can be called later on [Call memo] button or deleted [Delete memo] button.

This inquiry presents by stock status or all statuses taken together, the stock report in stock units and packing units.

This inquiry presents the stock report broken down by stock status and sub-status.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation