This import enables the creation of documents and document lines for miscellaneous entries.
The generated stock movements are valued and the movement price details may be specified through SMVTDVAL table (only for structure purpose).

 Three ID elements must be set up within the import template for miscellaneous entries:

  • Document header
  • Document line
  • Movement value
  • Movement

Other prerequisites

Tables to be completed

The following tables are used by the function. Their content must be updated if necessary :

Table

Table description

SMVTDVAL [SMV]

Movement price

SMVTH [SMH]

Movement header

SMVTD [SMD]

Stock movement detail

STOJOU [STJ]

Stock journal

Mandatory fields in the template

In this import, the compulsory fields are the following:

  • Site,
  • Product,
  • Quantity expressed in CUs
  • PAC

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

CPTANALIN [CAL]

Analytical accounting lines

DIETRS [DTR]

Analytical entry transaction

FACILITY [FCY]

Sites

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMWRH [ITW]

Products-warehouses

LPN [LPN]

License plate number

OVERHEAD [OVE]

Overhead codes

SMVTD [SMD]

Stock movement detail

SMVTH [SMH]

Movement header

STOCK [STO]

Stock

STOJOU [STJ]

Stock journal

STOJOUVAL [SJV]

Stock movement values

STOLOC [STC]

Locations

STOLOT [STL]

Lot numbers

STOSER [STS]

Serial numbers

TABCONTAINER [TCTR]

Container

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