User ID filter in a cue

(0) Share

Report

Posted on by Community Member

Hi,
I am trying to add a cue to table 9054 Finance cue that would show open purchase invoices|credit notes that have "Assigned User ID" of the logged in user. The CalcFormula is:

Count("Purchase Header" WHERE (Assigned User ID=FIELD(User ID Filter),Document Type=FILTER(Invoice|Credit Memo),Status=FILTER(Open)))

I then added the cue to page 9030 Account Manager Activities with DrillDown to Purchase List and it works perfectly except for the User ID filter. The cue shows all open documents not only those assigned to me.

What is missing? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Maybe you can try USER ID instead of User ID Filter

Count("Purchase Header" WHERE (Assigned User ID=FIELD(User ID),Document Type=FILTER(Invoice|Credit Memo),Status=FILTER(Open)))

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, but that did not help. USER ID is not a possible choice here in drilldown.

Was this reply helpful? Yes No
Suggested answer

Marcellus 2,735 on at

Like (0)

Report
Copy link

Link copied!

Hi Riina,

Can you added a new field called "Current User" Code(50) FieldClass FlowFilter.

In the calculation formula add Assigned User ID=FIELD(Current User).

In the page OnOpenPage add SETRANGE("Current User", USERID);

Was this reply helpful? Yes No