News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Finding the applied En...

Microsoft Dynamics NAV (Archived)

Finding the applied Entries from G/L Entry

(0) Share

Report

Report

Posted on by Olister Rumao

3,957

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Olister Rumao 3,957 on at

Like (0)

Report

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 3,957 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans