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.

Note: Only one user at a time can run this application.

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.

Note: There are two ways to work with input files in Costpoint
  • 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.