Use this function to view the stock status by product, detailed by lot.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

In the header, enter the main selection criteria. Only the product code is mandatory.

You can also:

  • filter the internal stock, the stock awaiting put-away, the loan stock and the subcontract stock;
  • request to view the lots where the stock is null: by default, these lots are not suggested;
  • specify a sort criteria for the presentation of recovered lines:
    • by lot: lot number in alphabetic order
    • FIFO
    • FEFO
    • LIFO.

Selections

Site (field STOFCY)

Enter a site to view the stock of the product on this site.
If you do not enter a product, the inquiry displays the product stock situation for all the sites where the product is defined.
Product (field ITMREF)

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

This information is compulsory.

Description (field ITMDES1)

This is the description from the product record.

Block number 2

Stock internal (field LOCCAT001)

Select this check box to take internal locations into account.
Stock pending put-away (field LOCCAT002)

Select this check box to take into account locations awaiting put-away.
Loan stock (field LOCCAT003)

Select this check box to take customer locations into account.
Subcon. stock (field LOCCAT004)

Select this check box to take subcontract locations into account.

Block number 3

Zero lots (field ZERLOT)

Select this check box to display the lots where the stock is null. By default, these lots are not displayed.
Lots not null (field NOTZERLOT)

This check box is selected by default: the lots displayed are lots with stock.

Block number 4

  • By lot: classification by lot number in alphabetic order
  • FIFO tax rule
  • FEFO
  • LIFO
    • Sort (field CRITRI)

    Select a criteria for the classification of stock lines:
    Total (field CUMFLG)

    Select 'Yes' to display the total available stock at the bottom of the page.

    Tab Stock by lot

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

    By default, the table includes a summary line of the product stock status for each lot, and specifies:

    • 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 used to create the lot.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the information listed below will correspond to the first created lot, with or without filter on the site:

    • Lot creation date
    • Supplier lot
    • Supplier
    • Lot creation document
    • Document line no.

    Grid

    Storage site (field STOFCY)
    Lot (field LOT)
    Sublot (field SLO)
    Major version (field ECCVALMAJ)
    Minor version (field ECCVALMIN)
    STK (field STU)
    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)

    This field displays the creation date of the lot.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the displayed date corresponds to the date of the first created lot, with or without filter on the site.


    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)

    This field displays the supplier lot number.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the supplier lot number corresponds to the first created lot, with or without filter on the site:

    Supplier (field BPSNUM)

    This field displays the supplier reference.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the supplier reference corresponds to the first created lot, with or without filter on the site:

    Lot creation entry (field VCRNUM)

    This field displays the number of the lot creation document.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the document number corresponds to the first created lot, with or without filter on the site:

    Entry line no. (field VCRLIN)

    This field displays the line number of the lot creation document.

    Limit:

    The concept of site does not exist on the lot. If two stock receipts have the same lot number for two different sites, the document line number corresponds to the first created lot, with or without filter on the site.

    Last receipt (field LASRCPDAT)
    Last issue date (field LASISSDAT)
    Last count date (field LASCUNDAT)
    field USRFLD1
    field USRFLD2
    field USRFLD3
    field USRFLD4
    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.
    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.
    Serial Numbers

    This action is useful for products which serial numbers are managed in Global receipt/issue.
    In this case, one line can indeed correspond to multiple serial numbers. Click this action to display the list of serial numbers of the stock line.

    SEEINFO This information is updated in real-time. The serial numbers that were associated with this stock line but that have been issued are not displayed in this window.

    Traceability

    Click this action to inquire the Traceability of stock transactions.
    This action is only available when the product is set up for tracking stock transactions.

    Criteria

    Click this action to access the previously defined selection criteria, and additional criteria:

    • You can specify if you want to display aggregated lots.
    • 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.

    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.

    Stock by unit

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

    Stock by status

    Click this action to view the stock situation 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