AR and AP open items Reports not displaying invoices paid on a latter date

Hi

I am trying to extract AP and AR open items as at Dec 2024. When I use the open items revaluation report, I notice that invoices that were paid in subsequent years are not showing in the report. I tried the aging reports and the payables trial balance report, and they are all not able to give me accurate details of the invoices that were open and the exact unpaid amount as at Dec 2024. Would appreciate recommendations on which reports I can rely on.