How to filter Doc No Starting with OPE?

chandrurec

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.

crisnicolas

Push F1.
Read the topic under Content - Welcome to Microsoft Dynamics NAV Help - Using Microsoft Dynamics NAV - Entering Criteria in Filters

geronimo

ItemledgEntry.SETFILTER("Document no.",'%1*','OPE');
or
ItemledgEntry.SETFILTER("Document no.",strsubstno('%1*','OPE'));