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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Business Central Financial Report Dynamic Rows Query

(2) ShareShare
ReportReport
Posted on by
My client has a Financial Report in which the Row Definition is one row per Income Statement GL (using the Insert GL Accounts function). They want the Row Definition to update automatically if a new Income Statement GL is added to the Chart of Accounts, adding a new row that contains the newly added GL Account.
 
Outside of Power Automate or AL Customisation I can't see any way of making this work, is there a way of achieving this out of the box?
 
Thanks in advance
I have the same question (0)
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    1,473 Super User 2025 Season 2 on at
    Hello,
     
    There isn't such functionality in the standard BC behaviour.
    Definitely, Power Automate or AL extension is a way to get that automation.
     
    Greetings
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    It sounds like this can only be done by customization. Maybe it would be easier to use AL.
    If there were some screenshots, it might be easier to understand.
     
    Thanks.
    ZHU

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans