Stock > Consumables > Inquiry 

This screen is used to inquire all of the movements, or a movement type, for a consumable or for all the consumables of the site.

The selection criteria are the following:

    • Consumable code
    • Depositor
    • Movement type
    • Movement origin

The stock status for the consumable is displayed.

Screen management

The search criteria are displayed in the higher part of the screen. These are the following:

  • Consumable code:if the field is blank, all of the consumable codes are considered.
  • Depositor: if the field is blank, all of the depositors of the site in progress are considered.
  • Movement type: Input, output or both.
  • Movement origin: Warehousing entity: expected input, administrative receipt, direct input, delivery order, round, or all entities included.

    • Once you specify the selection criteria, you can run the search. 

    The search results are displayed in a table.

    The ‘Mvt total’ at the bottom left of the screen corresponds to the sum of all input movements minus the sum of all output movements for the site in progress.

    The ‘Stock quantity’ at the bottom right of the screen corresponds to the consumable available stock for the site in progress. 

    Links to the entities are available by clicking the menu Actions on the table lines when the consumable movement is linked to a Warehousing entity.

    It is possible to get two reports from this screen:

      • Stock of the consumables, sorted by consumable or by quantity
      • Movements of the consumables, sorted by consumable or by date

    Header

    Presentation

    Selection criteria entry.

    Close

     

    Fields

    The following fields are present on this tab :

    Code of the consumable defined in the GEODE consumable table. 20 alphanumerical characters. Mandatory 

    • Movement type (field TYPMVT)

    Movement type. Two types of movement are possible for a consumable:

        • input (+)
        • output (-)

    Code representing the depositor. In logistics terms, the concept of depositor makes it possible to process separate flows or traffics within the same site. It encompasses the concept of order-issuing customer for the service providers.

    After the site, the depositor is the second access key to the Product, Input and Delivery Order files. For the location, the depositor code is entered if the location is allocated to the depositor or to the product, and if the location is single-depositor or single-product or if it is not empty.

    • Movement origin (field CSMORI)

    Specifies the entity of origin of the input or output movement of the consumable.

    For the inputs:

      • EI: an expected input exists for the pair (site;depositor).
      • Receipt: an administrative receipt exists for the current site.
      • DI: a direct input exists for the pair (site;depositor).

    For the output:

      • DO: a delivery order exists for the pair (site;depositor).
      • Round: a round exists for the current site.

    Direct: no link or control with the existing GEODE entities.The operator may enter what they like.

    Close

     

    Tab Transactions

    Presentation

    Search results displayed in a table, sorted by descending consumable movement number.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

    Consumable movement number.

    Code representing the depositor. In logistics terms, the concept of depositor makes it possible to process separate flows or traffics within the same site. It encompasses the concept of order-issuing customer for the service providers.

    After the site, the depositor is the second access key to the Product, Input and Delivery Order files. For the location, the depositor code is entered if the location is allocated to the depositor or to the product, and if the location is single-depositor or single-product or if it is not empty.

    Code of the consumable defined in the GEODE consumable table. 20 alphanumerical characters. Mandatory 

    • Quantity (field QTY)

     

    • Type (field TYPMVTSNS)

    Movement type. Two types of movement are possible for a consumable:

        • input (+)
        • output (-)

    The movement code identifies a flow.

    • Source (field CSMORI)

    Specifies the entity of origin of the input or output movement of the consumable.

    For the inputs:

      • EI: an expected input exists for the pair (site;depositor).
      • Receipt: an administrative receipt exists for the current site.
      • DI: a direct input exists for the pair (site;depositor).

    For the output:

      • DO: a delivery order exists for the pair (site;depositor).
      • Round: a round exists for the current site.

    Direct: no link or control with the existing GEODE entities.The operator may enter what they like.

    • Mvt origin no. (field REFORI)

    Number of the Geode entity with which the consumable movement is associated.

    Code of the supplier who must be defined in the supplier table.

    Code of the customer who must be defined in the customer table.

    Code identifying the carrier. This code must be defined in the carrier table.

    Usually, the transport mode corresponds to the notions of messaging, freight, express,... The transport mode is checked against the transport modes table.

    • Date created (field CREDAT)

     

    • Creation user (field OPENAM)

    Code of the operator having validated the movement.

    Mvt total

    • Input (field TOT1)

    Total quantity of consumable input, for the current site.

    • field TEXTE1

     

    • Output (field TOT2)

    Total quantity of consumable output, for the current site.

    • field TEXTE2

     

    • field TOT3

    Total quantity of consumable input on the site - total quantity of consumable output on the site.

    Consumable

    Code of the consumable defined in the GEODE consumable table. 20 alphanumerical characters. Mandatory 

    • Stock quantity (field STKQTY)

    Available consumable stock for the current site.

    Close

     

    Action icon

    Consumables
    EI
    Receipt
    Input
    DO
    Round

     

    Close

     

    Reports

    By default, the following reports are associated with this function :

     CSB : Consumable stock

     CSBMVT : Consumable movements

    This can be changed using a different setup.

    Specific Buttons

    Used to run the search according to the selection criteria specified in the screen header.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation