Only AROBL needed.

We need to be able to only pull the payments posted in the previous 7 days.

AROBL.TRXTYPETXT = 11 

TRXTYPETXT Integer  
List Presentation with 8 items in the list:
1 - Invoice
2 - Debit Note
3 - Credit Note
4 - Interest
5 - Unapplied Cash
10 - Prepayment
11 - Receipt
19 - Refund

Does this table have the cash receipt posting date? Ty.

Yes

This table contains the invidivual transactions. How can we link a payment with its corresponding invoice to determine if there is an open balance? Any suggestions will be appreciated.

Then you need to use AROBP, too.

Ty. I guess our initial approach is correct.