Hi JK,

Thanks for the information thus far.

Are the 'current amounts' of these invoices and payments 0.00 or the same as the original amounts? If invoices and payments are equal and non-zero, then can we assume that the payments have not been applied to the invoices? And they should have been.

To rectify that situation, you need to create 'zero-dollar' entries in a manual check batch that apply to both the invoice and pre-payment (that net to zero).

If you have Payment transactions with a current amount equal to a non-zero value, this is indicative of corrupt data.
---
As for the almost 6000 integrity errors, having to do with home equivalent balances for customers and invoices, where the data has a stored value of zero but expecting non-zero (the calculated values), this relates to whether the current amount of the invoices are zero or not.

A 'PA' payment transaction typically comes from the system check processing function and will pay existing invoices and have a current amount of zero.

I wonder if your transaction matching file is missing information. If you print the Open Payables report for just that single vendor BRA01 and make sure the 'Applied Detail' checkbox is selected, do you see the payment listed underneath the invoice? If not, then the matching file is corrupt.

At some point, you may want to make a copy of your AP data and attempt the Rebuild on the copy. This will help identify if all those integrity errors is the cause of the report scenario, which I wouldn't doubt.