Invoice payment history

(1) Share

Report

Posted on by santarzan

405

hi all .

As i am trying to generate a report that shows invoice detail along with the payment info that applies to the invoice, such as the check or checks no - journal no that went to pay for the invoice and the dates and amounts etc.

from where i can get all this details ,i searched in the customer ledger but dint find the details like against which invoice has been payed.

*This post is locked for comments

I have the same question (1)

All responses (7)

Answers (3)

Verified answer

Amol Salvi 18,698 on at

Like (1)

Report
Copy link

Link copied!

You can found it in Customer ledger entry table and look at the field Applies to doc type,Applies to doc no,Close by entry no etc. You can find the relation.

Was this reply helpful? Yes No
santarzan 405 on at

Like (0)

Report
Copy link

Link copied!

Applies to doc no comes blank all tho i use the apply document option for the payment

Was this reply helpful? Yes No
Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Have a Look at the table Detailed cust ledger entry.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It is total BS, not to mention sloppy lazy programming and design in NAV, that you can't just drill down in less than 2 steps to get this kind of information.

On a DAILY basis I curse the poor design that leads to screen after screen after screen after screen being opened in order to get this basic information.

2 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

The issue here is that one invoice can be applied to numerous payments, and visa versa. In most complex case, many invoices can be partly applied to many partials of payments. Thus, it could be difficult to visualize the application history within one flat report for the list of invoices. This is why the Customer/Vendor Ledger Entry table is not suitable basis for your report.

As recommended by other community members, you can press "Applies-To" button to check the list of documents, applied to the selected document. The correct basis for your report would be the Detailed Customer/Vendor Ledger Entry table.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check Page 61 and in Open Page of that it has the logic how to find the applied entries for that particular payment.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Check here.

I am able to see the related Application Entries in the following screen. Select any of the payment lines > Click Applied Entries option and you would get the Applied Customer Entries.

Was this reply helpful? Yes No