What is BOM?

In manufacturing, a BOM (Bill of Materials) is a list of materials and components required to produce a product. By entering the product to be produced and the production quantity, you can automatically calculate the required quantity of each component.

How does It Work?

Enter the components required for each product in the BOM Basic Table. Then, in the BOM Material List, retrieve the corresponding components based on the product name and break them down and consolidate them level by level.

Configurating Basic Tables

Whether you are building a two-level BOM or a three-level BOM, configure the following basic tables before building the BOM.

BOM Basic Table

Step 1 Building the Form

Create a form named BOM Basic Table and configure the fields as follows:

Field Name	Field Type
Main Product	Single Line
BOM Details	Subform
Sub-Item	Subfield - Single Line
Quantity	Subfield - Number
Sub-Item Count	Number
Sub-Item Collection	Single Line
Quantity Collection	Single Line

Step 2 Setting Formulas

1. Select the Sub-Item Count field. Under Field Properties > Initial Value, select Formula, and then click Edit.

2. In the Formula Editor, configure the formula for the Sub-Item Count field as follows:

COUNT(BOM Details.Sub-Item)

After configuring the formula, click OK to save it.

In the same way, configure the formulas for the other fields as follows:

Sub-Item Collection:
```
TEXT(BOM Details.Sub-Item)
```
Quantity Collection:
```
TEXT(BOM Details.Quantity)
```

Step 3 Entering Data

Enter the product components and their required quantities in the form. The data entry rules vary depending on the number of BOM levels involved:

For products with two BOM levels: Enter only the details of the second-level components. For example, the components of a Strawberry Cake are the cake base, cream, and strawberries.
For products with three BOM levels: Enter all third-level component details. For example, enter the components of the cake base, cream, strawberries, and durians. If strawberries and durians do not have any further components, you must still enter them as sub-items. Otherwise, some data may be missing.

Subform Basic Table

Step 1 Building the Form

Create a form named Subform Basic Table and configure the fields as follows:

Field Name	Field Type
Total Rows	Number
Subform	Subform
No.	Subfield - Number
Number	Subfield - Number

Step 2 Entering Data

1. Go to Manage Data > Import and import the sample data from the attached file 200-Row Subform Basic Table Sequence.xlsx.

2. When importing the data, make sure that the sample data is mapped to the form fields as follows:

Building the BOM Material List

The BOM Material List is divided into two-level BOMs and three-level BOMs. For detailed configuration methods, see:

Two-Level BOM Material List
Three-Level BOM Material List

200-Row Subform Basic Table Sequence.xlsx