Finding the applied Entries from G/L Entry

(0) Share

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 (2)

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