Filter

Finance and Operations/AX User Forum
1

hi friends,

I was wrote a look method in form Data Source Level.

It shows like that

PurchId PurchName Status

23456 Lcd TV Open Order

258963 Black Open Order

my problem is while am select Filter by Field in Status Field.And am entered Invoiced means its alaso displayed.

but my requirement is only display the open order not others Like Invoiced,Receive…

Pls any one help form that in Ax 2009…

2

what did you mean by my problem is while am select Filter by Field in Status Field.And am entered Invoiced means its alaso displayed.

3

hi Mr.Krishna

here i show its lookup for Purchase number value is PurchStatus::OpenOrder in Look up method.

5875.lookup.png
5875.lookup.png774×397 16.3 KB

7802.lookup3.png
7802.lookup3.png774×397 38.9 KB

In lookUp Status Field i was use filter by invoice means it shows like that belo5226.lookup4.pngw

i want only open order Status.
How can i validate that.I hope you understand that…

4

can you post your code

5

You can lock the range (status(RangeStatus::Locked)), but I wonder why you bother at all. Lookups exist just to help users, if they want to mess with a lookup, it’s their problem. They also don’t have to use lookups at all, they can copy values from other places or type them manually.

That’s why limiting a lookup is not enough - you need a validation in validateWrite(). And if you have a proper validation, you normally don’t care if somebody mess with filters in a lookup.