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...
Answered

Issues Using Security Filters on Bank Accounts for Department‑Based Access

(8) ShareShare
ReportReport
Posted on by 59
Hi everyone,
we’re implementing Security Filters in Business Central to restrict access to Bank Accounts based on the user’s department.
The restriction is applied through the Shortcut Dimension 2 Code, and the visibility filtering itself works as expected.
However, we’re running into a major issue:
When a user tries to add a Bank Account to the Payment Reconciliation Journal, Business Central throws an error because the Security Filter blocks access to the record.
What makes this more complicated is that the error occurs inside the Base App, specifically when standard code performs database operations such as <Rec>.Count() or <Rec>.FindSet() on the Bank Account table.
Because these operations respect the Security Filter, they fail when the user does not have access to all bank accounts.
I tried setting the record to SecurityFilter::Ignored, but the relevant functions do not expose any events or triggers where we could temporarily override or adjust the security filter.

Is there any supported way to bypass or override Security Filters during this specific operation, or are there alternative approaches to achieve department‑based visibility for Bank Accounts without running into this error?

 

Thanks for any response!

 

 

I have the same question (1)
  • Suggested answer
    Pallavi Phade Profile Picture
    5,420 Super User 2026 Season 1 on at
    Namaste @Philipp1804
     
    There is no other standard approach. You have to do it by customization.
     
     
     
    Warm Regards
    Pallavi Phade 
    www.linkedin.com/in/pallaviphade131116
  • Philipp1804 Profile Picture
    59 on at

    Thanks for your answer!
    If I understand you correctly, I have two options:
    1. Create an issue in the GitHub repository for the Base App and request an IntegrationEvent.
    2. Implement my own “security filter” by using FilterGroup 2, for example.

  • Suggested answer
    Alex A Profile Picture
    3,068 Super User 2026 Season 1 on at
    How many different departments need to have access to the different bank accounts and make payments? Or is it just one or two groups within the accounting department (between AR and AP)?
     
    There are other ways to do this without security filters, depending on the details. Using security filters may contine to cause you these and other issues.
  • Suggested answer
    YUN ZHU Profile Picture
    99,084 Super User 2026 Season 1 on at
    Hi, Alternatively, instead of using Security Filters, an error can be thrown when the user selects a bank account that is not associated with the current department.
    However, if a lot of scenes need to be modified, this can be quite time-consuming.
     
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,128 Super User 2026 Season 1 on at
  • Gerardo Rentería García Profile Picture
    25,555 Most Valuable Professional on at
  • Verified answer
    Philipp1804 Profile Picture
    59 on at
    Thank you for your feedbacks. Each department works with its own bank accounts and therefore only wants to see the ones that belong to them. I will probably need to find another way to filter the views correctly. I think FilterGroup 2 will be my first approach.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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