Use this function to select one by one the stock count lists generated for a session and to proceed with the counting of the selected stock. The selection panel displays all the stock count sessions and their respective lists.

This function is based on the setup of the stock count transactions: you can, for example, choose to perform a detailed stock count entry or an "aggregated" count entry for all the lots, sub lots, serial numbers of a product (see the Stock count transaction setup documentation).

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

General

When entering the stock count function, choose a stock count transaction amongst those set up. Using the stock count transaction setup, you can specify if you wish to perform:

  • a detail stock count,
  • an "aggregated' stock count for all lots, sub-lots, serial number of one product for instance.
    See the Stock count transaction setup documentation.

Depending on the setup, the stock count lines displayed on the stock count note can be grouped or not: a stock count line corresponds to a stock line or to a product line when the products in the selection with a null stock are concerned.

A stock count list is attached to a stock count session. Choose a list for a given session from the selection panel and proceed with the automated count of the selected stock.
Depending on the setup of the stock count session, the counting process can be performed as a multiple count. The operating rules are described hereafter.

A stock count list applies to a site and a session. It can have one of the following status:

To be counted: the list has been generated, but it has not yet been subject to a count or is only partially counted.

Partially validated or validated: the count of all or part of the stock count lines has been performed and validated. The stock count variance movements have been posted and thus the validated lines can no longer be modified. However, you can still add new stock count lines to the list.

*Closed: the count entry is finished, all the stock count lines have been validated. Click Closing to close the stock count list. Adding a new stock line is prohibited. In the case where stock count lines have not previously been validated at the moment of closing, these lines will be canceled: previously entered counts that have not been validated will be lost.

Count of a line

You can perform a count on a stock count line (entry of the counted quantity):

  • Directly from the note line (or grouping line if the stock count transaction includes grouped lines),
  • Or in details. Click Detail count from the Actions menu available on each grouping line: the details window opens.

You can thus enter the counted quantity for a line, either in packing units or in stock units.

To enter a null stock, select Yes in the Zero stock column of your given line. All the lines within the group are then marked zero stock in this case.

If the line displays a group of several stock count lines and the quantity counted for the group is different from the theoretical stock, the system opens a detailed count entry window where the detail of the stock count lines in the group is displayed. You can then distribute the counted quantity to the stock count lines. If the distribution of this counted quantity is different from the quantity entered at the level of the grouping, the system sends a warning.

In the detailed entry window, you can view all the lines corresponding to the group or list. Only non-validated lines can be modified.
Depending on the management mode of the product used, the fields Lot, Sub-lot, Major version (the non-discriminating minor version is not displayed as it is not recorded in the Stocks table), Serial number, Location and License plate number can be enabled in the detail window.

When the entry is performed on the note line or on the detailed entry window:

  • if the serial number management of the product is not global, the quantity on each stock count line is set to 1 and cannot be modified. Only the Zero stock check box can be used to affect the quantity. If a serial number does not physically exist, you can select Zero stock, create a new line and add the proper serial number.
  • if the serial number management of the product is global and if the counted quantity differs from the line quantity, the Serial number(s) to be counted window automatically opens. In this window you can enter the serial number(s) to be received or select serial number(s) to be issued.

Multiple counts

When the stock count session includes multiple counts (three counts total, one being final), additional columns are displayed on the stock count note. These are:

  • columns used to enter the counted quantities during the first and second counts.
    If a preloading is required at entry transaction level, the theoretical quantities of the stock are suggested by default in the first and second counts. They still can be modified. Once recorded, these quantities can no longer be modified (if necessary, you can still delete the last count by clicking Clear counts in the actions panel).
    When the quantity counted during the second count is the same as the quantity counted in the first count, then it is loaded automatically on the final count (it can still be modified). Once the quantity of the final count has been recorded, the status of the line automatically changes to: Counted.
  • a column named *. It displays the counts evolution:
      • +: the list is subject to a multiple count. The count has not started yet.
      • +1: the first count has started; +2: the second count has started; +3: the final count has started.
      • *1: the first count is compete; *2: the second count is complete. The line keeps the status: To be counted:
      • the field is blank once the three counts have been completed. The status of the line changes to: Counted.

Add a line

