Use this template to extract bills of material data. You can use it to import bills of material (BOM) 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 production (manufacturing) bill of material header information (function Production BOMs (GESBODP)). Components (materials), quantities and fields associated with products such as validity dates on the following tab are also populated:
The following activity codes (sorted by type) may have an impact on the way the function operates :
ECC : Product version management
The following tables are used by the function. Their content must be updated if necessary :
Table |
Table description |
---|---|
ITMMASTER [ITM] |
|
TABBOMALT [TBO] |
Template BOMP - Production Bill of Materials must be active.
Bills of materials (BOMs) consist of a header and links.
The main table to set up is the BOM (BOM header) table. The BOM table is linked to the BOD object.
To import BOMs you must set up two identifiers, one for the header table (table BOM) and one for the link table (table BOMD).
The main object is automatically detected with the main key which is the product/route coupling.
The existence of links is acknowledged according to the following criteria:
To import a new non-versioned Production Bill of Materials (BOM) at status 'Available to use' define a default BOM code in the BOM table field *3 (Default BOM code). The import process initially creates a non-versioned BOM as a new versioned-managed BOM at status 'In development'. When it has validated the structure of the bill is correct it then sets the new versioned BOM to status 'Available to use'.
The default BOM code is mandatory the first time you import a versioned BOM. Subsequent imports of the same production BOM will use the default BOM code unless you select a different BOM code.
Versioned BOMs must be imported in the correct sequence.
To import versioned BOMs that are older than today's date, type 'D' in the BOM table field *4 (Option).
All BOM codes are exported.
All versions (major, major/minor) of a BOM are exported, not just the current version.
Table BOM - Header BOMs
Table BOMD - Detail BOMs (links)
In addition to the generic error messages, the following messages can appear during the entry :
The BOM code (product + code) is already in use. You must use a different BOM code.
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 |
BOM [BOH] |
Header BOMS |
BOMD [BOD] |
Detail BOMs |
FACILITY [FCY] |
|
ITMBOM [ITB] |
Products - BOMs |
ITMCATEG [ITG] |
|
ITMFACILIT [ITF] |
|
ITMMASTER [ITM] |
|
TABBOMALT [TBO] |