How can I track who deletes MTL or a Sub Assembly on Job Entry or Job Tracker

Epicor ERP 10
, ,
1

Hello! We are finding that someone, or something is happening to our Jobs with MTL and Sub Assemblies. Is there a change log I can activate that will give us a log of who deleted something in Job Entry or Job Tracker? Thanks in advance!

2

The built-in change log feature doesn’t track deletions, but you can build something yourself using a data directive.

2 Likes
3

You could also turn on the Prevent Changes functionality on Jobs.

1 Like
4

I created a BPM that seems to work pretty well. I named the file with TESTING first to test it, then changed the name when people who needed it say it is good for them.

This is for Assembly Deletions.

foreach (var tt in ttJobAsmbl.Where(tt => tt.RowMod == "D" && !tt.JobNum.StartsWith("U")))
{
var outputPath = @"\\drive\path\filder\JobAsmblTESTING.csv";
  using (StreamWriter sw = File.AppendText(outputPath))
  {
    var str = $"{tt.JobNum}, ";
    str += $"AsmSeq {tt.AssemblySeq}, ";
    str += $"UserID {callContextClient.CurrentUserId}, ";
    str += $"Date {DateTime.Now}";
    
    sw.WriteLine(str);
  }
}

This is for Mtl Deletions.

foreach (var tt in ttJobMtlWhere(tt => tt.RowMod == "D" && !tt.JobNum.StartsWith("U")))
{
var outputPath = @"\\drive\path\filder\JobMtlTESTING.csv";
  using (StreamWriter sw = File.AppendText(outputPath))
  {
    var str = $"{tt.JobNum}, ";
    str += $"AsmSeq {tt.AssemblySeq}, ";
    str += $"MtlSeq {tt.MtlSeq}, ";
    str += $"UserID {callContextClient.CurrentUserId}, ";
    str += $"Date {DateTime.Now}";
    
    sw.WriteLine(str);
  }
}