UD Column Mapping and Get Details

Epicor ERP 10
,
1

I have created a flag that indicates if the part comes from an outside source. The part could also be purchased so I can’t have the flag specific to the part since it can change. It gets set based on the revision of the parent part. I have updated the ECOMtl, PartMtl, and JobMtl tables to add the UD field. I have set the mapping in the UD Column Map form to linkt them all together. I can see it checked in the Method Tracker for the parent part (which I set via Engineering Workbench) so I know the data is being stored in the JobMtl table. However, when I go to pull the materials into a new job using Get Details the flag is not coming over. I put a message in both the pre and post processing BPM for the AppendDetails method but the flag is showing false when I know it is true. I see that it looks at the temp table ttJbMtlApp but the flag does not appear to be set.

My question is where do I link this together? I have read that manually adding a part will use the mapping but as I said this flag isn’t in the Part UD table. I understand I may need to set up a BPM to actually set the field on the job material, but it appears I am looking at or linking in the wrong table.

2

The method tracker isn’t pulling from the jobMtl table, that’s the PartMtl table. AKA the master. Job mtl is only on jobs.

3

OK - my mistake. Then it is being store in the PartMtl table but I don’t see it when I try to add the details to the job.

4

Are you sure you have the map set up correctly from the part MTL to the job MTL tables?

5

See below how we have it set up. This is for operations, but feel free to replace Opr with Mtl. For the ECO-Part relationship, you will need both directions (ECO-Part and Part-ECO).

image

6

I am not sure where you got your snapshot from but here is what I have:
ECOMtl->JobMtl
ECOMtl->PartMtl
PartMtl->ECOMtl
JobMtl->PartMtl

Do I need to regenerate the data model to have these work?

7

You don’t have to regenerate. I do think you probably just have something messed up with the mapping.

8

I guess is depends on what you need them for. I got mine from SQL - I did that a long time ago and I can’t remember if you need to regenerate or not. I don’t see PartMtl->JobMtl in your list and I think that’s the one you need.

Also, this is not correct. If you see it in method tracker then it’s in PartMtl, not JobMtl. It populates JobMtl when you create the job.

9

PartMtl->JobMtl isn’t in the list of possible mappings.

10

Shows up in my system. Remember that the source is the second column.

image
image795×376 17.3 KB

1 Like
11

That is JobMtl->PartMtl, which I do have. I listed them as Target ->Source.

12

Job material can’t be a source for part material. (the job can’t write directly to the master, you have to go job-> ECO → partmtl)

So I don’t know what you are trying to do…

13

I am trying to get the flag that is on the PartMtl record to get set in the JobMtl record when the Get Details is done for the job. I added the JobMtl-PartMtl since it didn’t work with the other ones. Obviously that didn’t help.

14

Can you show some screen shots of your setup? Maybe we can spot the problem. It should work.

15

Yes, that’s the one. So, when you bring in a revision into your Engineering workbench, that is source=PartMtl, target=ECOMtl. When you save the revision, it uses source=ECOMtl and target=PartMtl. When you create the job (with GetDetails from Actions) it uses source=PartMtl and target=JobMtl.

image

16

Well, it helps when you click the Enabled checkbox
image

Thanks for all the help!