Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Loop all of the Entrie...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Alexander Ermakov 28,094 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans