The Short Material Description in the Piping Commodity Material Control Data sheet is not a property used to create the unique ID definition of the record. Therefore, you can mark the existing record as modified by typing M at the beginning of the record. For example, the correct short description is "Gate valve, CL150, FFFE, BB, OS&Y, ASTM-A395, brnz trim, Stockham D-623" for 150# gate valve with a contractor commodity code "VAAAHAAAWAIFABAZZZZUS".
-
Open the Piping Commodity Material Control Data sheet.
-
Locate the record, edit the Short Material Description value, and then type M at the beginning of the record.
-
Bulkload the spreadsheet, and review the log file.
-
Use Catalog Checker to review the impact of the proposed changes.
-
Use Synchronize Model with Catalog to mark the out-of-date objects.
-
Verify your changes, and resolve any discrepancies.