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

Balance Sheet Divisons

(6) 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 (6)

Answers (0)

Greg Kujawa 676 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 27 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 6,876 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 27 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 95,987 Super User 2025 Season 2 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 397 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