Small and medium business | Business Central, N...

Custom Financial Report

(1) Share

Report

Posted on by Micheleish

105

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Gerardo Rentería Ga... 25,154 Most Valuable Professional on at

Like (0)

Report

Hi

I hope this can help you, and give you some hints

Solved: Using Dimensions on Account Schedule Ro3ws (dynamics.com)

Row definitions in financial report designer - Finance & Operations | Dynamics 365 | Microsoft Learn

Best regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (2)

Report

you could use Financial reports feature and Analysis View feature in BC for this.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

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)

https://yzhums.com/43664/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No