Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Custom Financial Report

Posted on by 89
Hello and Good Morning,
 
Is there a setup for an income statement that could display multiple lines with the same G/L number but different dimensions?  I have the budget entered like that, but there is nothing out of the box.  Does anyone have experience customizing or creating P&L with these features?
 
Dimensions would be Dept and Project with each column being the months of the account period
 
 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,536 Super User 2024 Season 2 on at
    Custom Financial Report
    Just to add some information, the income statement you mentioned is actually the default Financial Report set in General Ledger Setup. You can find it and modify it according to the method mentioned by Valentin.
    More details: 
    Dynamics 365 Business Central: Report Selection for standard documents (Set up default reports)
     
    Hope this helps as well.
    Thanks.
    ZHU
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 21,728 Super User 2024 Season 2 on at
    Custom Financial Report
    As appliwin123 mentioned financial reporting can do this. For example, if I go to the Financial Reporting Page, select and edit the rows for your income statement report:
     
     
    In here I can create multiple rows for the same G/L Account. I can then add my 2 global dimensions as columns (personalize the page to add the fields), and for each row select a dimensions code:
     
     
    If your Dept and Project dimensions are not part of your 2 global dimensions, but they are shortcut dimensions instead, then you will create to create an analysis view and add it to the financial report. Let me know if that's the case and I can show you how to do that as well. 
     
    Your column layout for the report would also have to contain your months as columns.
     
    Valentin Castravet
    Zander ERP Services
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 6,881 Super User 2024 Season 2 on at
    Custom Financial Report
    you could use Financial reports feature and Analysis View feature in BC for this.
  • gdrenteria Profile Picture
    gdrenteria 8,744 Most Valuable Professional on at

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans