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

Balance Sheet Divisons

(8) Share

Report

Posted on by HP-11111426-0

How can we set up our business central so all Balance Sheet GL Transactions hit 700 automatically (balance sheet division) instead of an operating division (701,702)?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Greg Kujawa 787 on at

Like (0)

Report
Copy link

Link copied!

I assume that Division is a Dimension Code, correct? If so then you can go into a GL account, and define a default Dimension Code Value that should always be assigned (i.e. - the Same Code option).

1 people found this reply helpful.

Was this reply helpful? Yes No
HP-11111426-0 33 on at

Like (0)

Report
Copy link

Link copied!

So now what is happening is when I post a transaction, it is trying to post the whole transaction to the operating division (701) and the system is saying no you cant do that because 1208 (GL Account) must be 700. I need to figure out how to code only the balance sheet transactions to 700 automatically regardless of the what the other gls are coded to.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,878 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

The error happens because Default Dimensions (Division = 700, mandatory) on Balance Sheet accounts block posting when the document carries Division 701/702. There is no standard setup to fix this. The correct solution is a small AL customization: during posting (best place is the Gen. Journal check/post pipeline), detect lines posting to Balance Sheet G/L accounts (Income/Balance = Balance Sheet) and override the Dimension Set ID to force Division = 700, while leaving P&L lines unchanged. This avoids the error and automatically routes only Balance Sheet entries to 700, regardless of the operating division on the document.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
HP-11111426-0 33 on at

Like (0)

Report
Copy link

Link copied!

What does AL Customization stand for? How do we get that done?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi, I think you can try the Dimension Priorities feature first.

More details:

Dynamics 365 Business Central: Default Dimension Priorities (Avoiding conflicts)

https://yzhums.com/23962/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You have only two option.

1 - When you make any entries make sure you select different dimensions for different G/Ls. for e.g. If you are posting:

Customer Dr, To Sales Cr then for Customer entry use 700 and for Sales e.g. use 701.

2 - Do a development with the help of technical consultant to change this standard system as per your need.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Business Central does not provide a standard configuration to automatically route all Balance Sheet G/L transactions to a specific division such as 700 based on account type. Dimension values are inherited from the source document, master data defaults, or posting setups, not dynamically determined by whether a G/L account is Balance Sheet or Income Statement.

One of the approach is to assign Division = 700 as a default dimension on all Balance Sheet G/L accounts and enforce it using Value Posting (Same Code or Code Mandatory), while allowing operating divisions (701, 702) only on P&L accounts. This ensures Balance Sheet postings consistently hit division 700, and incorrect division usage is blocked at posting. Fully automatic conditional reassignment based on account category is not available without AL customization.

Regards

Rishabh

Was this reply helpful? Yes No
HP-11111426-0 33 on at

Like (0)

Report
Copy link

Link copied!

Can someone send me the steps or breakdown of how / what I need to do to set-up the AL customization so I can send it to my support team?

Was this reply helpful? Yes No