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)
- Add UDField to EmpBasic “Remove_c”
- 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);
}
- 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