Import/export template >  Module Stock >  Import/export template SMO (Miscellaneous outputs)  

Display all Hide all

This import enables the creation of documents and document lines for miscellaneous outputs.
Three ID elements must be set up within the import template for miscellaneous outputs!

  • document header
  • document line
  • movement

Prerequisite

Other prerequisites

Tables to be completed

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

Table

Table description

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

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

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