I must be missing something somewhere, but in BAQ where do you set the option for DISTINCT ?
I want the query to look like;
SELECT DISTINCT
field1
, field2
FROM table ....
Where in the BAQ UI is this option? Or if it isn’t then how would you go about achieving that? Would you hack away with GROUP BY? Tell me Epicor didn’t leave functionality this out. (version 10.2.400)