User ID Filter

Triibukene

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!

vaprog

Did you set the "User ID Filter"? i.e. SETRANGE, not assignment.

Triibukene

I guess not. Could you please be more specific, vaprog? FYI I am just an end user

vaprog

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

Thank you, it worked!

kriki

[Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]