Get latest PartRev in a BAQ

[bderuvo (Bryan DeRuvo)]

You can use a subquery in the baq to return the Max value using effective date or revision number.

@ckrusen covered it pretty well here…

E10.0 - SubQuery return maximum transaction date (Bin Ex.)

Here is a simple BAQ that retruns the MAX(PartTran.TranDate) for each part and TranType SubQuery1 (obviously it was completed after Subquery2 was made) [image] Subquery2 (it could have more tables and joins) [image] Subquery2 display fields. Note that all but the calculated field are “Group By”. The expression for the calculated field is MAX(PartTran.TranDate) [image] Subquery1’s table relations [image] Subquery1’s display fields. Note that none are group by. [image] And the resu…