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

Dimension combination not null

(5) Share

Report

Posted on by CU25060751-0

Hi everyone,

I have a question regarding dimension combination, is it possible for me to set it up so if dimension A = contract work then dimension B cannot be Null / Blank?

I don't mind any other method as well. I was thinking of using AL, or even if possible dimension central have white list system?

Thanks,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Please check below links, these might be helpful.

Dimension Combinations in Business Central | Trunorth Dynamics

Solved: Best way to make dimension mandatory system wide

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi

Good question. Business Central doesn’t have a built-in way to enforce “if Dimension A = X, then Dimension B must not be blank” out of the box but you can definitely handle this with a bit of AL customization

Here’s what you can try

Use a validation trigger in AL (like OnValidate or OnBeforePost) to check if Dimension A has a specific value, and then throw an error if Dimension B is blank

You can also hook into the Codeunit 408 DimensionManagement to work with dimension sets and validate combinations before posting

If you want something more configurable, you could build a small setup table that defines required combinations, then check against that during posting

The Dimension Combinations feature in BC lets you block or limit combinations globally, but it doesn’t enforce “required if” logic like you’re describing

There’s a good overview of how Dimension Combinations work here Trunorth Dynamics – Dimension Combinations in Business Central

If this helped, feel free to mark it as the suggested or verified answer

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

As far as I know, this can only be done by customization, or you can try the following method in combination with Dimension combination.

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-dimensions?wt.mc_id=DX-MVP-5004336#to-set-up-default-dimensions-for-customers-vendors-and-other-accounts

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,951 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

If Dimension Combination functionality does not helpful so, you can go with AL Customization to fulfill your requirement.

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

The combination of dimensions could not help for such requirement. It would be best to perform a customization in order to achieve your requirement.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi

You could extend the functionality of combination of dimensions and add the logic for your requirement.

Best

Gr

Was this reply helpful? Yes No