Hi.
We just migrated from Epicor 9 to Epicor 10 and we have baq of 9 that had the functionality of first, last, now we want to replicate this function in specific tables
as the main one is partbin and we call parttran, rcvdtl
what is trying to do is that partbin brings me the amount I have in store and deposit, parttran I need to bring the trantype, trandate, tranqty, jobnum and rcvdtl the ponum
all with the last record of partbin where it was used in that job, date that left
I hope and you can help me
In SQL (what E10 uses) they are called aggregate functions. So you make a calculated field with Max(yourfieldhere), then group by the things you want to separate by. Look through the tool user guides on BAQs and you will see some examples.
1 Like