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:

  • Component

Prerequisites

Activity codes

The following activity codes (sorted by type) may have an impact on the way the function operates : 

  ECC :  Product version management

Other prerequisites

Tables to be completed

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

Table

Table description

ITMMASTER [ITM]

Products

TABBOMALT [TBO]

BOM codes

Operation

Template BOMP - Production Bill of Materials must be active.

Data import

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:

  • Search with the sequence number and the component product reference. If the line exists it is modified, otherwise it is created.
  • The BOM import processes the link deletion. A link is deleted if the value for the sequence number (BOMSEQ) is negative whatever the link quantity.

    Examples:
    • Import of a sequence 3 text line (the link quantity automatically equals 0), from the BOM:
      - To delete this line, the sequence number must be specified as a negative value (...;-3;...).
      - To create/modify this line, the sequence number must be specified as a positive value (...;3;...).
    • Import of a sequence 5 line from the BOM for the component (with a null link or not):
      - To delete this line, the sequence number must be specified as a negative value (...;-5;...).
      - To create/modify this line, the sequence number must be specified as a positive value (...;5;...).

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'.

Note 

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).

Data export

All BOM codes are exported.

All versions (major, major/minor) of a BOM are exported, not just the current version.

Mandatory fields in the template

Table BOM - Header BOMs

  • Parent product code (ITMREF)
  • BOM alternative (BOMALT)

Table BOMD - Detail BOMs (links)

  • Link sequence number (BOMSEQ)
  • Additional sequence number (case of options/variables).
  • Component product code (CPNITMREF)
  • Link quantity (LIKQTY)

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Code type incompatible

The BOM code (product + code) is already in use. You must use a different BOM code.

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

BOM [BOH]

Header BOMS

BOMD [BOD]

Detail BOMs

FACILITY [FCY]

Sites

ITMBOM [ITB]

Products - BOMs

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

TABBOMALT [TBO]

BOM codes