What would be the easiest way to modify this BAQ to add customer name and last date shipped? Not sure which phrase build to include to get the appropriate values
JobQtyComparison.baq (22.7 KB)
Most people aren’t going to load your non descript BAQ in their system
What does the baq look like?
1 Like
Huh, I’ll admit I did not realize there was a JobProd.ShippedQty.
So, I mean the answer is a subquery grouped on Order/Line/Rel.
But, um, if you expect to know shipments from the job, then using that “MFG-STK” tran type is barking up the wrong tree. Those would be MFG-CUS.
Also, PartTran is not the speediest table since like here, for example, ours is up to 15 million rows… So really, I’m not sure why you have it in there anyway.
Maybe add ShipDtl to the subquery.