Engineering Mass Update

I’ve never done this at all and was looking for some guidance. Engineering needs to update many parts by putting the scrap % to a different number and removing a line in the operations. Can all of this be done by a mass update? I know the numbers can be. but didn’t know about removing a line. I would assume, if it does work, build an updatable BAQ, export it to excel, make the changes, then import as an update, correct? Or is there a better/different way of doing this?

I would use DMT to do this if you have it.

1 Like

You can delete in DMT. Check this box and it will delete the lines you have in the file. And you can change values. You will need separate files, one for Bill of Materials Table to move scrap percentage, and one for Bill of operations to remove the operation.

I don’t know if that works with UBAQ’s as I haven’t tried that yet, I would imagine it’s not easy, or DMT wouldn’t exist, but I could be wrong about that. You would still make a regular BAQ to get your rows though, then make the changes in excel and import using DMT. Check the changes with your BAQ.

1 Like

Forgot about DMT. That sounds better than the Updatable option. Thanks!