Hidden filter when calling a form from Item LedgerE

gregabor

Hi there,
I have a form 38 Item Ledger Entries which has a Source No. field, on which the assist button calls e.g. Customer table, namely form 22 Customer List. I only get active customers, i can tell that by using GETFILTER onOpen form 22.
I am breaking my head to find where this filter is being set, can anyone please give me a hint?

Thanks in advance and hello to all (my first post)!
Greg

kriki

Probably the filter is set in the OnAssist-trigger (or a function called in that trigger).
Probably it is user a FILTERGROUP to hide the filter on the form.

gregabor

Where can I can find that trigger and/or Filtergroup definition?

kriki

-Go into design.
-Select the field with the assistbutton.
-Hit F9
-Check the OnAssist-trigger.

gregabor

There is onAssistEdit trigger, however it is empty. Mind you, that is a list type form. Anywhere else it can be?

Really thankful for your help! :oops:

kine

gregabor wrote:

Hi there,
I have a form 38 Item Ledger Entries which has a Source No. field, on which the assist button calls e.g. Customer table, namely form 22 Customer List. I only get active customers, i can tell that by using GETFILTER onOpen form 22.
I am breaking my head to find where this filter is being set, can anyone please give me a hint?

Thanks in advance and hello to all (my first post)!
Greg

For me it seems that someone set the filter on the Lookup form for customers - open the form in designer and look for SourceTableView property of the form.

gregabor

SourceTableView was the first thing I checked and unfortunatelly it is <Undefined> :?

To provide more details, the form that is being called and is displaying only inactive customers, has this in the OnOpenForm:

FILTERGROUP(3);

IF GETFILTER(Inactive) = '' THEN
  SETRANGE(Inactive, FALSE);

FILTERGROUP(0);

I don't quite understand what filtergroup actually means or where it is defined.

kine

Filter group means that the filter is set in another "level" than user can define/change. It means that it is not visible and the user cannot remove it.

The code is customization made on request...

David_Singleton

gregabor wrote:

I don't quite understand what filtergroup actually means or where it is defined.

In this case you really should contact your NAV partner for assistance.

I know that the forums can help for learning, but here you have custom code that they modified for you, so best is to work with them to solve it.

gregabor

Thanks everyone to guide me through this, i didn't know where the problem was hidden. Filtergroup is something i just learned about - very nice thing 8)

kriki

PS : http://www.mibuso.com/forum/viewtopic.php?t=16659