How to filter for installment invoices in CLE?

Aravindh_Navision · 2018-09-26

Hi Friends,

[Version: NAV 2009 Classic]

In Posted Sales Invoice there is an invoice no.12345. This invoice has multiple installments (say totally 10 installments) and in Customer Ledger Entry the transactions Document No. looks like..

INV12345-01
INV12345-02
INV12345-03
.
.
.
INV12345-10.

I need to sum-up the remaining amount in Customer Ledger Entry by filtering for Invoice No. 12345. Can anyone let me know how to do this?

Thanks in advance, Aarvi.

dans · 2018-09-30

You can use asterisk (*) in setfilter to filter the entries. Ex: INV12345-*

Aravindh_Navision · 2018-10-03

Thanks for your reply dans.

Will it work if the main invoice no. is 12345 and the Installment No. (Document No. in Cust. Ledger Entry) is INV12345-1..INV12345-10? Also, there are multiple invoices there as in this pattern.

dans · 2018-10-04

should work. you just play around with the strings.

Aravindh_Navision · 2018-10-10

I need to use filter something like this.

CustLedgerEntry.SETFILTER(CustLedgerEntry."Document Type", 'Invoice');
CustLedgerEntry.SETFILTER(CustLedgerEntry."Document No.", InvoiceNo);

Values in table: CustLedgerEntry."Document No."

INV12345-01
INV12345-02
INV12345-03
.
.
.
INV12345-10.

Value: InvoiceNo

12345

How to filter CustLedgerEntry."Document No." and InvoiceNo?

Agannalo · 2018-10-10

CustLedgerEntry.SETFILTER(CustLedgerEntry."Document No.", '%1-*',InvoiceNo);

dans · 2018-10-11

SETFILTER("Document No.",'%1-%2',InvoiceNo,'*')

Howdy, Stranger!

Quick Links

Categories

How to filter for installment invoices in CLE?

Comments