User ID Filter

Triibukene
Triibukene Member Posts: 3
in NAV Three Tier
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!

Answers

  • vaprog
    vaprog Member Posts: 1,163
    Did you set the "User ID Filter"? i.e. SETRANGE, not assignment.
  • Triibukene
    Triibukene Member Posts: 3
    I guess not. Could you please be more specific, vaprog? FYI I am just an end user :)
  • vaprog
    vaprog Member Posts: 1,163
    edited 2017-07-17
    You need a line 
    SETFILTER("User ID Filter",USERID);
    in the OnOpenPage trigger of Page 9030. Add it after the existing lines calling SETFILTER.

    If you are an end user, you likely have no access to the code of the page. Ask your NAV partner to help you with this.

    I did not check the other cues on that page. The filter might affect those also.
  • Triibukene
    Triibukene Member Posts: 3
    Thank you, it worked!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories