A Bill of Materials (BOM) lists the quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product. A BOM can be used to communicate between manufacturing partners, multiple facilities within the organization, or with a single manufacturing plant.

In this video, we are going to show you how to Create the NetSuite Bill of Materials and BOM revisions with CloudExtend Excel Data Management for NetSuite.

Template Layout

💡 Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need in building the template.

If you are using NetSuite Classic Interface, you can go to:

Lists > Supply Chain > Bills of Materials

Name

Memo

Use Component Yield

Available for All Assemblies

Restrict to Assemblies List

Available For All Locations

Restrict To Locations List

Creating Bill of Materials (BOM)

Step 1: Add value for the Name field.

Step 2: Add a value for the Memo field.

Step 3: Add TRUE to Use Component Yield, Available For All Assemblies, and Available For All Locations fields.

Step 4: Click Update and upsert the records to NetSuite and it will generate a new Bill of Material. It will generate an internal ID for the record after it was successfully created in NetSuite.

Template Layout BOM Revisions

💡 Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need in building the template.

If you are using NetSuite Classic Interface, you can go to:

Lists > Supply Chain > Bills of Materials

Bill of Materials

Name

Memo

Effective Start Date

Effective End Date

Component List: Internal ID

Component List: Item

Component List: Bom Quantity

Component List: Item Source

Creating Bill of Materials Revision

Step 1: Insert the BOM you had just created in the Bill of Materials field.

💡 Pro Tip:

You can use the internal ID of BOM and add double brackets around the ID if you know the internal ID ie: [[123]]

Step 2: Add the values for the Name, Memo, Effective Start, and End Date fields.

Step 3: Add the values for Component List: Item and Item Source fields.

Step 4: Repeat Steps 1-3, but change the Mainline values to reflect a different Name, Memo, Effective Start, and End Date.

Step 5: Click Update and upsert the records to NetSuite and it will generate a new Bill of Materials Revisions. It will generate internal IDs for the records after it was successfully created in NetSuite.