Hi
I have a requirement in one of the financials report. The customer has a report with details of Invoice like invoice number, amount, receipt transaction, receipt amount etc.
They need to calculate the Balance amount when each receipt paid against the invoice.
For example if the Invoice amount equals 80 and the same invoice has 2 receipts xxx = 75 and xx = 5. When the Balance is calculated for the first receipt the balance amount will be 5 and when the second payment is made the balance amount should be 0. Like shown in the screenshot below. I tried implementing some formulas but it doesnt give me the desired answer. For the second receipt my calculation goes as (80-5=75, where the balance should be 0).
Any suggestions or help would be appreciated.
Regards
Vyshak