Import Bills of Material
Use this screen to add, modify, or delete Manufacturing Bills of Material (MBOM), Engineering Bills of Material (EBOM), and/or Proposal Bills of Material (PBOM) rows from a BOM record using a user-created input file, formatted as a delimited or fixed-length ASCII text file.
You can specify the network location and name of the input file, and the application performs all necessary database and business rule validation. If the input file record is valid, the preprocessor modifies the proper database tables. If the input file record is invalid, the preprocessor creates an error record and saves it to an error file with the extension .ERR, which you can modify and resubmit.
After uploading the transactions, you can review and edit Manufacturing Bills of Material on the Manage Manufacturing Bills of Material screen, review and edit Engineering Bills on the Manage Engineering Bills of Material screen, and review and edit Proposal Bills on the Manage Proposal Bills of Material screen.
This preprocessor has Add functionality for EBOM and PBOM uploads. It can process Manufacturing, Engineering, and Proposal BOMs.
The user interface also includes a Provisional Parts group box.
The preprocessor checks the following settings on the BOM Corporate Settings block of the Configure Bills of Material Settings screen: Use Extended Length Reference Designators (USE_LVC_REFDES_FL), Use Configuration IDs (USE_CID_FL), and Use Engineering Bills of Material (USE_EBOM_FL). It also checks control flags on the Corporate Settings block of the Configure Materials Requirements Planning Settings screen and the ECN Corporate Settings block of the Configure Engineering Change Notice Settings screen.
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
- Related Topics:
- Display the Import Bills of Material Screen
You can access the Import Bills of Material screen from the Materials domain. - Contents of the Import Bills of Material Screen
Use the fields and options to configure the Import Bills of Material screen. - Table Information for the Import Bills of Material Screen
Depending upon the BOM type and other settings, one or more of the following tables are updated by this application: - Subtasks of the Import Bills of Material Screen
- MBOM AND EBOM Processing
- Detailed Table Specifications Subtask
This topic defines the data element in each table to be loaded or updated by the Import Bills of Material preprocessor. - Error Processing and Input Files
If you preview or print a test copy before clicking , the errors that prevent an input file record from processing are reported in an error report.