SetFilter

(0) Share

Report

Posted on by jsshivalik

3,027

ILE[2].SETRANGE("Posting Date",StartDate,EndDate);
ILE[2].SETFILTER(ILE[2]."Entry Type",'%1|%2',ILE[2]."Entry Type"::Consumption,ILE[2]."Consumption Type"::Rev);
ILE[2].SETFILTER(Quantity,'>%1',0);
IF ILE[2].FINDFIRST THEN REPEAT
Qty[2] += ILE[2].Quantity;
MESSAGE('%1',ILE[2]."Entry Type");
UNTIL ILE[2].NEXT=0;

In message it is displaying +ve Adjustment , whereas i have filtered records on Entry Type "Consumption

Thanks

*This post is locked for comments

All responses (5)

Answers (2)

Verified answer

Rafael B. 715 on at

Like (0)

Report

RE: SetFilter

Hi

Take a look at this line:

ILE[2].SETFILTER(ILE[2]."Entry Type",'%1|%2',ILE[2]."Entry Type"::Consumption,ILE[2]."Consumption Type"::Rev);

You filter "Entry Type" field by option value from "Entry type" field (that's ok) and by option value from "Consumption Type" field (that's a mistake).
jsshivalik 3,027 on at

Like (0)

Report

RE: SetFilter

Hi

Can u pls tell me what is wrong in that Code.

Thanks
jsshivalik 3,027 on at

Like (0)

Report

RE: SetFilter

Hi

That's ok. But i want with Quantity > 0 & also Entry Type should be Consumption or Rev

Thanks
ManishS 78 on at

Like (0)

Report

RE: SetFilter

ILE[2].SETFILTER(Quantity,'>%1',0); here you are filtering quantity greater than zero.
Verified answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: SetFilter

TRY this.

ILE[2].SETRANGE("Posting Date",StartDate,EndDate);

ILE[2].SETFILTER(ILE[2]."Entry Type",'%1',ILE[2]."Entry Type"::Consumption);

ILE[2].SETFILTER(ILE[2]."Consumption Type",ILE[2]."Consumption Type"::Rev);

ILE[2].SETFILTER(Quantity,'>%1',0);

IF ILE[2].FINDFIRST THEN REPEAT

Qty[2] += ILE[2].Quantity;

MESSAGE('%1',ILE[2]."Entry Type");

UNTIL ILE[2].NEXT=0;