Filter on customers on the Sales Order page

poppins

Hi everyone,

I want, when drilling down on Sell-to Customer No. on page 42, to exclude the blocked customers from the displayed list.
How can I do that?

Thanks in advance

postsaurav

Hi Poppins,

Just Design Table 36, select Field 2 (Sell-to Customer No.) and Properties.

Change the TableRelation Property

>> From Customer

TO Customer WHERE (Blocked=FILTER(' '))

Let me know if any issues.

poppins

postsaurav wrote: »

Hi Poppins,

Just Design Table 36, select Field 2 (Sell-to Customer No.) and Properties.

Change the TableRelation Property

>> From Customer

TO Customer WHERE (Blocked=FILTER(' '))

Let me know if any issues.

Thank you for your answer...
I added a custom field "Ending Date" and I want to set a filter on it...

I can't do it via table relation so I tried to generate a filter via codeunit 46 (procedure GetSelectionFilterForCustomer()).
but when drilling down on the Sell-To Customer No. field, I get the following error message:

The filter "1000..6010|7010..7123|(7126..9810|TEST)|X95000" on the Sell-to Customer No. field in the Sales Header table has no single range of possible values.

Is this form of filter unacceptable for RTC?

What shall I do?

postsaurav

Hi Poppins,

Always create a New Thread for a new Issue. This help others to find resolution.

Mark this question as Resolved and your another question should be in a new thread / Question?

Verndroid

In my opinion that kind of filter indicates that you are looking at whatever issue you have in the wrong way. You should not have to create that kind of filter.

With regards to your issue with "blocked" I would not change the table relation on table 36 as that will change the lookup logic everywhere, where table 36 is used. I would alter page 42 and add code on "OnLookUp" trigger of the "sell-to customer no." to handle your specific requirement.