Miscellaneous entries
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
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] | |
ITMCATEG [ITG] | |
ITMFACILIT [ITF] | |
ITMMASTER [ITM] | |
ITMMVT [ITV] | Product-site totals |
ITMWRH [ITW] | |
LPN [LPN] | |
OVERHEAD [OVE] | |
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] | |
TABLOCTYP [TLO] | |
TABSTASTO [TST] | |
TABSTORUL [SRU] | Stock management rules |
TABUNIT [TUN] | |
WAREHOUSE [WRH] |