How to get applied payments for a invoice.

Hi all,

I'm having a problem with getting applied entries for a sales invoice.

In Dynamics NAV, there can be many scenarios when applying a payment to a invoice.

  • Applying a  pre-payment to a invoice.
  • Apply a payment for the invoice after the payment posted.
  • Apply a invoice a for a payment after the invoice posted.
  • Apply partial amounts from invoice/payment.

There can be many more scenarios. 

My requirement is to show payments for a invoice in a report. I tried to get the details from Cust. Ledger Entries (CLE), but in CLE, I can get applied entries for a invoice/payment from "Applied Entries" button on the ribbon. but the applied entries shows the entry with the full amount of the payment, If I applied half amount from a payment to a invoice, the applied entry does not shows the applied amount. 

When I go to the Detailed Cust. Ledger Entries, it shows the correct entry with applied amount, but, If I apply a payment to a invoice (from CLE I select the invoice -> Apply Entries -> select the payment & apply) the Detailed Cust. Ledger Entries shows the invoice as the applied entry to the invoice.


Is there any way of getting this information?

I want to get payments applied for a invoice.