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?
Under Subquery Options
Result Set Rows: Distinct
aghh…didn’t try distinct.
I tried that and it didn’t work. It just gave me zero results.