Americas - Pacific Northwest - ID, OR, WA

Currently using E10.2.500.13

We have a case where we are giving a cash rebate to a certain customer, based on their current total AR balance.  With this rebate, we need to break in down to the line level, as some part groups receive a larger rebate percentage than other groups.

We use the Aged Receivables Report to get the total current AR balance, however I cannot find any report that gives any detail information.

Is there a way to get which invoice lines are applicable to the current open invoices with a balance?  Even if this is done with SQL, I’m good with that.  So far I have not found any detail records in the tables when it comes to open AR balances.

Thanks.