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
Presentation
Enter the main selection criteria:
Site : it is possible to choose a site for the movement transactions by product for this site. If no site is entered, the inquiry displays the movement transactions for all the sites for which the product is defined.
Product : the Product code is mandatory. It can be entered or loaded automatically after lot code entry. Entry of the Product code remains mandatory if there are multiple products for the entered lot code.
Lot : lot entry is optional. It is possible to directly enter a lot number in order to automatically load the associated Product code: this process is, however, only authorized if only one product exists for the specified lot number.
Inquiry time-scale
This field is loaded by default with the value of the general parameter INQMVSLTI - Transaction inquiry history (STO chapter, MIS group) and determines the inquiry horizon of the stock movements starting from the current date.
It is possible to specify a sort criteria for the presentation of the recovered lines:
By site
By lot
By location
By status
By unit
By descending posting dates
By ascending posting dates
By descending creation dates
By ascending creation dates
Additional criteria are available by clicking Criteria from the selection panel.
Close
Fields
The following fields are present on this tab :
Selection
|
Enter or select a storage site at which the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
|
|
|
Enter the reference of the product for which the stock needs to be inquired. |
|
Reference of the lot number to be processed. |
|
This is the product serial number. |
|
|
Block number 2
|
Enter the number of history days -starting from the current date- for the |
|
|
|
Sorting criteria for the list or the inquiry. |
Close
Tab Movements / products
Presentation
The columns present in this table depend on the setup of the chosen screen code.
By default the table reproduces for the selection criteria chosen, a line by stock movement transaction carried out with as the principal information :
The site of the movement
The lot for the movement transaction, the sub lot, the serial number range, the major and minor version numbers, its quantity and its status
The expiry date of the lot if appropriate
The transaction underlying the movement
The number of the supporting document for the movement
The number of the source document for the movement.
Close
Fields
The following fields are present on this tab :
Grid
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
When you filter the inquiry based on an entry type, the Stock before and the Stock after are not specified because these elements are related to all the product movements, not just to the ones linked to a single entry type (which would go against the operational logic).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The setup determines whether the analytical dimensions can be modified. These are initialized in compliance with the default dimension setup.
In creation mode, as in modification mode, if an order line has been entered and the project code is modified, analytical dimensions are not reset. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
Order price detail
Valuation price detail
Valuation price detail
Floor
Source Document
Close
Menu Bar
|
Click this action to access the additional selection criteria with respect to the criteria entered in the inquiry header. Filter by document type : it is possible to filter the movement transactions displayed for a document type (delivery, receipt, production notification, miscellaneous stock...), or even on the document number.
BP : the selection can be refined by filtering movements for a given BP. Formula : if the standard selection criteria are insufficient, it is possible to set up an additional formula that must be of the Stock selection type. Movement updated, suspended movements : By default the inquiry displays the movements actually updated. It is possible to choose to display the movements waiting to be updated, for example those arising from a material issue in a shortage. The display of these two types of movement cannot be carried out simultaneously. In addition, a specific inquiry is proposed for the suspended movements. "Stock" movements / "Internal" movements: The "internal" movements are the movements generated during the status changes, the stock count entry, as opposed to the "stock" movements that truly generate a shift in stocks. By default, the inquiry displays only the "stock" movements. It is possible to view "internal" movements only or with the "stock" movement. Classification : various classification criteria are proposed, notably a classification by ascending or descending posting date for the movements, a classification by ascending or descending movement creation date. Serial number aggregation : when the serial numbers are managed on the products, by default the inquiry retrieves as many lines as the serial numbers concerned by movements, for a given movement. When this option is selected, the serial numbers are aggregated to facilitate the inquiry by reducing the number of displayed lines, so that only one line per movement is presented. Screen code : as a general rule, the inquiries can be set up (for more details, see the Inquiry screens documentation). It is possible to call upon customized inquiry screens via the screen code. This customization is used notably, to choose what information should be shown on the screen and in what order it should be positioned in the grid. It is possible to save one or several sets of criteria by recording [Memo] codes that can be called later on [Call memo] button or deleted [Delete memo] button. |
Menu Bar
Graphic / Transacted quantity
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.
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.