How to filter for installment invoices in CLE?

Aravindh_Navision

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

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

Aravindh_Navision

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

should work. you just play around with the strings.

Aravindh_Navision

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

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

dans

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