Filtering Cue Groups

Troubles_In_Paradise · 2011-05-10

Hi guys!
I'm wondering someone has already faced a problem like this.
I've to filter cue groups of the Role Center, according to the Responsiblity Center chosen by the user during the login.
To do this I created a FlowFilter in the table "Sales Cue"

Enabled	Field No.	Field Name	Data Type	Length	Description
Yes	   50000	  RC Filter	Code	           10

Now I placed this code in the trigger OnOpenPage() of the part "SO Processor Activities"

CLEAR(UserSetup);
SETFILTER("RC Filter",UserSetup.GetSalesFilter);

but it doesn't work. have you got an idea about what I missed?
PS: I saw a colleague of mine that use this method and it works, but I can't find what is the difference.
Thx a lot in advance!

mohana_cse06 · 2011-05-10

Where are you getting usersetup?
UserSetup.GET;

Troubles_In_Paradise · 2011-05-10

mohana_cse06 wrote:

Where are you getting usersetup?
UserSetup.GET;

Hi Mohana, I found the solution.
It was my fault :oops:. I forgot to change the calcformula to all FlowFileds in the SO Activieties.
Here an example

Sales Orders - Open CalcFormula
Count("Sales Header" WHERE (Document Type=FILTER(Order),Status=FILTER(Open),Responsibility Center=FIELD(RC Filter)))

Now works!
Thx

mohana_cse06 · 2011-05-10

Can you confirm whether this is required or not? :-k

UserSetup.GET;

Troubles_In_Paradise · 2011-05-10

mohana_cse06 wrote:
Can you confirm whether this is required or not? :-k
UserSetup.GET;

I confirm that isn't required :thumbsup:

mohana_cse06 · 2011-05-10

From where do you get UserSetup.GetSalesFilter?

Troubles_In_Paradise · 2011-05-10

mohana_cse06 wrote:

From where do you get UserSetup.GetSalesFilter?

It's the function GetSalesFilter defined in the codeunit User Setup Management.

mohana_cse06 · 2011-05-10

ahh..I thought userSetup is a Record Variable..
Now I got it..

Troubles_In_Paradise · 2011-05-10

mohana_cse06 wrote:

ahh..I thought userSetup is a Record Variable..
Now I got it..

I'm sorry, maybe I had to explain better.

aseigle · 2011-05-10

I posted this on both the NAV Forum and the NAV Connect site. We shouldn't have to re-invent the wheel with responsibility centers. MS should correct this in the next version.

https://connect.microsoft.com/dynamicssuggestions/feedback/details/621970/responsibility-center-filter-in-the-rtc

See the link from that site for the forum page.

Filtering Cue Groups

Answers

Categories