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 commercial bill of material header information (function Commercial BOMs (GESBODC)). Components (materials), quantities and fields associated with products such as validity dates on the following tab are also populated:
The following tables are used by the function. Their content must be updated if necessary :
Table | Table description |
---|---|
TABBOMALT [TBO] | |
ITMBOM [ITB] | Products - BOMs |
Template BOMC - Commercial BOM 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:
All BOM codes are exported.
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] |