During the stock count, it is possible that a product, or a lot, sub-lot etc. may be found physically in stock whilst it is non-existent in the theoretic stock. The system allows the addition of the count for this stock using the Add a line to the stock count list. This line addition can be made at different levels :

*Either by the entry of a new line during the count entry in the detail window: on this new line, the system loads the stock characteristics that are common to the lines already displayed in the detail (characteristics that are display-only).

*Or by activating the Add Line button available in the Actions menu on a grouping line: the empty entry detail window opens, using the shortcut key F2 is used to carryout entries directly on the first field that can be entered: on this new line, the system loads the stock characteristics that are common to the lines that are grouped on this line.

*Or also by entry of a new line directly at the level of the group screen.

If you add a new line related to a nonexistent lot, a lot details window opens where you enter the characteristics of the new lot.

Valuation of the lines and the variance movements

The stock count lines are valued according to the rule assigned for issue valuations in the product record.

The variance movements for a stock count are valued according to the rule retained in the product valuation method: it is possible to set up a rule to value negative variance movements, as well as an alternative default and a rule to value positive variance movements, as well as an alternative default. (see the documentation related to the setup of the methods of product valuation).

Reports

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

  INVBOR : Stock count list

  INVBORA : Grouped stock count note

  INVBORCOM : Stock count complete form

  INVBORCOMA : Aggrg stck count complete form

  INVBORECA : Stock count variance form

  INVBORECAA : Agg stk count & variance form

  INVBORVAL : Valued stock form

  INVBORVALA : Valued agg stk count form

This can be changed using a different setup.

Specific actions

Release

Once a list is generated, the stock to be counted for this list is blocked, that is to say it is no longer possible to make any stock movements for the products concerned.

The stock is released:

  • either after total or partial validation of list count,
  • either by directly releasing the stock by clicking Release in the Actions panel to release the stock lines of the whole list, or using the Actions icon of the given group line to unlock the stock lines included in the group.  

It is thus possible to carryout movements on stock that is still in the process of stock count entry on the system. The potential stock count variance movements generated when validating the list are added to the stock journal before the movements used in the stock release (see the details of the stock movements creation in the Stock journal structure documentation).

Validation

Click this action to:

  • Validate the list, if all lines have been counted,
  • Perform a partial validation i.e. validate a group of lines, provided that all the lines for one given product have been counted.
The validated lines are no longer available for modification. On the other hand, the addition of lines still remains possible if all the lines in the list have been validated.

Validating a stock count line leads to the generation of any stock variance movements resulting from the count. These movements are written in the stock movements table (STOJOU) under a specific type and can be viewed using the stock movement inquiry by product or date. The display of movements of the Miscellaneous type must be enabled.

At the same time, the validation of a stock count line also leads to the following updates:

*The product: the ‘Stock count in process list’ is deleted and the Product blocked for stock count flag is disabled (if it has not already been done by a manual release of the stock count line).

*The product-site totals: the stock totals are updated, as well as the stock at last stock count. The date is calculated for the next stock count if that is required at the level of the stock count session.
When the stock count session if of the Global type and applies to Product-warehouses (managed by location), the date of the last stock count and the reference of the last list are updated on product-warehouses.

Period Closing

Click this action to close the session: the system then examines the stock count lines in the list. The counted or non counted stock count lines that are not validated are canceled after your confirmation.
Once a session is closed, no new line can be added.
If all the lists in a session are closed, the session also changes to the Closed status.

Bar menu

Errors messages

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

The product has a status not usable, expired or not renewed 

It is not possible to add to a stock count list the count for a product marked as not usable or expired or not renewed unless the session explicitly allows it.

Update impossible: the counted quantity is lower than the allocated quantity  

It is not possible to enter a stock count a quantity that is less that the total quantity allocated for this stock. If such a case arises, it is necessary to review the allocations before a count entry.

The total quantity has been modified. Confirmation?

This message occurs where a counted quantity is entered at the level of a group line and then, at the time of the detailed count entry for this line, the total quantities entered at the detail level is different to the quantity counted for the group.

Stock count list full

The total number of lines for a planned list at the level of the session has been reached, it is no longer possible to add a new line to the list.

Tables used

SEEREFERTTO Refer to documentation Implementation