I would never run an UPDATE
nor DELETE
command against my Epicor SQL database. That would be reckless.
My users, especially those in sales and finance, are more than happy and welcome the opportunity to wait for days, maybe weeks, for support to go to development, and development to provide a data fix.
Interesting note - just had a datafix for a serious issue in LaborDtl table (see Production Labor Rate Is Zero (MES) - ERP 10 - Epicor User Help Forum ) and the data fix provided by support (the first Iβve gotten in quite awhile, and the first on Epicor 10.1) is nothing more than a SQL script with and UDPATE
in it.