web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Row-level access in general ledger

(0) ShareShare
ReportReport
Posted on by 5

Hi,

We do have a number of sensitive accounts (salary...) in the General Ledger where we would prefer that these are only visible for specific users to see the transactions. Is this possible? some users should be allowed access to transactions on other accounts.  

I have the same question (0)
  • Suggested answer
    Ramit Paul Profile Picture
    22,809 Most Valuable Professional on at

    You can use journal 'private' option and then can book these type of transactions on that journal.

  • Juanse Profile Picture
    660 on at

    Hello,

    I believe that Ramit solution above will just hide the entry from the journal entry screen but it won't prevent users from seeing the lines if they run for example the voucher transaction for those accounts. Those entries will show up for everyone in the system.

    I believe that to achieve that level of row level security you need an XDS development added to the user roles. This can be tricky.

    I would suggest booking entries to those payroll accounts in summary and with a global description, that way it will be hard for accountants to decipher the salary for individual people.

    regards,

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi samstrup,

    Salary is usually posted on a summarized basis per department or cost center.

    People should thus not be able to identify the salary of somebody else unless a single employee is assigned to a specific cost center.

    If this is not the case then I don't see the necessity for special security settings.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    305,643 Super User 2026 Season 1 on at

    Hi samstrup,

    When your requirement is not only about the salary accounts or even the summarized posted values should be hidden, there would be indeed an option to do row-level security using eXtensible Data Security (XDS).

    You then not only need a policy, but also an indication for which users which transactions of what accounts should be hidden. This would require some development skills.

  • Suggested answer
    Junaid Idrees Profile Picture
    2 on at

    Hi Juan Grijalba,

    There are many reports/Inquiry screens in the GL, a smart accountant can check the posted salary numbers from anywhere. We have Account statement/Accounting source explorer/Voucher transactions/Ledger transaction list/ Trial balance/Management reporter.  In addition to that we dont have one salary account (There will be Benefits, Deduction, Allowances, Bonus, Tax)

    And yes you should post the summarized numbers by department then no one will be able to see an individual employee salary number break up and that should be an approach.

  • samstrup Profile Picture
    5 on at

    Thanks for all feedback.  I absolutely acknowledge that salary postings should be summarized.  Based on all your relevant answers I find that this will be the way forward.  Thanks again for your feedback  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 668 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 630 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 581

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans