Our client has a customised item form (Form 50070). When I login in as 'abc' and open this form, there is a filter "Location Filter" = A123. In particular, this means that I only see the inventory for location A123.
User 'abc' does not see this filter in the usual item form (Form 30), so the total inventory for the item is visible from Form 30.
When user 'abc' logs in at the same time from a different machine, the filter does not appear on Form 50070, but it does appear when a different user logs in on the same machine.
So the filter is somehow associated with Form 50070 when opened from a particular machine.
Even when I restart the machines that host the client and server (this is not the actual client database of course, just a copy) the filter is still there.
I checked the user's security filter (Tools - Security - Database Logins - Roles - Permissions) for form 50070 and it's empty.
This doesn't look like it's being set through code, and in fact:
1. Form 50070 was last modified years ago, whereas this filter only appeared in the last few days.
2. When I turn on the debugger I can see the filter even before the first line of code in OnOpenForm has been executed.
Do you know how I can remove this filter?
Thanks in advance.
Alastair
Alastair Farrugia
0
Answers
Just copy it somewhere then delete it and see if the filter is still there
Have you tried to remove the filter (Shift+Ctrl+F7), close NAV and login again?
Is the filter still there then?
Tino Ruijs
Microsoft Dynamics NAV specialist
I should have known that, but for some reason I couldn't find the zup file last week. I found it now, in
Documents and Settings\afarrugia\Application Data
Nice. 8)
But removing the filter should have been enough.
That way you can keep your other settings.
Tino Ruijs
Microsoft Dynamics NAV specialist
Actually, when I pressed Ctrl+F7, the filter didn't appear, but when I looked up field "Location Filter" it showed that it was filtered to A123.
I don't know if this is standard behaviour for FlowFilters.
You have to remove a flowfilter in the form that's opens with Shift+F7.
Tino Ruijs
Microsoft Dynamics NAV specialist
I think this will save me a lot of time in future.
Tino Ruijs
Microsoft Dynamics NAV specialist
Sometimes if You dont want to remove all personal setting of user with "problem" filter by delete Zup file, You can just compile form in which user can't remove filter.
In this case You remove all zup setting on this form for all users. Most of customers have basic form designers and can hadle this situation on their side.
Regards
I just tried this, and when I compiled without saving, the filters remained there. But when I saved the form, the filters were removed.