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:
|
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.
|
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. |