The Stock count function is based on a set of stock count transactions. Each transaction is used to construct the count entry screen that is developed to meet the requirements at several levels of the grouping of the lines to be counted.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

The setup of the stock count transactions contains a header, for the transaction code, an optional access code for the transaction and a status (active/inactive) and two tabs.

Stock count transaction

Transaction (field SRTNUM)

Code used to identify the transaction set up.

The setup of the entry transactions enables the user to fully set up the entry screens associated with a document (quote, invoice order, request for quotes etc.) or with a stock transaction type (receipt, issue etc.).

For each document or stock transaction type, it is possible to define as many entry transactions as necessary, each one being identified by a code.

Each transaction is used to define, both for fields located on the document header and fields entered in the lines, whether they must be:

  • Entered
  • Only displayed
  • Or hidden

Upon validation of this setup, dedicated entry screens are created, and then can be used by any user having been granted rights on the access code defined on this setup header.

  • If a given user has the right to use several transactions of a given type, the choice is presented to the user when entering the function.
  • If the user is only authorized one transaction, this transaction is automatically taken into account when entering the function.
Description (field DESAXX)

Transaction description.
Active (field ENAFLG)

Use this field to activate or deactivate a transaction.
Inactive transactions are not displayed in the transaction selection window.
Access code (field ACSCOD)

This access code is used to restrict access to data by user or group of users.
If this field is entered, only users with this access code in their profile can use this transaction.
If several transactions are available, you can choose the transaction you want to use to open the function. If only one transaction is available, there is no selection to be made: the default entry screen opens directly.
Group (field GFY)

Tab General

This tab is covers the accounting information (automatic journal code and analytical dimensions for the transfer to accounting of the stock count variance movements).

Entry

Transaction group (field TRSFAM)

Movement group, initialized by the movement group of the transaction being used.
This statistical information is recorded in the stock journal when saving the receipt/disposal movements. This movement group comes from the miscellaneous table number 9. The value given in the transaction setup corresponds to a default value that can/cannot be visualized and/or modified according to the transaction setup (entered, displayed, hidden field).

Statistical information used in the stock transactions associated with the shipment. This value is fixed if the original document does not reference a movement group. Otherwise, the movement group of the document at the origin of the quality control is suggested in priority.
Movement description (field MVTDESCOD)

Specify, for this transaction, if the Movement description field must be:

Hidden

The field is not displayed.

Displayed

The field is displayed but cannot be entered.

Entered

The field is displayed and can be entered.
field MVTDESTXT

Description of the stock count variance movement.
Allocation date (field IPTDATCOD)

Specify, for this transaction, if the Allocation date field must be:

Hidden

The field is not displayed.

Displayed

The field is displayed but cannot be entered.

Entered

The field is displayed and can be entered.
Count manager(s) entry (field CTGUSRFLG)

Specify, for this transaction, if the Count manager field (and the Count manager 1 and Count manager 2 fields in multiple counts) must be:

Hidden

The field is not displayed.

Displayed

The field is displayed but cannot be entered.

Entered

The field is displayed and can be entered.

Financials

Auto journal (field ENTCOD)

This field is used for this transaction to specify the code of the accounting automatic journal used to generate, via the stock accounting interface, the accounting entries with respect to the stock movements created with this transaction.
This field can only be accessed if the SCOIFA - WIP accounting interface parameter is set to No.

Tab Headings

Use this tab to create the stock count entry note.

When generating a stock count list, the system selects the stock lines to be counted according to the filters and criteria specified in the session in progress (see the Stock count session documentation).
A stock count list includes a header and stock count lines. Each stock count line represents a single stock line or a product where the system stock is zero. Thus, to count a product that is managed by lot or lot and sub-lot or lot, sub-lot and serial number leads to a stock count list that can potentially have numerous stock count lines. The count must be made for each line.

To simplify the stock count and to make it more rapid, it is possible to request that the stock count function displays the lines grouped according to certain criteria, in a way that makes it possible to enter a global count for a group of stock count lines. The grouped line detail can be accessed at all times via the Action icon of the grouped line to get a more detailed stock count.
This is the main role of the Slip block.

