How to mass update part description based on string? Updatable Query?

Epicor ERP 10
1

We have many parts that have a description with: “… contains (2) 80332394”. For all of these parts, I need to change them to “… contains (2) 99999999”.

So, looking to do a Find & Replace of sorts, but I don’t know how to do this in Epicor. What is the easiest way to do this without going directly into MS SQL Server?

2

My first thought:

  1. Query to find the parts containing this string in the description
  2. Export query results to Excel
  3. Find & Replace the string with the updated one
  4. Run Excel file through DMT to update the part table
3

That BAQ -> Excel -> DMT is the way I would go.

But instead of doing the replace in Excel, do it in the BAQ with a calculated field

Note that I’m not sure if a change to a Part’s description is made, if any existing BOM’s that used that part, would have the description for that material automatically updated.