Skip to main content

Knowledge Center

Load Stock takings (STTUPLOAD) - INP/80788

Import Stock taking data (STT) and register it to Status 2 - Pending counting.

Field

Required

Format

Length

Example

Title

Description

COUNTBY

Optional

2798

PID assigned to perform the counting.

COUNTSELECTEDAREAONLY

Optional

1

Only count area given by FROMSTOCKLOC and TOSTOCKLOC.

Only allowed if type is "STOCK LOCATION".

FROMSTOCKLOC

Optional

H1-S1-R2

First stock location in range.

Required and only allowed if type is "STOCK LOCATION".

GOODSRECEPTIONID

Opitional

TEM-NO:SSA/100502-1

Reference to goods reception XXX-XX:SSA/nnnnnn-n.

Required and only allowed if type is "GOODS RECEPTION".

LOC

 

TXT

3

VAT

Loc

Location.

Required if type is "STOCK LOCATION" or "PRODUCT".

MAXNETPRICE

Optional

5000

Maximum net price of Goods reception item (SSAITEM) to be included in Stock taking (STT) (local CUR).

Only allowed if type is "STOCK LOCATION".

MINNETPRICE

Optional

10

Minimum net price of Goods reception item (SSAITEM) to be included in Stock taking (STT) (local CUR).

Only allowed if type is "STOCK LOCATION".

NAME

Optional

Annual stock taking 2024

Name of the Stock taking (STT)

PRODUCTID

Optional

#100325

Product id (IT) number.

*Required, and only allowed, if type is "PRODUCT".

STOCKCLASSIFICATION

Optional

A

Restrict stock taking to given stock classification.

Only allowed if type is "STOCK LOCATION"

TOSTOCKLOC

Optional

H1-S1-R4

Last stock location in range.

*Required and only allowed if type is "STOCK LOCATION".

TYPE

Y

STOCK LOCATION

STOCK LOCATION, GOODS RECEPTION or PRODUCT

  • If Type = "STOCK LOCATION"

    • FROMSTOCKLOC, TOSTOCKLOC and LOC are required.

    • PRODUCTID and GOODSRECEPTIONID are not allowed.

    • MINNETPRICE, MAXNETPRICE, STOCKCLASSIFICATION, COUNTSELECTEDAREAONLY, COUNTBY and NAME are optional.

  • If Type = "GOODS RECEPTION"

    • GOODSRECEPTIONID is required.

    • FROMSTOCKLOC, TOSTOCKLOC, MINNETPRICE, MAXNETPRICE, STOCKCLASSIFICATION and COUNTSELECTEDAREAONLY are not allowed.

    • COUNTBY and NAME are optional.

  • If Type = "PRODUCT"

    • PRODUCTID and LOC are required

    • FROMSTOCKLOC, TOSTOCKLOC, MINNETPRICE, MAXNETPRICE, STOCKCLASSIFICATION, COUNTSELECTEDAREAONLY are not allowed.

    • COUNTYBY and NAME are optional.

Note

If content in a row is not according to the rules described for the "TYPE" field, Stock taking (STT) will not be created and details about why will be logged in In/out log view (IOL/;NAME:STTLOAD).

If Stock taking (STT) is attempted to be created for type “STOCK LOCATION”, there will be performed a check to identify if there already exists a non-completed (status less than 9) Stock taking (STT), which overlaps FROMSTOCKLOC and TOSTOCKLOC.

If overlapping Stock taking (STT) of type "STOCK LOCATION" is found, Stock taking (STT) will not be created for this row, and details about why will be logged in In/out log view (IOL;NAME:STTLOAD).