AP Invoice and Post Date

Epicor ERP 10
1

I am working on a BAQ for AP Invoices. I need to capture the Post Date for the AP Invoice. I have joined the GLJrnDtl talbe but I am getting duplicate rows; I am guess from the GL having both the Debit and Credit entry. I tried to just pull criteria on the GLJrnDtl of DebitAmount > 0 but I still get double rows.
thoughts?

2

Under Subquery Options

Result Set Rows: Distinct

3

aghh…didn’t try distinct.

4

I tried that and it didn’t work. It just gave me zero results.