Stock > Inquiries > Stock > Detailed stock 

Use this function to view all the stock lines of a given product on a site.

For further information on the creation of stock lines in Sage X3, see the Stock lines documentation.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

    Enter the main selection criteria.

    You can choose to display only part of the defined stock using the following filters:

    • Internal stock
    • BP stock
    • Stock awaiting putaway
    • Loaned stock
    • Subcontract stock

    To access additional selection criteria, click Criteria from the Actions panel.

    Close

     

    Fields

    The following fields are present on this tab :

    Selections

    Renseignez obligatoirement le site. Il est initialisé par défaut avec le site associé à votre profil fonction.

     

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

    After entering the lot code, the product reference can be populated automatically if only one single product is linked to the specified lot code.

    • Lot (field LOTSEL)

    Reference of the lot number to be processed.

    Entering the lot is optional. When there is only one product for the specified lot number, you can directly enter the lot number to automatically populate the associated product code.
    If there is not any specified lot, the inquiry impacts all the lots of the product/site selection.For products managed with optional lots, select the Blank lot check box to filter stock lines with an empty lot number.

    • Blank lot (field LOTBLK)

    Select this check box to select stock lines with an empty lot number.

    • Major version (field ECCVALMAJ)

     

    This field is subject to theLPN - License plate no. management activity code.
    Enter a license plate number if you want to limit the inquiry to the products associated with a given license plate number.

    • Starting serial number (field SERNUMSTR)

    This is the product serial number.

    • Ending serial number (field SERNUMEND)

     

    Block number 2

    • Stock internal (field LOCCAT001)

    Select this check box to take internal locations into account.

    • BP stock (field LOCCAT005)

     

    • 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

    • Sort order (field SRTCOD)

    Select the classification criteria for the display of the returned lines.

    • Total (field CUMFLG)

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

    Close

     

    Tab Detailed Stock

    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, all the stock lines found for the product by specifying:

    • The stock quantity by line / lot / sub-lot / major version/ serial number / location / licence plate number / warehouse / status.
    • The line status
    • The sum of allocated quantities
    • The entry number that created the line

    A final summary line presents the total physical stock for the chosen selection.

    One stock line is displayed in red and italics to indicate the line is desynchronized, i.e. the quantity on this line is different from the number of recorded serial numbers. This can occur when the serial numbers of products are set to Global receipt & issue. In this case, as long as no Resynchronization processing has been run on this line, no stock count can be performed in Global processing: the stock count list is not created. Only a non-global processing can be run: the list is created but the desynchronized stock lines are ignored.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

    • Lot (field LOT)

     

    • Sublot (field SLO)

     

    • Major version (field ECCVALMAJ)

     

    • Serial number (field SERNUM)

     

     

    • Location (field LOC)

     

     

    • Loc. cat. (field LOCCAT)

     

    • Count in progress (field CUNLOKFLG)

     

     

    • Quantity (field QTYPCU)

     

    • PAC-STK conv. (field PCUSTUCOE)

     

     

    • STK quantity (field QTYSTU)

     

    • Stock status (field STA)

     

    • Active quantity (field QTYSTUACT)

     

    • Potency (field POT)

     

    • IU potency (field ACT)

     

    • Total allocated (field CUMALLQTY)

     

    • Last receipt (field LASRCPDAT)

     

    • Last issue date (field LASISSDAT)

     

    • Identifier 1 (field PALNUM)

     

    • Identifier 2 (field CTRNUM)

     

    • Custom field 1 (field STOFLD1)

     

    • Custom field 2 (field STOFLD2)

     

    • Supplier lot (field BPSLOT)

     

    • Analysis request (field QLYCTLDEM)

     

    • Owner (field OWNER)

     

    • Expiration (field SHLDAT)

     

    • UBD (field DLUDAT)

     

    • Recontrol (field NEWLTIDAT)

     

    • Chronological stock (field STOCOU)

     

    Close

     

    Action icon

    Stock transactions

    Click this action to access the inquiry of stock movements for the selected product.

    Detailed Allocated

    Click this action to access the inquiry of detailed allocations for the selected product.

    In-transit Stock

    Click this action to access to the stock in transit inquiry, that is to say the stock for the selected product that is going to the site selected.

    Transferred Stock

    Click this action to access to the transferred stock inquiry, that is to say the stock for the selected product that is about to leave the selected site.

    Stock by Lot
    Traceability
    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.

     

    Close

     

    Specific Actions

    Click this action to access the additional selection criteria with respect to the criteria entered on the inquiry header.

    Ranking: select the order in which the stock lines are presented:

    • By lot number
    • By location code
    • In the alphabetic order of statuses
    • By unit.

    Serial number aggregation: this check box is useful for products which serial numbers are managed in Receipt/issue. In this case, each serial number makes up a stock line. If you select this check box, the inquiry presents aggregated stock lines for the serial numbers in order to reduce the volume of lines displayed.

    Screen code: as a rule, inquiries can be set up. You can call customized inquiry screens using the screen code. You can use this customization to choose which piece of information you want to display on the screen and in what order it should be positioned in the grid.
    For further information, see the documentation on Inquiry screens.

    You can save one or many sets of criteria by recording Memo codes that can be called later on by clicking Call memo or deleted by clicking Delete memo.

    Click this action to access the stock by unit inquiry: this inquiry presents by stock status or all statuses together, the stock report in stock units and packing units.

    Click this action to access the stock by status inquiry. 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