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
Refer to documentation Implementation
Screen management
Header
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
Selection
Site (field FCY) |
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. |
Warehouse (field WRH) |
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 . |
Product (field ITMREF) |
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. |
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. |
Tab Movements / products
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.
Grid
Site (field STOFCY) |
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) |
PAC (field PCU) |
STK quantity (field QTYSTU) |
STK (field STU) |
Status (field STA) |
Warehouse (field WRH) |
Location (field LOC) |
License plate number (field LPNNUM) |
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. |
Movement description (field MVTDES) |
Project (field PJT) |
BP (field BPRNUM) |
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. |
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. Warning The new control date cannot go beyond the limit date of lot use. |
Active quantity (field ACTQTY) |
Potency (field POT) |
Original PAC (field PCUORI) |
Original coef. (field PCUSTUORI) |
Currency (field ACCCUR) |
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) |
field CCE1 |
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. |
Stock movement group (field TRSFAM) |
Accounting date (field ACCDAT) |
Accounting document (field NUMVCR) |
Entry type (field GTE) |
Owner (field OWNER) |
Intercompany (field BETCPY) |
Creation user (field CREUSR) |
Date created (field CREDAT) |
Time (field CRETIM) |
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. |
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. |
Specific actions
Criteria |
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. 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:
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
This graph displays 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. |
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. |