I
Iconiq
Guest
I need to join the TranGLC table to the APInvDtl table in Epicor 905 in a Business Activity Query.
I am currently joining on Company, VendorNum, InvoiceNum, InvoiceLine, JobNum and can't see any other columns that would be suitable for the join.
My problem is that join does not uniquely identify the records in the APInvDtl table, so if my query returns 14 rows from TranGLC, when I join the two tables, I get 196 records.
In sql I can use the Distinct key word, and I get the results I'm looking for, but I can't see a way to do that in the BAQ editor.
I can also get the results I"m looking for by using a SQL group by, but again, I don't know how to do that in the BAQ editor.
I've researched ABL, and it looks like you can do a first-of in ABL code that might behave in the same way group by does, but I can't see how to do that in the BAQ editor either.
Any suggestions on how to remove the duplicates from the result set would be greatly appreciated.
Continue reading...
I am currently joining on Company, VendorNum, InvoiceNum, InvoiceLine, JobNum and can't see any other columns that would be suitable for the join.
My problem is that join does not uniquely identify the records in the APInvDtl table, so if my query returns 14 rows from TranGLC, when I join the two tables, I get 196 records.
In sql I can use the Distinct key word, and I get the results I'm looking for, but I can't see a way to do that in the BAQ editor.
I can also get the results I"m looking for by using a SQL group by, but again, I don't know how to do that in the BAQ editor.
I've researched ABL, and it looks like you can do a first-of in ABL code that might behave in the same way group by does, but I can't see how to do that in the BAQ editor either.
Any suggestions on how to remove the duplicates from the result set would be greatly appreciated.
Continue reading...