Understanding Bill of Material Update

You change multiple bills of material by running the Where Used Bill of Material Update program (R30520).

You can use this program to perform mass updates to information such as:

  • Replacing one component item with another.

  • Deleting an item.

  • Changing effective dates for an item.

  • Changing the quantity per assembly for an item.

  • Changing the issue type code.

  • Changing the unit of measure.

You use data selection to specify the items to change. You then use processing options to define the change. The system locates all occurrences of the item (as a component) and updates the bills of material. You can also update a component with past or future effective dates.

If you want to make changes to a bill of material and remove the old records, run the program twice. First run the program to create the new records, and then run it again to delete the old ones.

The system stores changes in the Bill of Material Master File table. The system does not automatically update existing parts lists, MRP calculations, and costing information.

In addition, the program updates fields in other tables:

  • Low Level Code (in the Item Master table).

  • Net Change Flag (in the Item Branch File table).

You can run this program in either proof or final mode. In proof mode, the system generates a report of the proposed changes for the review but does not update the data. In final mode, the system updates the data and generates a report identifying the changes.

Important: When you run this program, you can potentially change many bills of material in the system. It is recommended that you run this program in proof mode first to verify the choices before running it in final mode to change the data. You might want to restrict access to this program.