How do i use SETFILTER to avoid certain G/L Accounts

fmhigue · 2005-12-21

I got the following code

CompanyInfo.GET;
IF (CompanyInfo."Company ID" = CompanyInfo."Company ID"::"DSI MEX") THEN BEGIN

FromSalesInvLine.SETFILTER(Quantity,'>0');
FromSalesInvLine.SETFILTER("No.",'<>256002-0000');
FromSalesInvLine.SETFILTER("No.",'<>135014-0000');

It works but it only ommits one or the other G/L account.

If I do it like this it does not include any line
//FromSalesInvLine.SETFILTER("No.",'%1&%2','<>256002-0000','<>135014-0000');

Which is the right way to do it?

Thank u a lot

Marije_Brummel · 2005-12-21

Have you tried setting the filter manualy?

<>0100&<>0079

works in a cronus database.

Try:

FromSalesInvLine.SETFILTER("No.",'<>256002-0000&<>135014-0000');

kine · 2005-12-21

This is the correct format:

FromSalesInvLine.SETFILTER("No.",'<>%1&<>%2','256002-0000','135014-0000');

fmhigue · 2005-12-21

I did a few minutes ago. I really need to take a closer look on Forum history.

Thank you a lot

How do i use SETFILTER to avoid certain G/L Accounts

Comments

Categories