Stock > Inquiries > Movements > Stock transactions 

Use this function to view the history of stock movements performed for a product. This inquiry is single-site or multi-site, single-lot or multi-lot.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

    Enter the main selection criteria. To access additional criteria, click Criteria from the actions panel.

    By default, the inquiry only displays the 'stock' movements, in other words, those that generate actual stock receipts and issues. To view the 'internal' movements generated within a storage site (change of status, location or unit, and those changes based on license plate numbers), select Internal in the additional selection criteria

    Close

     

    Fields

    The following fields are present on this tab :

    Selection

    Enter a site if you want to restrict the inquiry to the movements by product for a given site.

    If you do not enter a site, the inquiry displays the movements for all the sites where the product is defined.

    Enter a warehouse reference if you want to restrict the inquiry to the movements by product for a given warehouse.

    This field being available is subject to the WRH activity code .

    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.

    • Starting serial number (field SERNUMSTR)

    Enter the initial serial number, selection start range.

    • Ending serial number (field SERNUMEND)

    Enter the end serial number of the selection.

    • Inquiry history (field INQLTI)

    Specify in number of days the inquiry horizon of the stock movements, starting from the current date.

    This field is populated by default with the value of the INQMVSLTI - Transaction inquiry history parameter (STO chapter, MIS group).


    • Sort order (field SRTCOD)

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

    Close

     

    Tab Movements / products

    Presentation

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

    Based on the chosen selection criteria, the table recovers by default a line by stock movement performed using the following main information:

    • The movement site
    • The movement lot, sub lot, serial number, major and minor version numbers, the quantity of the movement and its status, location and license plate number.
      For products using the Global receipt & issue serial number management mode, the start and end serial numbers are specified: each stock movement corresponds to a serial number sequence.
    • The lot expiration date, if needed
    • The transaction underlying the movement.
    • The supporting document number
    • The source document number.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

    • Allocation (field IPTDAT)

     

    • Lot (field LOT)

     

    • Sublot (field SLO)

     

    • Major version (field ECCVALMAJ)

     

    • Minor version (field ECCVALMIN)

     

    • Starting serial number (field SERNUM)

     

    • Ending serial number (field SERFIN)

     

    • Quantity (field QTYPCU)

     

     

    • STK quantity (field QTYSTU)

     

     

    • Status (field STA)

     

     

    • Location (field LOC)

     

     

    • Identifier 1 (field PALNUM)

     

    • Identifier 2 (field CTRNUM)

     

    • Stock before (field BEFSTO)

    When filtering the inquiry based on an entry type, the Stock before and Stock after are not entered since this information apply to all product movements and not just the ones linked to a single entry type, which would go against operational logic.

    • Stock after (field AFTSTO)

     

    • Analysis req. (field QLYCTLDEM)

     

    • Movement type (field TRSTYP)

    This field indicated the stock movement type performed for the product.
    When the movement relates to an action performed on a container, this movement is set to ‘License plate number change’.
    To display the type of action (‘License plate number assignment’ or ‘License plate number operations’), click the Actions icon against the line.

    • Movement description (field MVTDES)

     

     

     

    • Entry type (field VCRTYPTXT)

     

    • Entry (field VCRNUM)

     

    • Line no. (field VCRLIN)

     

    • Source document type (field VCRTYPORIT)

     

    • Original document (field VCRNUMORI)

     

    • Source document line (field VCRLINORI)

     

    • Supplier lot (field BPSLOT)

     

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

    • Active quantity (field ACTQTY)

     

    • Potency (field POT)

     

     

    • Original coef. (field PCUSTUORI)

     

     

    • Order amount (field AMTORD)

     

    • Movement value (field AMTVAL)

     

    • Order variance (field VARORD)

     

    • Movement variance (field VARVAL)

     

    • Order price (field PRIORD)

     

    • Valued price (field PRIVAL)

     

    • Cost source (field PRINAT)

     

    • Variance not absorbed (field AMTDEV)

     

    The setup determines if the analytical dimensions can be modified. They are initialized based on the setup of the default dimension.

    In creation mode, if no order line has been entered and the project code is modified, the analytical dimensions are reset based on the setup of default dimensions.

    In creation mode, as in modification mode, if an order line is entered and the project code is modified, the analytical dimensions are not reset.

     

    • Accounting date (field ACCDAT)

     

    • Accounting document (field NUMVCR)

     

     

    • Owner (field OWNER)

     

    • Intercompany (field BETCPY)

     

    • Creation user (field CREUSR)

     

    • Date created (field CREDAT)

     

    • Time (field CRETIM)

     

    Close

     

    Action icon

    Cost adjustment

    Click this action to view the detail of the various price adjustments that have taken place on the selected movement transaction, for the document concerned.
    This action is only active if at least one price adjustment exists for the movement transaction.

    Accounting Document

    Click this action to view the accounting document generated for the selected movement transaction if this is subject to an accounting interface.

    Stock by Lot
    Traceability
    Order price detail
    Valuation price detail
    Floor
    Source Document

    Click this action to access the source document, from which the movement originated.

     

    Close

     

    Specific actions

    Click this action to access additional selection criteria to the criteria entered in the inquiry header.

    Filter by document type: you can filter the movement transactions recovered for a document type (delivery, receipt, production notification, miscellaneous stock...), or even for a document number.
    By default, the inquiry displays the movements all document types considered.
    If you select the movements linked to an entry type, the Stock before and Stock after is not loaded in the Movements/Products tab since this stock information apply to all product movements and not just the ones linked to a single entry type (which would go against the operational logic).

    BP: you can refine the selection by filtering movements for a given BP.

    Formula: if the standard selection criteria are insufficient, you can set up an additional formula that must have the Stock selection type.

    Movement update, suspended movement:

    The inquiry displays by default the actually updated movements. You can choose to display the movements pending update, for example those created from the issue of a shortage material. The display of these two types of movement cannot be carried out simultaneously.

    In addition, a specific inquiry is available for suspended movements.

    ‘Stock’ movements / ‘Internal’ movements:

    • ‘Internal’ movements are movements generated within a storage site. These are changes of status, location or unit, but also changes by license plate numbers, which are also considered as internal changes.
    • 'Stock' movements generate an actual stock transfer. These movements represent stock receipts and issues. A stock adjustment following a stock count also represents a stock receipt/issue.

    By default, the inquiry only displays the 'stock' movements. If you modify this setup, you can view the 'internal' movements only, or view the 'stock' movements as well.

    Classification: various classification criteria are suggested, for example a classification by ascending or descending posting date of the movements, a classification by ascending or descending movement creation date.

    Serial number aggregation: when the serial numbers are managed for the products and the management mode is Receipt & issue, the inquiry displays by default, for a given movement, as many lines as there are serial numbers impacted by a movement. Select this check box to aggregate serial numbers and optimize the inquiry by reducing the number of displayed lines, so that only one line per movement is presented. When the serial management mode is Global receipt & issue, the setup of this check box is not used: the inquiry recovers one line per stock movement linked to a serial number range. The Starting serial number and Ending serial number fields define the relevant serial number range.

    Screen code: as a rule, inquiries can be set up. You can call upon customized inquiry screens using the screen code. You can use this customization, for instance, to choose what information should be displayed on the screen and in what order it should be positioned in the table.

    For more details, please refer to the Inquiry screens documentation.


    You can save the selection criteria under a memo code in order to recall them later on.

    The STD memo code is a special code, which systematically applies when entering the inquiry.

    Specific actions

    Graphic / Transacted quantity

    This graphdisplays the received and issued quantities by period.

    Only movements selected in the inquiry are taken into account.

    The frequency, the date ranges and the number of periods can be modified.

    Graphic/Number of transactions

    This graph displays the history of the number of receipts and issues by period.

    Only movements selected in the inquiry are taken into account.

    The frequency, the date ranges and the number of periods can be modified.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation