How to get applied payments for a invoice.

Business Central/NAV Developers Forum
1

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.

Thanks.

2

Which version you are using? NAV 2016 and NAV 2017 has Remaining Amount field in the Sales Invoice Header table. Which shows applied payment as well applied Credit notes. Hope it helps you.

3

Think you are in the right place already. But first let me understand exactly how you apply a partial payment today? Sometimes these can be tricky. If the payments have not been applied correctly in the first place, then no report can fix that.
If they have been applied correctly, then the CLE will also be correct.

4

Hi Dileepa,

Thanks for the reply. but it is the same as in CLE → Detailed Cust. Ledg. Entry.

5

Thanks All for replies. I’ll describe this further more. This is how I do it.

  1. From CLE, select the invoice.
  2. Go to Apply entries.
  3. From Apply Entries window, select the cash receipt.
  4. Enter the amount to apply.
  5. Post the application.

1.PNG
1.PNG901×334 76.8 KB

After the posting done, when I go to CLE,

2.PNG
2.PNG863×519 114 KB

  1. Select the Invoice.
  2. Go to Applied Entries.
    • This shows the cash receipt entry which I applied. But I can’t get the applied amount.
  3. Go to Detailed Cust. Ledg. Entry.
    • This shows the initial invoice entry.
    • Then the applied entry with the applied amount. But I can’t get the cash receipt document no.

How do I get the applied cash receipt document no with the applied amount ?

6

Hi Sriyantha,
I see what you mean. Just tried it in Cronus and can confirm this behavior.

I think the reason nobody reported this before is that this is not the way a normal A/R clerk would work. They would always apply the payment directly to the different invoices, when entering the payment in the payment journal.
And when you do it in that order, then it will show you the “correct” payment document no.
You can try your own example, just start with the payment CLE instead of the invoice.

7

Hi Erik,

Thanks, But my customer do it in in both ways.

8

Hi All,

here is the solution,

Get Applied Documents

Thanks.