You can find the total on table AR_PAYMENT_SCHEDULES_ALL (AMOUNT_DUE_REMAINING column).
thanks a lot
earlier i was using ra_cust_trx_line_gl_dist_all rad. the column amount for the same ,
for one particular invoice there was difference in the value potrayed,
could you please let me know in which scenario is ra_cust_trx_line_gl_dist_all rad used
1 person found this helpful
RA_CUST_TRX_LINE_GL_DIST_ALL contains the accounting lines for the transactions. It does not store payments recorded against transactions. That's why you may have, for the same transaction, an amount in AR_PAYMENT_SCHEDULES_ALL and a different amount in RA_CUST_TRX_LINE_GL_DIST_ALL, if the transaction has been total or partially paid.