Refer to documentation Implementation
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. |
| 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. |
| Select this check box to select stock lines with an empty lot number. |
| Enter the initial serial number, selection start range. |
| Enter the end serial number of the selection. |
| 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). |
| Select the classification criteria for the display of the returned lines. |
Close
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:
Close
Fields
The following fields are present on this tab :
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
| 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. |
|   |
|   |
| This field indicated the stock movement type performed for the product. |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
| The use-by date (UBD) is the target date for issuing a product. |
| 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. |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
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. |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
Close
Action icon
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.
Click this action to view the accounting document generated for the selected movement transaction if this is subject to an accounting interface.
Click this action to access the source document, from which the movement originated.
Close
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. |
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.
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.