web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Finding the applied En...
Microsoft Dynamics NAV (Archived)

Finding the applied Entries from G/L Entry

(0) ShareShare
ReportReport
Posted on by Olister Rumao 3,963

Hi All,

In G/L Entry I'm filtering payment entries having Balance Account type as Customer. I want to find the list of Invoices that are being balanced with the corresponding payment. I'm not sure what filter should I apply in Detailed Customer Ledger Entries to find the list of Invoices. I tried finding the relation as GLE.DocumentNo -> CLE.DocumentNo & CLE.Entry->DCLE.Applied Cust. Ledger Entry No. where CLE is Customer Ledger Entry, DCLE is Detailed Customer Ledger Entry and GLE is G/L Entry.

*This post is locked for comments

I have the same question (0)
  • Olister Rumao Profile Picture
    Olister Rumao 3,963 on at
    RE: Finding the applied Entries from G/L Entry

    The only issue I'm facing is

    Finding out the multiple payments with multiple Invoices For Eg:

    Payment 1 of Amount  $30

    Payment 2 of Amount $600

    Invoice 1of Amount $330

    Invoice 2 of Amount $300.

  • Olister Rumao Profile Picture
    Olister Rumao 3,963 on at
    RE: Finding the applied Entries from G/L Entry

    I guess I've found the relation

    GLE.DocumentNo.=CLE.DocumentNo.

    CLE.EntryNo. =  DCLE.Applied Cust.Ledger Entry No.

    DCLE.Cust.LedgerEntryNo. =  CLE2.EntryNo.

    Can anyone verify if I've got it correct?

    I've tried for few entries didn't get any issue just I'm not sure if it will work for other complex entries as well

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans