Contents of the Import Bills of Material Screen

Use the fields and options to configure the Import Bills of Material screen.

Multicompany

Validation of company tables is triggered by the company ID of the user executing the process. When looking up valid values, the preprocessor validates all company-related tables using the user's company ID. When a new BOM is saved, the preprocessor assigns it the user's company ID. filters on parameters by company. All new parameter rows are saved with the user's company ID. To separate items by company in Costpoint, select the Separate Items By Company check box on the Corporate Settings block of the Configure Product Definition Settings screen.

Files Necessary to Run Bills of Material Preprocessor

The following custom files and stored procedures files must be accessible to run the Bills of Material Preprocessor:

Subtask Description Configuration

Use the Configuration subtask to view and/or edit the configuration identifiers of the selected assembly part. Use the Assembly Serial Numbers subtask to view the configuration serial numbers for the selected assembly part.

Filename Description
AOPBOM.exe Import Bills of Material preprocessor application executable.
AOPBOM.QRP Import Bills of Material preprocessor report file.

Costpoint Data Setup

Before running the preprocessor application, complete the following steps: On the Configure Bills of Material Settings screen, establish default values. In Product Definition, establish component and assembly parts. Make sure the Import Bills of Material preprocessor application executable (AOPBOM.EXE) and the report file (AOPBOM.QRP) are applied to the database. Make sure that all patches and service packs (if applicable) have been applied to the database.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Options

Input File

Field Description
File Location

Enter, or click to select, the alternate file location where the input file is located. Alternate file locations are set up in the Manage Alternate File Locations screen.

File Name

Enter, or click to select, the name of the input file.

File Format

Use the drop-down list to select the format in which the file will be saved. Options are:

  • Delimited: Select this option to process files with fields separated by a pre-defined delimiter (either by commas or another specified character). Make your delimiter selection in the File Delimiter field.
  • Fixed Length: Select this option to process the file with no field delimiters. If you select this option, the values in the file are determined by their location. You must fill in every position in a fixed-length input file format with either an appropriate character or a space. It is not necessary to zero fill numbers; you can use spaces to maintain the proper format. Right-justify numeric fields; left-justify character fields. You do not need to fill the entire line with spaces. End every row with a carriage return and a line feed.
File Delimiter

If you selected Delimited in the File Format field, use this drop-down list to select a file delimiter. Options are Comma and Other. If you select Other, you must enter a delimiter in the field to the right.

Processing Options

Please refer to the MBOM and EBOM Processing section for additional details regarding the processing of input files.

Field Description
Prevent Insert/Update if Warning Conditions Exist

If you select this check box, the program does not update the input file record if warning messages are generated.

Allow New MBOM/EBOM Lines to be Released

Select this check box to allow MBOMs to be set to a Released status. If you select this check box, the application uses the Component Release Flag (entered in Component Released column of the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material or Release Manufacturing Bills of Material/Release Engineering Bills of Material screens) in the input file to determine the status of the BOM line. Proposal BOMs (PBOMs) have separate validation criteria, as outlined in the Detailed Table Specifications section.

If you select this check box and do not enter a Component Release Flag, the Component Release Flag (the Component Released column of the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material screen) will be set to Y (Released) in the MBOM/EBOM table. However, if you do not select this check box, the Component Release Flag will be set to N (Unreleased) for all new lines. The application displays a warning message if you try to change the status to Y (Released) with this checkbox cleared. Similarly, the application displays a warning message if you try to change the status of an existing, unreleased MBOM/EBOM line to Y (Released).

Allow Released MBOM/EBOM Lines to be Changed/Deleted

Select this check box to allow updates to BOM lines that have been released. You can modify or delete an existing, released MBOM/EBOM line (the Component Released check box is selected in the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material or Release Manufacturing Bills of Material/Release Engineering Bills of Material screens) only if you select this check box. If you do not select this check box, any input record that modifies or deletes a released MBOM/EBOM line will be in error and will not be processed.

Autoload MBOM/EBOM Text

Select this check box to load any of the component part's BOM text to the BOM line.

If you select this check box, the application checks each new MBOM/EBOM line that is added (not changed or deleted) for item text. Any BOM standard text that is linked to a component part is assigned to that component’s BOM line. Standard text codes are established on the Manage Standard Text screen in Costpoint Product Definition, and can be assigned to parts on the Assigned Standard Text subtask of the Manage Parts screen. 

Delete Option

Use this drop-down list to select either of the options to delete active or inactive BOM lines. The deletion process is discussed in detail in the Changing and Deleting BOM Rows section of the MBOM and EBOM Processing topic.

  • Physically Delete MBOM/EBOM Lines: Select this option to physically delete any MBOM/EBOM lines flagged for deletion.
  • Make MBOM/EBOM Lines Out of Effectivity: Select this option to mark any MBOM/EBOM lines for deletion out of effectivity. The line is not physically deleted from the table, but the component effectivity end date is set to the current date (unless the end date is already earlier than the current date).

Provisional Parts

Field Description
Create New Provisional Parts

Select this check box to create new provisional parts during processing. The application displays a warning message if a component or assembly part/revision in the input file does not exist in the PART or PROV_PART tables. If you choose to process records that have warnings, the application creates a new provisional part.  

Default Prov Part Type

Enter, or click to select, an existing provisional part type to be used as a default when creating new provisional parts. This field is enabled only if you select the Create New Provisional Parts check box. The field to the right displays the provisional part type description.