[wp-disclaimer id="1282"]


How do I get the First/Last record in a BAQ?

Epicor®10 has brought about countless improvements. Along with those improvements came some changes to BAQs. One of which is how BAQs get the LAST record in a table or the FIRST record in a table (i.e. FIND-FIRST, FIND-LAST).  Previously (on Epicor® 8 and 9), it was a toggle selection on a table, but now there is much more involved, and for good reason.  Through Epicor’s® powerful SubQueries, you can get the first record or last record in a table.  If you’re having difficulty with your BAQs