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

Departments as a segment of the GL account

(0) Share

Report

Posted on by olegvi

831

Hello,

The customer wants to see the Trial Balance in BC with expenses by department going down the list.

I understand that using Dimensions is going to be tricky if we want to see all GL accounts with all Departments going down on the same page. Is that correct?

What is my best bet setting this up? Should we create GL account structure similar to GP and use dashes to concatenate departments? Something like GGGGG-DD where G- GL account and D - department?

Thank you,

Oleg.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You could create a report and show them on the report by the Department. I believe creating a separate GL Account for each Dept will be too much for maintainenace.

Was this reply helpful? Yes No
olegvi 831 on at

Like (0)

Report
Copy link

Link copied!

Hi Suresh,

Thank you for helping.

Are you referring to custom report or suggesting that with dimensions standard report can be created that will list expenses by department?

E.g.

601000 - $30

602100-Admin - $20

602100-Sales - $50

602100-Marketing - $70

Etc. along with all other GL accounts?

Thank you,

Oleg.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check Dimensions Detail Report and select appropiate Analysis view code, if that does not suffice your needs then you need a custom report.

Also check this

docs.microsoft.com/.../bi-how-analyze-data-dimension

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Oleg,

Adding to Suresh's reply... Create a Dimension called Departments and enter the values. I would make Department your Global 1 Dimension. Now, if you want a Trial Balance run the report called Trail Balance, per Global Dimension. This will run the Trial Balance by Dimension, which should give the results your customer is looking for.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
olegvi 831 on at

Like (0)

Report
Copy link

Link copied!

Thank you Steve,

Trial Balance by Dimension gives me a page per dimension value. Would you know if there is a way to have all dimensions on one page on separate lines? Or is this a customization?

Thanks a lot,

Oleg.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Oleg,

Use Trail Balance, spread dimension. Set the Global Dimension. Account Range and Period and you should be good.

Thanks

Steve

Was this reply helpful? Yes No