Last Price for Part

[Asz0ka (Adam Szoka)]

You could determine the most recent selling price per part in a sub query (or two), then join the subquery into your top query.

Here’s a post detailing a similar problem/solution:

Struggling - BAQ Last Purchased Job Material

Lowest Level Subquery: [image] Group by fields checked on this screen (calc field not checked) [image] [image] Results (when switch to Top level query from inner subquery, switch back after) [image] You start with the PODtl, since that table holds the PartNum (which you need to group by so you can link it to its respective PO). I included the Company column for faster join time later on in the query. Now that you have the PONum and the part it’s tied to, you can re-join this subquery t…