Filtering Records

(0) Share

Report

Posted on by jsshivalik

3,027

I have below code . I want those records which have +ve adjustment but consumption type should not be Export And Import. It is summing those records also which have Export & Import.

ILE[9].SETFILTER(ILE[9]."Entry Type",'%1',ILE[9]."Entry Type"::"Positive Adjmt.");
ILE[9].SETFILTER(ILE[9]."Consumption Type",'<>%1|<>%2',ILE[9]."Consumption Type"::Export,ILE[9]."Consumption Type"::Import);
IF ILE[9].FINDFIRST THEN REPEAT
Qty[9] += ILE[9].Quantity;
UNTIL ILE[9].NEXT=0;

Thanks

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

RobertasR 5,002 on at

Like (0)

Report

RE: Filtering Records

It should probably be '&' instead of '|'

ILE[9].SETFILTER(ILE[9]."Consumption Type",'<>%1&<>%2',ILE[9]."Consumption Type"::Export,ILE[9]."Consumption Type"::Import);

Robertas