Bill of Materials (BOM)

You cannot reach your full efficiency potential without the ability to fully define the material specifications - raw materials, components, and subassemblies -- that comprise the products you make. DBA gives you all the tools you need to rapidly and accurately create the bills of material that play such a pivotal role in product costing and job generation.


Stock Items Screen - Manufactured and purchased items are set up here in the Stock Items screen. Existing items are displayed on the opening List tab.

Rapid Item Creation - When you click the New button, just the required fields are presented, which enables you to rapidly create new items. No GL accounts are specified because all GL posting is controlled by the Account Assignments screen so that your operational people are never exposed to accounting decisions.

Document Linking - Multiple documents can be linked to items on the Documents tab and can also be linked to descriptors, customers, and suppliers and can be automatically retrieved and attached to jobs. Documents can include pictures, drawings, engineering diagrams, process instructions, and manuals. Document linking is vital if you are seeking or wish to maintain ISO-9000 certification.

Bill of Materials

Bill of Materials Screen - Manufacturing specifications are entered in the Bill of Materials screen. Five BOM types are offered - BOM, One-Off, Phantom, Batch, and Secondary.

Revision Control - On the Revisions tab you can optionally track engineering changes by revision. Each product has a current revision, which is used for active production, a pending revision for the next version of the product, and archived revisions.

Components - On the Components tab you specify the raw materials, purchase parts, and subassemblies that comprise the product. Each component is optionally assigned to the routing sequence where it is consumed. The overage percentage provides a safety factor to cover expected scrap. The speed entry function enables you to rapidly generate a set of components.

BOM Type - The BOM Bill of Material Type is used for discrete manufacturing where specifications are defined for one unit of the parent product and jobs are run in multiple quantities.

One-Off BOM Type - One-off items are generated automatically during quote and sales order entry and represent items that are customized or made on a one-time basis only. A 'One-Off' BOM Type bill of material can be entered from scratch or it can be originated from a standard bill of material and then customized as needed for the specific order. When the job is completed and the sales order is closed, the one-off item is automatically inactivated.

Phantom BOM Type -- The 'Phantom' BOM Type, like the One-Off BOM Type, is also used for custom manufacturing. A phantom assembly is a make to order subassembly that is never stocked or made on its own job. Within a one-off bill of material, phantom parent items are added as components to represent customized product options. At time of job creation, the phantom parent is swapped out by the complete set of phantom assembly components. Therefore, phantom assemblies serve as building blocks that can help you rapidly configure a customized product.

Batch BOM Type - The 'Batch' BOM Type is used for batch process manufacturing where specifications are entered against a fixed batch size. On the Revisions tab you define a batch size against each revision. On the Components tab the usage quantity for each component is the amount that goes into the batch size.

Secondary BOM Type - The 'Secondary' BOM Type is used to define secondary outputs. Secondary outputs are added to other bills of material on the Outputs tab. Each job has a primary output, which is the BOM parent, but can also have other outputs. These can be by-products, co-products, usable scrap, or used parts that are derived from disassembly jobs. Each output can be given a cost ratio percentage, which is its share of the unit cost.

BOM Tools

BOM Copy - Bill of materials can be originated from a copy of another bill of material. New revisions can be originated from current revisions.

Component Replace - The Component Replace screen enables you to mass replace a component across all bill of materials where it is used.

Item ID Change - The Item ID Change screen can be used to change a stock item ID number across all associated database tables.

Inquiries & Reports

Stock Items Data View - You can use the Stock Items data views to create your own set of customized formats to assess your item specifications.

Indented View, Tree View - Within the Bill of Materials screen, the Indented View and Tree View inquiries provide a multi-level view of an item's product structure.

BOM Explorer - The BOM Explorer screen enables you to you view an item's specifications in a Windows Explorer format. The explorer view is in the left panel and the selected item's details are displayed in the right panel.

Where Used Inquiry - The Where Used Inquiry screen shows you all the bill of materials within which an item is used.

Multi-Level BOM Report - The Multi-Level BOM report gives you an indented view of an item's manufacturing specifications.

Costed BOM Report - The Costed BOM report breaks out item costing details within an indented view format.

Data Import

Manufacturing Specifications Import - The Data Import utility can be used to import the following manufacturing specifications -- stock items, item categories, locations, item sources, BOM components, and BOM routings.

CAD Users - The data import tools are particularly useful if you create new items and bills of material using a CAD program. You can import any set of new items and the Stock Item import utility ignores items that already exist and only creates records for new items. After new items have been created, you can use the BOM import utility to import the new bill of material.