Invoice keeps appearing as open to pay on payment batch weekly.

Summary:

We have a standard AP invoice with a payment status of "Fully Paid," and a prepayment invoice has been fully applied to it. Both the prepayment invoice and the standard invoice are validated, accounted for, and the prepayment application is also accounted for. There are no holds on either invoice. Additionally, the payment for the prepayment invoice has been fully accounted for.

However, when we run the custom AP Invoice Aging report, the standard invoice still appears, even though it is fully paid and accounted for.

Details:

• Standard Invoice GL Date: 21-Feb-2025 (including the prepayment application date)
• Prepayment Payment Date: 14-Feb-2025