Loop all of the Entries in Detailed Cust. Ledger Entries in Report

(0) Share

Report

Posted on by Community Member

HI all,

once again, I'm going to ask for help,

I'm modifying a standard report (Statement) so that it would display all of the applied amount in the column that i replaced in the report, that is in every entry in the Customer Ledger. Entries (which can be seen in the Detailed Cust. Ledger Entries.) with the Document type of Invoice.

I already have filtered the values of the applied amount in each Line in Cust. Ledger Entries.

However,

I only get the last Applied paid amount in my report.

also, the tabledata in the report is grouped on currencygroup.

whenever I MESSAGE the values in my filter.

It messages all of the values i wanted. but not in my report.

thank you to whoever answers my question

*This post is locked for comments

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: Loop all of the Entries in Detailed Cust. Ledger Entries in Report

I'm modifying the report Statement, and I have these columns

"Debit" and "Credit"

It can show all of the Invoices in the Cust. Ledger Entries on the "Debit" Side,

but in the "Credit" Side,

it only shows the latest payment.

and what I want to achieve in the "Credit" Side is that it should display all of the payments

done within the Invoice. in the Cust. Ledger Entries. that is in the Detailed Cust. Ledger Entries.

thank you again.
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Loop all of the Entries in Detailed Cust. Ledger Entries in Report

What exactly result do you want to achieve? Perhaps, there is a standard report already that will show you the needed info, e.g. Customer - Payment Receipt Report

https://msdn.microsoft.com/en-us/library/hh178990(v=nav.90).aspx