ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon Sales
DrillDown Icon Inventory Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Statisical Quality Control (SQC) (OPTIONAL Module)
DrillDown Icon Corrective Action Request (CAR) (OPTIONAL Module)
DrillDown Icon Integrated BOM & AVL
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Find a BOM
DrillDown Icon Adding Header Info
DrillDown Icon Adding BOM Line Items & BOM Copy
DrillDown Icon BOM Deletions
DrillDown Icon Edit Line Item Details
DrillDown Icon Bill of Material (BOM) Used in Kit Option
DrillDown Icon BOM Setup Scrap Checkbox
DrillDown Icon Make a Obsolete Part Available on a BOM
DrillDown Icon Link User Defined Fields to a BOM
DrillDown Icon Reports
DrillDown Icon FAQs
DrillDown Icon BOM Import
DrillDown Icon ECO, BCN & Deviation Control Mgmt (EBD) (OPTIONAL Module)
DrillDown Icon Work Order Traveler Setup
DrillDown Icon Product Data Management (PDM) (OPTIONAL Module)
DrillDown Icon PDM Standard Process Specification
DrillDown Icon Administration
DrillDown Icon Accounting
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Find a BOM

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Quality/Engineering/Integrated BOM & AVL

 

When the screen first opens, the user is limited to only three of the eleven action buttons shown: Find an assembly, run a Report or Exit.  Assemblies having Bills of Material will display the components in the Body (Detail Window) below. Selection of one of the components in the window will cause detail information for that item to be displayed if any other BOM screen Tab is selected. Use the Add icon to add components to the BOM of a displayed assembly.  Use Edit to change or add Header information. Use the Delete icon to Delete the entire BOM ONLY (See Deletions section).  Note: Go to the Item Detail screen to delete only one item from the BOM.

 

Find a Bill of Material

To view an existing BOM or to find an existing Make Source Item (Product, Assembly, Subassembly or Phantom) under which to build a BOM.
Click on the Find an existing record Action Button.

Find an existing BOM screen selection will be displayed:
 
Select the desired Filter:   by selecting the appropriate radio button - Active, Inactive, or All.
 
Select the desired Find:   by selecting the appropriate radio button - Product Number, Part Class, Customer, or All.
 
Enter the information into the red box, depress the Enter key and the information will populate the screen.    If you do not know the exact number, Customer, etc you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all BOM's that contain the partial number, letter, etc. entered, to select from.

(Note:  The status of the BOM may be different than the status of the Inventory Part).  Since you are doing a find for the BOM you would search by the status of the BOM.  

Check the "Display Customer Part #..." box to display the Customer Part number for the "Buy" parts if the BOM is linked to a customer.  Selecting this option may slow down the results.  The system will retain the last choice the user makes for this check box until the module has been exited.
 
 

 
Find an Existing BOM by Product Number

If you enter information in the Red Box, and system cannot locate any information for the entered product number, part class or customer, user will receive the message being displayed.   

 
 

 

 

If  user selects ANY of the Filters: and Find by All - a screen will appear listing all the Part Numbers with Bill of Materials in numerical order, along with part class and types, descriptions, and status of Inventory Part. 


The user has the option to view the BOM by either entering the Part Number into the red box, or scrolling down the list, highlighting the desired record and double click on it.

And the information will populate the screen as displayed below:

 
 

 

BOM Search Results

After finding the Part Number through either the Class Code, Customer, or directly by the Part Number, the BOM Main screen appears, populated with any parts already entered for the BOM of the assembly selected. If no parts have been added to the assembly, the Body (Detail Window) is blank.  When BOM is found and displayed the order will be by "Item #". User can re-sort  list by clicking on a header that is in Bold that header will display in red.  The lines that are inactive will be highlighted in purple.  When double clicking on an item, system will take you to the detail page.  

User may find a part using the Reference Designator Lookup, by typing a reference designator into the text box it will auto fill the information, when done entering you can press “Enter” or click on the search button next to it and the record pointer in the grid will advance to the part if found.

 The Header Information fields across the upper half of the screen are populated from the item master and from keyed-in assembly data. The fields in the Body (Detail Window) show information about the components included in the assembly.
 
 
Article ID: 4795