Hello all,
It turns out we have a lot of parts where their most recent revision is not approved, I believe due to when we first migrated onto Epicor. However, it is causing issues with our MRP runs, is there a way to pull a list of all the parts without an approved revision, without pulling in parts that do have an approved revision?
Thanks!
Have you tried writing a BAQ on partrev and looking for approved = false?
I did try that, but if a part has an approved revision and an unapproved revision, it would pull that part, even though I only want parts that have no approved revisions
I use a similar query for updating part revisions and creating new ones so I am normally looking for the latest part rev approved. You could put a condition on the date if you know what the effective date is. Alternatively, you could pull all the ones with approved revisions and then exclude those part numbers from the query results with part numbers contained and make a constant list of those item numbers and then check the “not” check box.
To get all parts with no approved revision make a BAQ on PartRev, add the partnum field and group by that, then do a calculated field (int) that is: min(convert(int, PartRev.Approved))
Anything that returns a 0 in your calculated field has no approved revision.
This is awesome! Thanks so much 
I added a criteria for Approved = False and it pulled up the whole list I needed