0_InventBeginBal_ForNetSuite.baq (19.0 KB) I need to return ONLY THE HIGHEST “Item Cost” record from this BAQ. It is only two columns with Item Cost being the secondary sort (descending) but I can’t seem to get it to work. Any help would be greatly appreciated.

Eliminate Duplicates, Return Only Highest Value

Hally (Simon Hall) April 11, 2019, 12:43am 3

Take a look at this post is has some good tips

Topic		Replies	Views
Max or Min Join on BAQ subquery? Epicor ERP 10 baq	3	4108	February 20, 2019
BAQ Subquery to return one row (TOP 1) Epicor ERP 10 baq	3	1300	March 9, 2024
First Function in Epicor Epicor ERP 10 e10 , baq	5	596	March 1, 2021
Best way to get a value based on a Max column BAQ Epicor ERP 10 baq	9	4483	November 1, 2019
Help with BAQ Epicor ERP 10 e10 , baq	5	881	May 5, 2020