Multiple Configurations

A Bill of Materials is a simple listing of the parts and quantities required for build. But different departments need to see representations of that BOM differently even though it is the same data. Here are some examples:

• Supply Chain buyers need a purchase BOM with only vendor part number, description, and quantity
• Production Planners need a BOM with only Part Number, routing, and parent assembly
• Manufacturing needs a BOM with only Part Number, Description, and Work Order
• Parts Warehouse needs a BOM with only SKU and quantity

Configurable Settings

Setup the BOM export using the built in PDM BOM Columns and sheet name, SQL Server to connect to, and Database Table to store the BOM.

By using the built in BOM column sets, we have combined out of the box functionality with some special ingredients to get just the perfect mix of flexibility for every customer’s specific BOM requirements.

Manual BOM Export Support

Export the BOM to the SQL Database Table using the BOM ETL Tool is simple. Browse to a drawing, select the sheet name the BOM is on for export, and the BOM can be opened in the grid matrix for review before export.

Open the BOM in the Grid Matrix

This grid matrix view brings you two features that will assist you with your BOM export needs:

1. Review the contents of the BOM before committing the BOM to the SQL Database
2. Drag/Drop a pre-formatted XML BOM onto the grid for even more flexibility for uploading your BOM to the SQL Database.

NOTE: Schedule a FREE consultation with us to learn how we can help you connect this SQL BOM Table to your ERP System.