Logic behind active operation BAQ ECOOpr

Epicor ERP 10
1

We have made multiple changes to the Method of Manufacturing (MOM) for the same part revision. When I create a BAQ to get a list of the Operations within a MOM, I receive duplicates - I believe because of different Group IDs. How can I tell which Operation is the active one?

Thank you in advance!

MOMs_Operations.baq (42.3 KB)

2

Your Query is

select 
	[Part].[PartNum] as [Part_PartNum],
	[Part].[PartDescription] as [Part_PartDescription],
	[ECOOpr].[RevisionNum] as [ECOOpr_RevisionNum],
	[ECOOpr].[OprSeq] as [ECOOpr_OprSeq],
	[ECOOpr].[OpCode] as [ECOOpr_OpCode],
	[ECORev].[AutoRecOpr] as [ECORev_AutoRecOpr],
	[ECORev].[FinalOpr] as [ECORev_FinalOpr],
	[ECOGroup].[GroupID] as [ECOGroup_GroupID],
	[ECOGroup].[ECO] as [ECOGroup_ECO]
from Erp.Part as Part
inner join Erp.PartRev as PartRev on 
	Part.Company = PartRev.Company
	and Part.PartNum = PartRev.PartNum
inner join Erp.ECOOpr as ECOOpr on 
	PartRev.Company = ECOOpr.Company
	and PartRev.PartNum = ECOOpr.PartNum
	and PartRev.RevisionNum = ECOOpr.RevisionNum
inner join Erp.ECORev as ECORev on 
	ECOOpr.Company = ECORev.Company
	and ECOOpr.GroupID = ECORev.GroupID
	and ECOOpr.PartNum = ECORev.PartNum
	and ECOOpr.RevisionNum = ECORev.RevisionNum
	and ECOOpr.AltMethod = ECORev.AltMethod
inner join Erp.ECOGroup as ECOGroup on 
	ECORev.Company = ECOGroup.Company
	and ECORev.GroupID = ECOGroup.GroupID
where (Part.TypeCode = 'M'  and Part.OnHold = FALSE)
order by Part.PartNum, PartRev.RevisionNum, ECOOpr.OprSeq, ECOOpr.OpCode
3

If you ask me you should not be using ECORev, ECOMtl, ECOOpr tables but instead

PartRev, PartMtl, PartOpr. Those are the real deal. That is where the ECO tables get commited to upon Check In.

2 Likes
4

By the way if anyone is looking for a Recursive PartMtl BAQ – I forgot I had this laying around.

RecursivePartMtl.baq (53.0 KB)

2 Likes
5

Hey, now there’s a useful BAQ. Thanks for sharing!

Joe

6

Thank you! Still new to Epicor and am learning every day. Greatly appreciate it