security filter in sales analysis report

bubububu Member Posts: 14
edited 2015-04-21 in NAV Three Tier
Hi All

---sorry reposting, i post in wrong section---- ](*,)
I want to make sales analysis report readable only for certain salesperson for example salesperson JR only see information about sales with salesperson code "JR".
So I use security filter for user JR in table value entry and table item view entry with security filter salesperson/Purchaser code "JR".
when I open value entry, it's successful, user JR only see entries with salesperson code JR.
but when I open Sales analysis report > show matrix, there is error message:
"A security filter has been applied to table Item Analysis View Entry. You cannot access records that are outside of this filter.
Page View - Sales Analysis Matrix must close."
How to use security filter in sales analysis report?

Please give me some suggestions, thank you very much for your help :)


  • Options
    michaelkmichaelk Member Posts: 11
    Hello bubu,

    please check it with Debugger. So you can see what the Problem is. Maybe you Need to deactivate the securityfilter in some cases.


  • Options
    geordiegeordie Member Posts: 655
    Which NAV version are you running?
    There is an hotfix included in CU5 for NAV2013R2 to solve this issue.
Sign In or Register to comment.