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