Operations in Material Queue Manager

Kinetic ERP
1

Has anyone ever wanted or tried to get the Operation into the Material Queue Manager? I have tried many ways of getting it to load into the MtlQueue Dataview with no luck. I am starting to think it isnt possible. Any ideas??

2

Its there, you just have to unhide it in personalize columns and its called jobseq.

image

3

Unfortunately, when I go toggle that on it only gives me the MtlSeq. I ended up getting it in there though. I used an existing row that we were not using in the MtlQueue Dataview called SourceTypeDesc and I labeled it Operation (See Screenshot). I then had to make a BPM that would substitute the operation into that field. BPM is Below.

image
image1763×839 66.4 KB

// Populate Material Queue Operation display field

// BO: Erp.BO.MaterialQueue

// Method: GetRowsCustomParams

// Type: Post-Processing



foreach (var q in **result**.MtlQueue)

{

    if (string.IsNullOrWhiteSpace(q.JobNum))

        continue;

    if (q.JobSeqType != "M")

        continue;

    if (q.JobSeq <= 0)

        continue;

    var jm = Db.JobMtl.FirstOrDefault(m =>

        m.Company == q.Company &&

        m.JobNum == q.JobNum &&

        m.AssemblySeq == q.AssemblySeq &&

        m.MtlSeq == q.JobSeq);

    if (jm == null)

        continue;

    q.SourceTypeDesc = $"Op {jm.RelatedOperation}";

}