Supplier Balance Aging Report Reconciliation

Summary:

We have created a custom report of all unpaid AP invoices as of a certain date, which should be the same as the Supplier Balance Aging Report (SBAR), but includes unaccounted invoices as well. It isn't. After removing the unaccounted invoices, I'm still left with several invoices on my report that aren't on the SBAR.

My report is looking to see if the invoice date is < = the parameter date. Also, if the invoice was paid at one point, my report ensures the paid date is > parameter date.

How can I figure out why they're not showing up? I've got about 20% invoices not showing up on the Supplier Balance Aging Report that are showing up on mine. These invoices are all accounted as of 7/31/2024.