How can i set a filter by option field?

monir_asian · December 29, 2011, 9:19am

i want to set a filter for item ledger entry. entry type field when it is only sale, purchase and transfer.

itemledgerentry.setfilter(“entrytype”,=sale or purchase or transfer)

mohana_cse06 · December 29, 2011, 9:29am

Did you read SETFILTER help and syntax?

monir_asian · December 29, 2011, 10:02am

“Item Ledger Entry”.SETFILTER( “Entry Type”,‘Purchase|Sale|Transfer’);

i use this. but it shows all entry type as like positive adjustment,purchase, sales ,transfer.

mohana_cse06 · December 29, 2011, 10:08am

I am sure you didnt read the help…

Click Help–>C/Side reference guide in your navision

Click search tab in Help file

Type SETFILTER and Enter

Or Open Codeunit 12 and Find SETFILTER

mohana_cse06 · December 29, 2011, 10:14am

Use

“Item Ledger Entry”.SETFILTER(“Item Ledger Entry”.“Entry Type”,’%1|%2|%3’,
“Item Ledger Entry”.“Entry Type”::Sale,
“Item Ledger Entry”.“Entry Type”::Purchase,
“Item Ledger Entry”.“Entry Type”::Transfer);

monir_asian · December 29, 2011, 10:27am

thanks, it is working fine.