I am trying to get some simple data on all approved parts in the system that pulls the LaborEntryMethod type on all approved part revisions.
For some reason, there are duplicates that I am seeing on the LaborEntryMethod screen which does not match with what I am actually seeing in Epicor.
Does anyone know where this duplicates are coming from? The “T” line does not match the approved rev in Epicor but is showing up in the BAQ like it is approved.
I am using the “Group-By” function on all columns to remove duplicate rows.
I have decent experience with BAQ’s - although am not proficient with subqueries and such, but this has me stumped.
can you show us the join to ECOOpr? Also @Banderson does this thing where he brings the sysrowID over from each table and the table that shows two distinct Guids is the table that has the multiple rows.
Don’t use the ECO tables! (I’ve said this 1000 times and I’ll say it 1000 more) They are temp tables that (in my opinion) should be cleared when the parts are checked back in, but epicor does not. If you check out the same part in a different ECO group, it will show up twice because it was checked out in different ECO groups. Show the GroupID field and you’ll see that
Use the PartOpr table instead. That’s where the Engineering Workbench writes to when the parts get checked back in.
