Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
OnOpnePage Filter doesn't work in Lookups
MChilari
Member Posts: 47
Hi Experts,
I have added a user based Filter on OpenPage() of the Item List and it works fine if we open the Item List from the Role Center or any other Action Item.
When i open the Item List from Sales Line or Purchse Line Pages ("No." Field), the filter is not applying to the Item List. I know that the Item List is showing based on the "DropDown" property of the Item-Field Group. Even if i remove the Field Group system is not applying the filter.
Can somebody tell me the trick on How we can apply the Filters to the Item No. lookup of the Sales Line or Purchase Line. These filters are based on User so i can't specify these in Table Relattion.
Thanks for your help!!
Thanks
MC
I have added a user based Filter on OpenPage() of the Item List and it works fine if we open the Item List from the Role Center or any other Action Item.
When i open the Item List from Sales Line or Purchse Line Pages ("No." Field), the filter is not applying to the Item List. I know that the Item List is showing based on the "DropDown" property of the Item-Field Group. Even if i remove the Field Group system is not applying the filter.
Can somebody tell me the trick on How we can apply the Filters to the Item No. lookup of the Sales Line or Purchase Line. These filters are based on User so i can't specify these in Table Relattion.
Thanks for your help!!
Thanks
MC
0
Comments
What you need to do (as far as I know) is to put code in OnLookup on the table and manually open the advanced lookup page - which then applies the filter.
You won't have the filter as you type then - but that is the price you will have to pay.
Group Program Manager, Client
Microsoft Dynamics NAV
http://blogs.msdn.com/freddyk
The information in this post is provided "AS IS" with no warranties, and confers no rights. This post does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion.
Thanks for the Reply!!
Writing code in onlookup will be a big Task, in my case i need to apply a filter to "Vendor List" based on User. I need to write code in every where "Vendor No." Exists, i think it's really a big task.
Any other suggestions !!
Thanks
MC
I wrote code in OnLooup to solve the issue, but Now i lost NAV Sorting/Filterting Feature. Previously when i type '1' in Item No. field, system automatically filters the Items and shows them, now it doesn't do that. Any Ideas?
Thanks
MC