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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Restricting certain users to view certain types of transactions

(5) ShareShare
ReportReport
Posted on by 36
How do we process transactions to employees / independent contractors so that procurement and other non-finance department users cannot see these transactions - for example posted purchase invoices, posted purchase invoice lines, project ledger entries, G/L Ledger entries etc
 
Examples of expenses are employee expense report reimbursements, independent contractor expenses booked at a project and task level etc
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    12,878 Super User 2026 Season 1 on at
    Hello ,
     
    Business Central does not support true row-level security on posted financial data (posted invoices, G/L entries, project ledger entries), so you can’t reliably hide employee or contractor transactions per vendor/user using standard permissions. The practical, supported pattern used in real projects is to tag sensitive transactions with a Confidential dimension (e.g., CONFIDENTIAL = YES), restrict non-finance users from standard posted pages, and expose only filtered/custom pages or reports that exclude confidential entries. Finance users retain full access for audit and reporting. For strict legal isolation, the only hard options are a separate company or handling expenses outside BC and posting summaries.
    Regards,
    Oussama Sabbouh
  • Suggested answer
    YUN ZHU Profile Picture
    99,084 Super User 2026 Season 1 on at
    Hi, Using the Permission Exclusion feature to exclude a user's permissions is the simplest method.
    More details:
    Dynamics 365 Business Central: Permission Exclusion (Exclude in Permission Set)
     
    PS:
    Dynamics 365 Business Central: What happens if users don’t have permission to read the table set in the TableRelation Property?
    Dynamics 365 Business Central: What happens if users don’t have permission to read the table set in a FlowField?
    Dynamics 365 Business Central: Difference between Table Data and Table in Permissions
     
    Thanks.
    ZHU
  • Suggested answer
    Pallavi Phade Profile Picture
    5,420 Super User 2026 Season 1 on at
    Namaste @pramit9393
     
    We can restrict Records using Security filters in Permission sets . But this puts control on all areas while inserting  ,posting , viewing the filtered Records 
     
     
    Your requirement is about only viewing . I'm not sure this will be handled in permission set .
     
    Or 
    You can do customization department wise or user group wise to filter the list views of the pages 
     
     
     
    Warm Regards
    Pallavi Phade
    www.linkedin.com/in/pallaviphade131116
     
  • Suggested answer
    Dhiren Nagar Profile Picture
    2,898 Super User 2026 Season 1 on at
    Hi, 
     
    Well it is possible if you have a common unique ID to hide. For e.g. Employee No., Vendor No., Resource No.
    Different tables which you mentioned will have these unique IDs as a field.
     
    Once you identify these unique IDs which you want to filter out, you need to use Security filter functionality of Business Centra.
     
     
    If you want to make it easy to manage here is a Add-on available - Security Filter in Business Central (Customized Solution)
     
    Regards,
    Dhiren.
     
     
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,219 Super User 2026 Season 1 on at
    Hi,
     
    Business Central cannot hide individual posted finance transactions selectively.
    One of the approach is strict permission design and keeping non‑finance users away from posted ledger tables.
    True transaction‑level secrecy requires reduced access or custom solutions.
     
    Regards
    Rishabh

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans