Stock History
This function displays the evolution in number, quantity and transaction amounts by period.
Prerequisite
Refer to documentation Implementation
Screen management
Header
The header information is used to specify the main selection criteria for the inquiry used.
Site: It is mandatory to enter a site.
Product: it is mandatory to enter a product code.
Start date / end date / number of periods : by default the inquiry on the history proposes the last twelve months counting from today's date. It is possible to choose the end date for the inquiry and the inquiry horizon up to this date.
A maximum horizon of 24 months can be displayed.
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 Stock History
The columns displayed in this grid represent the chosen horizon. The lines present in this grid depend on the selection criteria entered.
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.
|
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, 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) |
Menu Bar
Menu Bar
This graph displays the history of the received and issued quantities by period. |
This graph displays the history of the received and issued amounts by period. |
This graph displays the history of the number of receipts and issues by period. |