AP Invoice and Post Date

baq

(K White) #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?


(Toby Lai) #2

Under Subquery Options

Result Set Rows: Distinct


(K White) #3

aghh…didn’t try distinct.


(K White) #4

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