More MAX PartTran.TranDate problems in BAQ

You cannot show Max(date) and also Job Num , PO etc from part tran cause that’s not how SQL grouping works. SQL aggregate grouping groups like fields… jobs are all going to be different so you’ll get one row per job and or PO.

You can use some of the techniques that @Banderson outlined here in his presentation to do what you want like Windowing Function and Ranking.