Man I just cannot get this new BAQ in E10 down. Just struggling my you know what off. This sounds sooo simple but yet I cannot get it to work. They want a dashboard filtered by job showing all purchased materials and the last Unit Cost and PO Date.
I created a BAQ with JobMtl in the top query and it’s criteria.
A SubQuery with PODetail and POHeader. Related the subquery to the top by PartNum. Set the subquery to Top and then TopDistinct… Tons of repeats. Played with GroupBy which makes no sense to me as to do I check it in the Top query or the subquery…
Obviously I’m frustrated and am looking for BAQ courses specific to subqueries.
Any help would be appreciated.