Merge pull request #28693 from frappe/mergify/bp/develop/pr-28627

fix: Paid invoices showing in AR/AP report (backport #28627)