Solutions for Accounting, Business Automation and E-Commerce

Bill of Materials

Overview

The Bill of Materials function allows the you to stock raw materials, component items and finished goods. This facilitates a finished good item to be selected on a sales order without listing the detail of its component items. The system uses a work order or "Build Assembly" process to back flush or record "after the production" of finished goods. Raw materials quantities are reduced, finished good quantities are increased, costs are "rolled up" into the finished good and the detail of inventory stocking layers automatically updated during this process.

Inventory Item Detail
In Inventory Control Item Maintenance the "detail" tab allows for the selection of an inventory item to be an assembled item or not. Selecting "yes" activates the Assembly screen.

Figure 1: Inventory Control Item Maintenance Screen, Assembled Item

Detailed Bill of Material
The Assembly screen allows for the line items of the bill of material for a finished good to be constructed. These line items can include a labor component at standard cost that will roll up into the finished good cost. Inventory items are displayed allowing the user to select the required quantity necessary to build the finished good. Quantities in stock are displayed to assure the necessary stock levels for production.

Figure 2: Bill of Materials Inventory Item Assembly Screen

Build Assembly
When the quantity to build is selected the bill of materials automatically adjust the component quantities required. All stock status is displayed before production is recorded. The system allows for the finished good to be stocked into alternate warehouses. The cost rollup is displayed.

Figure 3: Bill of Materials Build Assembly Screen

Posting Impact
A drill down of the general ledger impact of the "build" process is available for display if necessary.

Figure 4: Bill of Materials Build Assembly General Ledger Recap Screen

Build History
The system records all transaction detail of the build process for extensive reporting capability. The Inventory Assembly Build History report allows for history to be displayed in detail depending on date range or inventory item.

Figure 5: Bill of Materials Inventory Assembly Build History Report

Assembly Detail
The bill of material for a particular item or range of items is available in printed format if necessary.

Figure 6: Bill of Materials Inventory Assembly Detail Report

Feature Set and Functionality

• Full serial number control in effect for items comprising the bill of material and finished good item.
• System tracks the standard cost and actual cost of finished good items.
• Sales price of finished good item displayed when reviewing the bill of material.
• Description field can be overridden at the bill of material level to allow for extended descriptions to be attached to the line items.
• Toggle available on the bill of material line item level to adjust the sort order of line items displayed to correspond to the work flow of the assembly process.
• Bill of material line items can be duplicated from an existing bill of material with the push of a button.
• Build Assembly process available at the bill of material level without having to move to another screen in the program.
• Extended search ability available at the bill of material level.
• Stock status of all warehouses available with the push of a button including what is in stock and what is on order.
• Unit of measure control active at all levels of the bill of material.
• During the "build" process the status of the stock levels of the bill of material items is available including "in stock", "on order" and "on back order".
• Bill of material can be printed at the time production is recorded to serve as a work order for the shop floor.

Tel (949)261-2694 or Toll Free (800)997-7944 * Fax (949)660-9189
1301 Dove Street * Suite 750 * Newport Beach, CA 92660 * USA