Import/export template > Module Stock > Import/export template LPNG (License plate number grouping) 

Use this template to group all the stock lines of one or many license plate numbers into one single license plate number.

The rules that apply to the license plate number and location are the same as in interactive entry mode:

  • If the destination license plate number is already in stock, it is not necessary to specify the destination location. The location where the license plate number is located is used.
    Please refer to the License plate number operations documentation for more information.

Once the import is complete, a stock change movement of the License plate number change type and a stock change document are generated.

To differentiate this import template from the LPNO - LPN operation template, the MODOPELPN - Mode of operation field must be set to ‘1’.


Import file example

You want the PAL022 and PAL023 containers to be grouped within the PAL023 container only (i.e.: group all their stock lines).

The syntax of the import file is:

"E","","FR012",190104,"","","",1,"PAL00023","A1C15"

"L",1000,"PAL00022"

Error messages

The only error messages are the generic ones.

Tables used

This template can only be used in import mode. The data is updated in the following tables :

Table

Table description

FACILITY [FCY]

Sites

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMWRH [ITW]

Products-warehouses

SCHGD [SGD]

Stock change line

SCHGH [SGH]

Stock change header

STOCK [STO]

Stock

STOJOU [STJ]

Stock journal

STOJOUVAL [SJV]

Stock movement values

STOLOC [STC]

Locations

STOLOT [STL]

Lot numbers

STOSER [STS]

Serial numbers

TABALLRUL [TRU]

Allocation and issue rules

TABLOCTYP [TLO]

Location type table

TABSTASTO [TST]

Stock status report

TABSTORUL [SRU]

Stock management rules

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses