Stock > Inquiries > Stock > Stock by date 

The objective of this function is the presentation on the screen of the report for the stock situation on a given reference date. This inquiry is single-site and single-product.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

 

Header

Presentation

The header information makes it possible to specify the principal selection criteria for the inquiry used, here the site, the product and the reference date.

The actual stock

This display summarizes the stock report at the inquiry date, notably the internal physical stock detailed by status, stock waiting put-away, loaned stock, and stock at the sub-contractor etc.

 

Close

 

Fields

The following fields are present on this tab :

Block number 1

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.

Enter the reference of the product for which the stock needs to be inquired.

Block number 2

  • Reference date (field REFPER)

Enter the reference date used for calculating the expiration date of a lot in stock. This field displays today’s day by default. The availability of this field depends on the expiration management mode set on the product record.

Close

 

Tab Available Stock

Presentation

This table summarizes up to the reference date chosen and going back through time, the stock status for each date where there was at least one stock movement.

It presents the :

*  Physical stock (accepted stock)

* Stock under control

*  Rejected stock

* Total stock

 

Close

 

Fields

The following fields are present on this tab :

Current stock

  • Internal 'A' (field PHYSTO1)

 

  • Internal 'Q' (field CTLSTO1)

 

  • Internal 'R' (field REJSTO1)

 

 

Block number 2

  • Total internal stock (field INTSTO1)

 

  • Total stock pending put-away (field PLFSTO1)

 

  • Total loan stock (field BPRSTO1)

 

  • Total subcon. stock (field SCOSTO1)

 

  • Total stock (field TOTSTO1)

 

  • Total allocated (field ALLSTO1)

 

  • BP stock (field SCCLNDSTO)

 

Grid Detail stock situation

  • Description (field INTFLD)

 

  • Value (field VALFLD)

 

Grid Stock by date

  • Date (field DATREF)

 

 

  • On hand (field PHYSTO)

 

  • Control stock (field CTLSTO)

 

  • Rejected stock (field REJSTO)

 

  • Total stock (field TOTSTO)

 

Close

 

Menu Bar

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

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 sets of criteria by saving the codes. that can be subsequently recalled or deleted  .

 

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation