I wrote a BAQ where I want to know customer that Pay their invoices Today.
I linked the Invoice Head to the Cash Detail.
I have criteria where CashDtl.TranDate = now using current Date + Specified Interval.
it is returning records where the CashDtl.TranDate is blank.
Is there a better way to do this?