Functional Applied Amount

Dear All,

How do I get the applied amount in functional currency I would like to obtain the same functional amount exists in (Receivable Responsibility – Transactions – Balance,’Check radio button for Functional Amount to see amount in functional ’).

I have been through ar_receivable_applications_all table and it shows the amount with gain(acc_from) and loss(acc_to), also ar_payment_schedules shows only the total amount.

Thanks in Advance,