Thanks Sabu. Ok i’ll try to explain it using example.
Payment A, amount 1000, remaining amount 200. Invoices Paid:
Payment B, amount 500, remaining amount 300. Invoices Paid:
Inv A, amount 1200, applied amount by Payment A 300, applied amount by Payment B 150, remaining amount 750
Inv B, amount 700, applied amount by Payment A 500, remaining Amount 200
Inv C, amount 200, applied amount by Payment B 50, remaining Amount 150
If I go to payment, & look at applied entries, there is no applied amount for each invoice.
For example, if I go to Payment A & look at applied entries. It only shows:
- Inv A, amount 1200
- Inv B, amount 700
So there is no applied amount (300 for Inv A, 500 for Inv B).
If I look to remaining Amount column of Inv A, there is detailed entry for Inv A with document No = Payment A, with amount = 300 (its mean, payment A paid 300 to Inv A, this is the information that I want)
The problem is, how I do this in report?
The report wants to show, the payment with its applied invoices informations (inv no, inv amount, applied ammount).
Hope my explanation can clear my question. Sorry for my english.