I found the issue.

Our AP closed the month (Dec 2018) and year (2018). After closing, all of the invoices / credit notes that are December 2018 and prior that were paid/adjusted in Jan 2019 went to History table. So when I run the Age Overdue Payable using Calculate as of Dec 31, 2018. for some reason it does not see the invoices / credit note from History table.

Can someone please look into this if this is actually the issue?

On another subject, is there an option for the Age Overdue Payables (calculated as of) to not show vendor that are have zero balance?

Marlon Asuncion