Products - Sites
Use this template to extract data associated with a product for a given site. You can use it to import product-site data from any third party product into Sage X3 and to export from Sage X3.
Imported data is converted into the right format to populate the product-site header information (function Products-sites (GESITF)). Location management, quality control, reordering, stock and costing fields associated with products such as the default storage location, valuation method and stock thresholds on the following tabs are also populated:
- Management
- Logistics
- Planning
- Totals
- Calculated data
- Manufacturing
- Cost
- Counts
Mandatory fields in the template
The mandatory fields are as follows:
Table ITMFACILIT – Products-sites
- Product (ITMREF)
- Stock site (STOFCY)
- Valuation method (VLTCOD)
- Location management (LOCMGTCOD)
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
ACCES [ACC] |
Access by user |
|
ATEXTRA [AXX] |
Texts to translate |
|
FACILITY [FCY] |
|
|
ITMCATEG [ITG] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
STOLOC [STC] |
Locations |
|
STOPAR [STE] |
|
|
TABCOSTMET [TCM] |
|
|
TABCUR [TCU] |
|
|
TABLOCTYP [TLO] |
|
|
TABREOPOL [TRP] |