Is there a field in E10 (10.2.400) that will identify that a part has a Method of Manufacture (MoM)?
The PartRev table. Do you have an approved revision? But even then you could have an approved rev with nothing in it.
1 Like
A MOM has two components: materials and operations. You could create a BAQ that joins Part and EcoMtl and Part and EcoOpr. Select all from Part and only the matching ones from the other two tables.
Part | Part from EcoMtl | Part from EcoOpr
The records without values in the EcoMtl and EcoOpr do not have any MOM components. Those with values in those columns have materials or operations or both.
But… just because there are MOM components does not mean there is a approved rev, etc.
Yes and no. Production parts have Part, PartRev, PartOpr, PartOpDtl and PartMtl. Those drive jobs, MRP, PO Suggestions, etc.
Parts in the workbench have the parallel EcoRev, EcoOpr, EcoOpDtl and EcoMtl (which are children of the Part master), but those don’t do anything outside of the EWB. They are in WIPwhen checked out, and once checked in they are kind of a half-assed revision history.
This. If you want to see empty moms, you just have to left-join PartOpr and PartMtl and add CASE statement to your query that returns true/false if (e.g.) PartOpr.PartNum IS NULL.
2 Likes
