how we can get paid invoices as unpaid when run on as on date?

we have a requirement that AP invoice payable report show data of unpaid invoices including paid invoices, which were unpaid when report run on as on date.

for example:

invoice date is 07-JUN-2023

payment date is 07-JUL-2023

Report Parameter As on date : 30-JUN-2023

this invoice should come in the report query .

need help to how to cover this type of scenario.