The grouping criteria proposed are: Location/ lot / sublot / serial number / status / warehouse / license plate number. Setting up one of these fields as 'Hidden' in the transaction indicates that it will not be displayed in the stock count entry screen and thus that the stock count lines will be presented grouped according to this criteria (all the line detail remains accessible using the Action icon on the grouped line).

The product itself is always present in a group of stock count lines along with the packing unit, the PAC/STK coefficient and the stock unit: it is thus impossible to display several lines referring to different products in a grouped way. Several stock count lines for a single product but with different packing units cannot be grouped together on a single line.

Other information can be set up for information purposes: the display or not of the theoretical stock quantity in packaging and stock units, the display or not of the variance and the line value, the display or not of the ABC class of the product.

Examples

The stock lines in the stock count are:

Line

Product

Lot

Serial no.

Location

Quantity in STK

Status

1

ART1

LOT01

01

EMP01

1

A

2

ART1

LOT01

02

EMP01

1

A

3

ART1

LOT02

03

EMP01

1

A

4

ART1

LOT03

04

EMP01

1

A

5

ART1

LOT03

05

EMP01

1

A

6

ART2

LOT01

EMP01

10

A

7

ART2

LOT02

EMP01

20

A

8

ART2

LOT02

EMP02

30

A

A stock count list is created for these two products for the LOC01 and LOC02 locations.

The system will create 8 stock count lines on this list (one by stock line to be counted).

According to the stock count transaction chosen, the count function presents the stock count lines in their fullest detail or only as grouped lines.

Example 1:

If the transaction is set up in the following fashion

Field

Display

Location

Displayed

Lot

Displayed

Sub-lot

Displayed

Serial number

Displayed

Status

Displayed

The 8 stock count lines will be displayed as follows by this transaction

Line/row

Product

Lot

Serial no.

Location

Quantity in STK(Theoretical)

Quantity in STK (Counted)

1

ART1

LOT01

01

EMP01

1

2

ART1

LOT01

02

EMP01

1

3

ART1

LOT02

03

EMP01

1

4

ART1

LOT03

03

EMP01

1

5

ART1

LOT03

04

EMP01

1

6

ART2

LOT01

EMP01

10

7

ART2

LOT02

EMP01

20

8

ART2

LOT02

EMP02

30

The stock count must therefore be completed for each serial number, which may become long and tedious when there are many serial numbers or when the actual stock is close to the theoretical stock.

Example 2:

If the transaction is set up in the following fashion

Field

Display

Location

Displayed

Lot

Displayed

Sub-lot

Displayed

Serial number

Hidden

Status

Hidden

The 8 stock count lines will be displayed as follows by this transaction

Line/row

Product

Lot

Location

Quantity in STK(Theoretical)

Quantity in STK (Counted)

1

ART1

LOT01

EMP01

2

2

ART1

LOT02

EMP01

1

3

ART1

LOT03

EMP01

2

4

ART2

LOT01

EMP01

10

5

ART2

LOT02

EMP01

20

6

ART2

LOT02

EMP02

30

If the LOT01 quantity for PROD1 differs from its theoretical quantity, the system automatically requests a detailed count entry for this lot (opening of the detail window), if not, the entry of the stock count can be made globally at the grouped line level for all the serial number in PROD1, LOT01.

Example 3:

If the transaction is set up in the following fashion

Field

Display

Location

Displayed

Lot

Hidden

Sub-lot

Hidden

Serial number

Hidden

Status

Hidden

The 8 stock count lines will be displayed as follows by this transaction

Line/row

Product

Location

Quantity in STK(Theoretical)

Quantity in STK (Counted)

1

ART1

EMP01

5

2

ART2

EMP01

30

3

ART2

EMP02

30

If the quantity for PROD1 differs from its theoretical quantity in LOC01, the system automatically requests a detailed count entry for this product (opening of the detail window), if not, the entry of the stock count can be made globally at the grouped line level for the PROD1 in LOC01.

