News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Filter item no in sale...

Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Report

Posted on by ahmed barbary

4,548

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 not 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.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Daniele Rebussi 2,480 on at

Like (0)

Report

RE: Filter item no in sales price table that not start (AR-) Problem

Moreover you can consider also adding a new custom field on sales price table to categorize records which start by AR* and using it for filtering purpose: it's not a best practice using hardcoded filters.
Suggested answer

Daniele Rebussi 2,480 on at

Like (0)

Report

RE: Filter item no in sales price table that not start (AR-) Problem

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans