<@U8PKV059A> I dont think so there is a way around...
# accountings
Sam-I-Am
12/13/2018, 6:34 PM@Cr223309 I dont think so there is a way around it. There is restrict by dept and class is available for accounts but it may not work for this. You can always script it 😞
c
Cr223309
12/13/2018, 6:36 PM@Sam-I-Am Thanks for the quick response. I guess , how would you even be able to script it since you cant deploy a script on reports?
s
Sam-I-Am
12/13/2018, 6:37 PMscript for the access control
Sam-I-Am
12/13/2018, 6:38 PMwill show denied access warning
k
Karthik
12/13/2018, 6:38 PMLast year we have faced similar issue. here are the steps we followed.
Role > Department Restrictions = own, subordinate, and unassigned
Scenario:
Parent Account > Child 1 Account > Restrict to Department = G&A : HR
Employee > Department = G&A : Finance
Bill VEN100101 > Department = G&A : HR
Actual Result = Bill is not shown on Income Statement.
Karthik
12/13/2018, 6:39 PMI need to test this again
c
Cr223309
12/13/2018, 6:42 PM@Karthik Thanks for that insight but I dont think this would work for us, because when they run an income statement they still need to see the correct numbers tied to that Payroll account and if we restrict access their reports would differ from other members of the Finance dept...
o
Olivier Gagnon (DXC)
12/13/2018, 6:43 PM@Cr223309 do you guys have one account per employee or something? What level of confidentiality are they able to see with just lump sum reporting?
c
Cr223309
12/13/2018, 6:43 PM@Sam-I-Am How would you script on Access Control? Im familiar with scripting but i know it has to be deployed on a record.. Ive never scripted for Access Control
Cr223309
12/13/2018, 6:44 PM@Olivier Gagnon (DXC) No we have just 1 main Payroll account and when they click on it to see the Register, since they have access to account detail reports, they can see how much a paycheck transaction is for (since we use NS payroll)
o
Olivier Gagnon (DXC)
12/13/2018, 6:45 PMbut the paycheck transaction would be for a bunch of people no?
c
Cr223309
12/13/2018, 6:45 PMOn the Payroll register it lists out each payroll transaction, the name of the employee and the amount...
o
Olivier Gagnon (DXC)
12/13/2018, 6:45 PMreally... yeah, that's not good!
c
Cr223309
12/13/2018, 6:46 PM@Olivier Gagnon (DXC) yeah since the payroll transaction is tied to an employee the account detail for our payroll account shows the name...
o
Olivier Gagnon (DXC)
12/13/2018, 6:47 PMyou said you were using NS Payroll?
c
Cr223309
12/13/2018, 6:47 PMcorrect, currently we are.. we are going to switch by end of 2019
o
Olivier Gagnon (DXC)
12/13/2018, 6:48 PMHmm
Olivier Gagnon (DXC)
12/13/2018, 6:48 PMcheck out Suite Answer 51409
👍🏻 3
👍 1
Olivier Gagnon (DXC)
12/13/2018, 6:48 PMIf a user requires access to financial reports, but should not be able to view personal employee information on these reports, an administrator can mask this information by adding the Hide Employee Information on Financial Reports permission to a role assigned to the user. This permission prevents a role from seeing employee information, such as the employee name on the following financial reports:
c
Cr223309
12/13/2018, 6:50 PMGENIUS!!!
o
Olivier Gagnon (DXC)
12/13/2018, 6:51 PM🙇
s
Sam-I-Am
12/13/2018, 6:56 PM@Olivier Gagnon (DXC) is the legendary Netsuite Guru 👌🏼
😊 1
c
Cr223309
12/13/2018, 7:48 PMThis works PERFECT except for on Commission Transactions - Don't know why NS decided not to add that to the list...
k
KevinJ of Kansas
12/14/2018, 3:24 AMThe other thing you can do on the financial report is disallow drill down by setting that financial section to "can not expand" on a custom financial report.
For that to work you will have to use the "access" which grants access without regards for the permission as opposed to "audience" tab and you will have to remove the permission to run standard financials
KevinJ of Kansas
12/14/2018, 3:31 AMThe other permission you can remove is the register permission for that account type
2 Views