Stock > Stock counts > Stock counts 

This function is used when reporting a stock count for a site. Two types of stock counts can be accessed in Warehousing GX.
The stock count by product is used to count the product stock, in other words, the locations where the products are located at system level.

The stock count by address is used to count the stock for each delivery address.

A stock count by address blocks the addresses relating to the stock count on input and output. The stock count no. in process is recorded in the location record.

One or several counts are reported for a stock count and then entered in the system.

Matching operations between the entered stock and the logical stock can then be printed.

Based on the setup (flow control), a stock count by product can block the stock inputs and outputs for the products subject of the stock count.

See the documentation on stock counts.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Presentation

     

    Close

     

    Fields

    The following fields are present on this tab :

    Sequence assigned by the system to the inventory.

    • Reference (field REF)

    Document reference.

    • Status (field SKHSTA)

     

    • Closed/settled (field CLODAT)

     

    • Creation origin (field ORICRE)

     

    Close

     

    Tab Header

    Presentation

    By address/product
    The stock count type specifies whether the stock count is by product: in this case, the product codes of the products to count must be selected. If the stock count is by address: in this case, the addresses need to be selected. These selections can be performed via the Selection tab.

    Serial no. entry
    In this case, on the occasion of a stock count by product managed with serial no., the serial nos. of each stock unit of the product will need to be entered.
    Otherwise, even if the product is managed with serial nos., the serial nos. will not be requested when entering the stock counts by product.
    Not activated for address-type stock counts.

    WIP stock counts
    If this option is checked, those products with WIP will be taken into account in the stock count. Otherwise they will be left aside.

    Maximum container level (1...5)
    When entering the stock count, the products can be counted in a container level at the maximum. For instance, in case of level 5, the stock count will be entered in packing units for all the products and locations of the stock count. In the case where a product code does not have the maximum level, the system uses the immediately lower container level.

    Campaign
    For stock counts by product, it is possible to assign them to the current campaign. The campaign number must be entered then.
    In inquiry mode, the campaign number assigned to the stock count is displayed.

    Stock count
    Number of stock counts, irrespective of their statuses, created by the stock count.

    Close

     

    Fields

    The following fields are present on this tab :

    Type

    • Type (field TYP)

    Type of the inventory:

    - by address: inventory with respect to addresses defined by the user,

    · by product: inventory with respect to products defined by the user,

    Comments

    • field REM

    Comment field. Free entry.

    Options

    • Key in serial no (field SRNMGT)

    The management of the serial numbers is triggered on input.

    • Pending ctock count (field PDG)

    If it is checked, upon creation of the inventory by products or addresses, the entities will be used only if they do not have any pending movements.

    If it is not checked, the system takes into account the selected products/locations with or without pending movements.

    Maximum container level

    • field MAXLVL

    Maximum counting level.

    By default the counting unit mentioned by default by the system is less than or equal to the one specified in the inventory.

    Campaign

    Sequence assigned by the system to the inventory campaign.

    • Counts (field CPTNUM)

     

    Close

     

    Tab Selection

    Presentation

    This tab is used to select the criteria by product or by address.

    As long as there are no counts for the stock count, it is possible to add or delete selected records.

    The result of the selection is displayed in the "By address" tab if it is a stock count by address, or in the "By product" tab if it is a stock count by product.

    The Sel field is used to manage multi-criteria selections: for the value "and", enter the same identifier, otherwise increment the value.

    Examples of multi-criteria selections:

    1°) creation of a stock count by address for store RES, and for locations AA02, AA03, AA04.

    Sel

    Field

    Operand

    Value

    1

    Store (STO)

    Equal

    RES 

    1

    Address (ADD)

    Equal

    AA02

    2

    Address (ADD)

    Equal

    AA03

    3

    Address (ADD)

    Equal

    AA04

    2°) creation of a stock count by address for store RES, from aisle AC to AE.

    Sel

    Field

    Operand

    Value

    1

    Store (STO)

    Equal

    RES 

    1

    Address split (0)

    Higher than or equal to

    AC

    2

    Store (STO)

    Equal to

    RES 

    2

    Address split (0)

    Lower than or equal to

    AE

    Note: The Split address field corresponds to a field divided according to the address structure of the store and indexed for each structure.
    If the address structure of the store is Aisle on 2 Alpha, Row on 2 Numerical, the split address field is ADDCPN(0) for the aisle, and ADDCPN(1) for the row.

    3°) creation of a stock count for all the locations of the stores

    Sel

    Field

    Operand

    Value

    1

    Store (STO)

    Like

    *

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

    • Select (field SEL)

    Used to manage multi-criteria selections: for the value "and", enter the same identifier, otherwise increment the value.

    • Field (field TEXTE)

    Indicate a field from the table.

    • Operand (field OPD)

    Indicate the comparison operation:

    • The "indifferent" operator is used to obtain all records of an object.
    • The '* ?' operator is used to define wildcards.
    • Value (field VALEUR)

    Valueof the field.

    Close

     

    Tab By address

    Presentation

    This tab in inquiry mode only is used to view the "Address" records by stock count.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

     

    • Select (field SEL)

     

    • Stock objects (field NBR)

     

    • Status (field SKSSTA)

     

     

     

    Close

     

    Action icon

    Locations
    Previous page
    Following page
    Selection Numbers

     

    Close

     

    Tab By product

    Presentation

    This tab in inquiry mode only is used to view the "Address" records by stock count.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

     

    • Select (field SEL)

     

    • Addresses (field NBR)

     

    • Status (field SKISTA)

     

    Close

     

    Action icon

    Products
    Previous page
    Following page
    Selection Numbers

     

    Close

     

    Tab Counts

    Presentation

    This tab is used to display the stock counts carried out and their progress status.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

     

    • Reference (field SKCREF)

     

    • Status (field SKCSTA)

     

    • Number of lines (field NBRLIG)

     

    • Closed/settled (field CLODAT)

     

    • Without address (field WIOSLO)

     

     

    • Aisle (field AIS)

     

    • Rows (field ROW)

     

     

     

    Close

     

    Action icon

    Counts
    Previous page
    Following page

     

    Close

     

    Reports

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

     INVCOMPT : Counting list

     INVRAPCPT : Counting reconciliation

     INVRAPPRO : Count reconciliation/stock det

     INVRAPQTY : Count reconciliation/qty stock

    This can be changed using a different setup.

    Specific Buttons

    After entering the criteria, this button is used to display the errors along with the locations and selected products. It is then possible to modify the selection.

    This button is used to close the stock count and thus to normally end the stock count procedure.
    The system lists all the records of the stock count and compares them with the stock counts actually carried out. If all the products or locations have not been counted, the system lists the faulty records and suggests a partial closure of the stock count.

    • Stock count by product: the date of the last stock count is updated in the product header and the product is unblocked. The campaign is also updated if the stock count has been assigned to a campaign.
    • Stock count by address: the last stock count date is updated for locations. Locations are unblocked.

    This button is used to close a stock count, which closes all counts under way. This closure features an abnormal end to the stock count in case of error or premature end to the stock count.
    The last stock count date is thus not updated in the product record in case of a stock count by product. The product is no longer being the subject of a stock count.
    In the case of a stock count by address, the last stock count date is thus not updated for locations. Locations are unblocked.Menu BarFunctions/CountThis function is used to directly request a count for the stock count under progress.

    Menu Bar

    Functions / Count

    Functions/Log

    This function is used to display the log on the stock count creation.

    Functions/Adjustments

    This function is used to display the stock count adjustments carried out during the stock count.

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    The selection does not match any record.

    The stock count cannot be created because the selection set up does not match any data relating to the site.

    Location/Product already in stock count XXX.

    It is not possible to assign a product/location to two stock counts under progress.

    Locations with WIP.

    The stock count type created does not have any WIP and the selection concerns products/locations with WIP.

    Tables used

    SEEREFERTTO Refer to documentation Implementation