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 :
Microsoft Dynamics AX (Archived)

Ledger transactions (LedgerTrans) - Record Level Security problem Trial balance report

(0) ShareShare
ReportReport
Posted on by 2,369

Hi,

I have implemented Record Level Security on LedgerTrans table based on Purpose. When I am seeing 'Transations' of a particular ledger account then the system is showing transactions based on that particular purpose but the problem is that when I am calling 'Trial balance' report then it is ignoring that record level security.

I have also implemented record level security on Customer transaction and Vedor transactions and it is working fine both on 'Transactions' as well as Customer and Vendor Statement but do not know why it is not working on Trial balance report.

Will be very greateful if anyone of you could help me in resolving this issue.

Rgds

Haroon

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Record level security is based on tables and those tables displayed on forms.  Not for reports.  You cannot setup this type of security based on reports.  Its either no access, view, or full ctrl on reports.

  • Suggested answer
    Glib Savchenko Profile Picture
    95 on at

    Try to setup RLS for tables:

    - LedgerBalancesDimTrans

    - LedgerBalancesTrans

    - LedgerBalancesTransDelta

    And for views:

    - LedgerBalancesTrans

    - LedgerBalancesDim

    - LedgerBalancesDimTransDeltaSum

    - LedgerBalancesTransDeltaSum

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans