Former Employees

Alternate that I use for a lot of different areas of Epicor where we want to weed things out (ex. parts, resources, employees, buyers, sales reps etc)

  1. Add UDField to EmpBasic “Remove_c”
  2. Create pre-proc on EmpBasic.GetList and EmpBasic.GetListForTE modifying the whereClause. I usually have managers security groups that these filters don’t apply to so they can still access what are effectively archive records.
if (string.IsNullOrEmpty(whereClause))
{
    whereClause = "(Remove_c = 0)";
}
else
{
    whereClause = "(Remove_c = 0) " + ((whereClause.StartsWith(" BY")) ? whereClause : "AND " + whereClause);
}
  1. Profit

P.S. @Epicor transaction records have to remain in the system, but a built in means of garbage collection for searches, a soft remove you might say, would be a plus :slight_smile:

8 Likes