Does anyone have a AR Aging Saved Search that will match Standard AR Aging Report?

suiteanswer 85341 -

@Marc @Sam-I-Am Thanks for your response. I found out that the Search does not include those Invoices with future dated payment, while the Standard AR Aging Report still include those invoices. That's why I cannot tie it up.

you might be able to do that by using expression and nested criteria with "OR" statement. Meaning create two sets of criteria one with today Date = is on or before (click Custom > Day > Today) another one with Date = is on or after (click Custom > Day > Today) separated by "OR" statement. In theory it should include all the invoice in the future too - never tested that.

What is invoice with future date payment ?? If the invoice is open , the invoice appears in your saved search

This criteria with only show today or before due dates invoices

I cannot use expression to date since I need that for filters

just remove it from criteria, then all the invoices with remaining balance will show

Still not balance @Sam-I-Am