How to filter for installment invoices in CLE?

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.

Comments

  • dansdans Posts: 148Member
    You can use asterisk (*) in setfilter to filter the entries. Ex: INV12345-*
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
  • Aravindh_NavisionAravindh_Navision Posts: 229Member
    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.
  • dansdans Posts: 148Member
    should work. you just play around with the strings.
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
  • Aravindh_NavisionAravindh_Navision Posts: 229Member
    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?
  • AgannaloAgannalo Posts: 9Member
    edited 2018-10-10
    CustLedgerEntry.SETFILTER(CustLedgerEntry."Document No.", '%1-*',InvoiceNo);
  • dansdans Posts: 148Member
    SETFILTER("Document No.",'%1-%2',InvoiceNo,'*')
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
Sign In or Register to comment.