Detail block

The detail window linked to a grouped line displays all the associated stock fields. Only the display of a few information fields can be set up: variance, value, theoretical stock in STK and PAC. A revaluation rate and amount can be entered for the stock count line, for information purposes (no impact on the stock value).

Finally, it is possible to specify that the counted stock is loaded by default with the theoretical stock (Preloading check box), this is done to facilitate the serial number count entry for example, the counted quantity always being modifiable.

Entry

Variance (field CUNDEVDSY)

Check to display the variance columns of the stock count.

field CUNDEVSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Value (field CUNAMTDSY)

Tick to display the columns of the stock valuation.
field CUNAMTSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
PAC quantity (field QTYPCUCOD)

Check to display the PAC stock column of the stock count.

field QTYPCUSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
STK quantity (field QTYSTUCOD)

Check to display the STK stock column of the stock count.

field QTYSTUSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
ABC (field ABCCOD)

Check to display the ABC column of the stock count.

field ABCSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Product description (field ITMDES1COD)

 Parameter used to define, for this entry transaction, if the product description translated in the operator's language must be:

  • Hidden: The field does not appear in the entry screen but a default value is assigned to it
  • Displayed: The default value is assigned to the field and displayed It cannot be modified.
  • Entered: The default value is assigned to the field and displayed. It can be modified.
Location (field LOCCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Lot (field LOTCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Sublot (field SLOCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Status (field STACOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Serial number (field SERCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Identifier 1 (field IDECOD1)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
Identifier 2 (field IDECOD2)
Warehouse (field WRHCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.
License plate number (field LPNCOD)

This field is a grouping criteria for stock count lines.

If this field is set to 'Hidden', it is not displayed on the stock count entry screen: lines are thus grouped based on this criteria.

Please refer to the Stock count function help for more information and examples on how to use grouping criteria.

Detail

Variance (field CUNDEVDSY1)

Check to display the variance columns of the stock count.

field CUNDEVSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Value (field CUNAMTDSY1)

Tick to display the columns of the stock valuation.
field CUNAMTSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
PAC quantity (field QTYPCUCOD1)

Check to display the PAC stock column of the stock count.

field QTYPCUSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
STK quantity (field QTYSTUCOD1)

Check to display the STK stock column of the stock count.

field QTYSTUSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Allocation (field QTYALLCOD1)

Tick in order to display the Allocated column on the stock line in the stock count.

field QTYALLSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Preloading (field LODCOD1)

Select to preload the Counted stock fields based on the Stock fields of the stock count line.
In case of multiple counts, the preloading only applies to the first and second counts. The second count is preloaded once the first one has been saved.
Revaluation rate (field DEPRATCOD1)

Parameter used to define, for this transaction, if the Revaluation rate field must be:

  • Hidden: the field does not appear in the grid.
  • Entered: the field is displayed and can be entered.
  • Entered: the field is displayed and can be entered.

field DEPRATSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Revaluation amount (field DEPAMTCOD1)

Parameter used to define, for this transaction, if the Revaluation Amt field must be:

  • Hidden: the field does not appear in the grid.
  • Entered: the field is displayed and can be entered.
  • Entered: the field is displayed and can be entered.

field DEPAMTSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
Owner (field OWNERCOD)
field OWNERSCR

Lot

field SRUB1FLG

This setup is used to specify for each of the user free fields 1-2-3-4 of the Lot addition entry window whether these fields must be entered.

These fields are used to associate additional information to a lot.

Block number 4

Tab Analytical

Block number 1

Header dimensions (field HEACCECOD)
Distribution line (field DSPCOD)
field DSPSCR
Stock movement dimensions (field STOCCECOD)

Block number 2

Reports

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

  PRTSCR : Screen print

This can be changed using a different setup.

Validation

This is used to generate the transaction in the process of being set up.

Copy

Makes it possible to copy the setup of the current transaction to another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation