security filter in sales analysis report

bubu

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

michaelk

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.

Yours

Michael

geordie

Which NAV version are you running?
There is an hotfix included in CU5 for NAV2013R2 to solve this issue.