I am tasked with creating a way to display information from JobHead, JobOper, JobOpDtl, and PartTran. The user will select a Resource Group from a combo box (easy enough done), and then get a listing of all operations that are scheduled out between GETDATE() and 2 weeks. That is easy. The hard part…

You can’t use the word SELECT In a BAQ, you need to use a SubSelect Subquery. Move that Subselect to its own Subquery, then bring that whole Subquery into the calculated field {Subquery1}

BAQ Woes

Epicor ERP 10

gpayne (Greg Payne) November 8, 2021, 10:52pm 9

@jhecker Here are some tips from a thread about baq speed.

Topic		Replies	Views
BAQ Challenge - How to convert this SQL with sub-selects (as Calc'd fields and where clauses) to a BAQ Epicor ERP 10 baq	21	6369	February 25, 2019
BAQ TEST Performance Epicor ERP 10 baq	12	2616	March 24, 2022
Using Count() in BAQ - Incorrect Syntax Epicor ERP 10 baq	17	7193	December 20, 2022
BAQ equivalent for this SQL Query? Epicor ERP 10 baq	1	655	May 12, 2021
More MAX PartTran.TranDate problems in BAQ Kinetic ERP baq	18	1276	July 14, 2023

BAQ Woes

Related Topics