Method Tracker - BPM Query

Kinetic ERP
, ,
1

Hi All,

I was wondering if anyone has had any success in transferring field data from a field within Part, into the Method Tracker menu?

To give context we have a string UD field within the Part table,

We have Method BPM’s in other menu’s (Such as Job Entry, Engineering Workbench etc..) that pull the data from Part and input into the UD field within the tables in these Menu’s,

An example of the code for the Job Entry BPM is below,

foreach (var Mtl in result.JobMtl)
{
    var P = (from Part in Db.Part
    where Mtl.Company == Part.Company && Mtl.PartNum == Part.PartNum
    select Part).FirstOrDefault();
    {
        Mtl["UD_ChangePending_c"] = P["UD_ChangePending_c"];
    }
}

Now i’ve looked at Method Tracker and the only Method BPM I can identify from just loading a Part is Erp.BO.BomSearch.GetDatasetForTreeWithPartValidation,

However, the table needed is EcoMTL but it does not exist within the table of the Method BPM,

image
image172×480 3.12 KB

Below is the location of where I am trying to force the update of data (This is within the Materials section of Method Tracker),

image
image1851×561 20.5 KB

image

Happy to provide more context or information if required. We haven’t had any problems with other Menu’s, it’s just been Method Tracker so far.

Thanks,
Gary

2

I think you can do what you need using the UD Column Map tool

1 Like
3

Interesting, never investigated this tool before,

I’ve enabled a Template as below,

Does it just source the data and transfer like this? Or is there anything else I need to do?

image
image1636×473 14.5 KB

4

It has been a while since I last used that and I can’t be 100%, but I think it just works (unusual for EPICOR I know).

Please let us know :smiley:

1 Like