How to filter Doc No Starting with OPE?

chandrurec
chandrurec Member Posts: 560
edited 2010-11-18 in NAV/Navision Classic Client
Hi all,

I need to filter all the document number which starts with the value OPE in Item ledger entry.

If anyone knows how to filter using SETFILTER, Kindly tell me the syntax to achieve.

Thanks in advance.

Regards,
chandru.

Comments

  • crisnicolas
    crisnicolas Member Posts: 177
    Push F1.
    Read the topic under Content - Welcome to Microsoft Dynamics NAV Help - Using Microsoft Dynamics NAV - Entering Criteria in Filters
  • geronimo
    geronimo Member Posts: 90 
    ItemledgEntry.SETFILTER("Document no.",'%1*','OPE');
or
ItemledgEntry.SETFILTER("Document no.",strsubstno('%1*','OPE'));

Categories