Filter item no sales price table tha not start (AR-)Problem

ahmedba

Hi guys i want to filter sales price table filed item no as example

AR-AGG

AR-AGG1

AR-CEMENT

AR-SAND

SAND

CEMENT

AGG

I need only show only items not start AR-

MEANING result what i need is

SAND

CEMENT

AGG

I make filter but it not work why :

Item.No. WHERE (Item Category Code=FILTER(FG),No.=FILTER(<>AR*))

after this i display data only (fg items) that show but items fg that start AR showing

Filter i need make filter to fg items and that not start AR-

Can any one show to me how i make filter to above.

geordie

If you are developing a report you can put the filters in OnePreDataItem trigger:

SETRANGE("Item Category Code",'FG');
SETFILTER("Item No.",'..AP|AT..');

Just a note: I'm not sure regarding the second filter, since on certain version SETFILTER("Item No.",'<>AR*'); couldn't be working as expected (see here).

ahmedba

Thank you for reply but i make that in form sales price not in report
can i do that by table relation or any filter on table sales price
because i have client license and and my version is dynamic nav 2009r2
thanks

geordie

ahmedba wrote:

Thank you for reply but i make that in form sales price not in report
can i do that by table relation or any filter on table sales price
because i have client license and and my version is dynamic nav 2009r2
thanks

Sorry, but I guess it's not possible to achieve this kind of filter in table relation.
You can consider also adding a new custom field on sales price table to categorize record which start by AR*: it's not a best practice at all using fixed filter.