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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Custom Financial Reports
Small and medium business | Business Central, N...
Answered

Custom Financial Reports

(0) ShareShare
ReportReport
Posted on by Pulido 25

I understand that the Report 25 Account Schedule has many options as Balance Sheet, Income Statement, Statement of Cash Flow, etc.

I need to customize each report in Power Builder, but it´s the same file rdl. How can I work with each report in Power Builder?

Thanks for all.

JCP

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather Microsoft Employee on at

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,001 Super User 2026 Season 1 on at

    Hi, After you need to download the software below, you can create or edit it.
    Of course, you can also use the plug-in in VS.

    https://www.microsoft.com/en-us/download/details.aspx?id=53613#:~:text=Report%20Builder%20provides%20data%20visualizations,create%20reports%20and%20shared%20datasets.

    pastedimage1671755564412v1.png

    But please note that the development language of this has nothing to do with Business Central, you need to spend a lot of learning costs.

    https://learn.microsoft.com/en-us/sql/reporting-services/report-builder-tutorials?view=sql-server-ver16

    Hope this helps.

    Thanks.

    ZHU

  • Pulido Profile Picture
    Pulido 25 on at

    Thank you YUN ZHU.

    I have many expirience with Power Builder. I need to customize the file "Report 25 Account Schedule" for each option as Balance Sheet, Income Statement, Statement of Cash Flow, etc.

    Do you know how can I work with this file rdl? Are there filters for this cases?

    Thank you for all.

    JCP

  • Pulido Profile Picture
    Pulido 25 on at

    Thank you very much!!

    JCP

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 100,001 Super User 2026 Season 1 on at

    Hi, I think you can use the new function below to do it, just create multiple Layout files you need.

    Business Central 2022 wave 2 (BC21) new features: Choose the report layout on request page (Select a report layout before printing)

    https://yzhums.com/29568/

    pastedimage1672096776819v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Pulido Profile Picture
    Pulido 25 on at

    Hello, ZHU.

    Again, thank you for all.

    Last question: do you know what table in BC365 stores amounts theses Account Schedules (Balance Sheet, Income Statement, Statement of Cash Flow)?

    JCP7024.Captura1.PNGpastedimage1672188198794v1.png

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!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,875 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 926 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 642 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans