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

Set up Departments

(4) Share

Report

Posted on by CU10031756-1

I am setting up Business Central for a company that has two divisions. One division also has 2 departments. The divisions are Sales and Labs. I need to be able to produce a P and L and Balance Sheet for each of the two divisions and also a consolidated set of accounts.

in addition, for the 2 Labs, I would like to track expenses for each.

How should Inset this up? Should I have a dimension for Sales and another for Labs so I can report each set of accounts seperately? How do I further split the Labs into two to track expenses?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 99,324 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If PL and BS are separate, I personally recommend using two separate companies. If you want to use dimensions, that's also possible, but you might need to customize some reports.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 13,323 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The standard way in Business Central is to use Dimensions, not separate G/L accounts. Create one dimension called Division with values Sales and Labs, so you can run P&L and Balance Sheet by Division or consolidated (no filter). Then create another dimension called Department with values for the two Labs. When posting transactions for the Labs division, assign the appropriate Department dimension to track expenses per lab. In reporting, you can filter Division = Labs and analyze by Department, or run financial reports by Division for the two main entities.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Rajvi Shah 152 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Instead of separate dimensions for "Sales" and "Labs," create one primary dimension and define your structure within its values.

SALES (Division 1)

LABS (Division 2 - defined as a "Begin-Total" for aggregation)

LAB1 (Sub-department 1 - Indented under LABS)

LAB2 (Sub-department 2 - Indented under LABS)

LABS-Total (Defined as an "End-Total" to sum LAB1 and LAB2)

Configure these as Global Dimensions to define the dimension in every page and transections.

Report:

Division wise Report: Filter your Financial Report by the "SALES" or "LABS" dimension value.

Sub-Department Tracking: Filter specifically by "LAB1" or "LAB2" to see individual lab expenses.

Consolidated Accounts: Run the report without any dimension filters to see the company-wide totals, or use the "LABS-Total" value to see consolidated lab figures.

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 518 on at

Like (0)

Report
Copy link

Link copied!

If it is one company, I would suggest keeping everything in one company.

You can then analyse transactions by dimension, just be mindful that you will need to make the dimensions mandatory on every transaction if you want a full P&L and BS

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No
JH-10032255-0 2 on at

Like (0)

Report
Copy link

Link copied!

I like the idea of setting two dimensions. One for Dociaion and the other for Department. If I do that, can I also set up Domensuons to split other reporting? I don’t need a Panand Lnfor other reporting but I would like to see Sale split by one supplier if possible..

Was this reply helpful? Yes No