web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Financial dimension ad...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Financial dimension advanced rule

(0) Share

Report

Report

Posted on by calacakmak

2

Hi everyone,

General ledger>Chart of accounts>Structures>Configure account structures

I'm working with Financial dimension advanced rules in Dynamics 365 Finance & Operations.

We have an advanced rule that controls which Main accounts can be used with specific Site values.

The problem is that the Allowed value details section only lets me add a limited number of rows (around 7 in my case).

Our business requirements are often like these:

-Allow all sites except 03.01 and 07.01.

-Allow only a custom combination such as 01.01, 05.01, 08.01, 09.01, 10.01, etc

Since we have more than 10 sites, the current approach quickly reaches the row limit, and maintaining these rules becomes difficult whenever a new site is added.

I was expecting an operator like:

Site is not

Site is not in (...)

Exclude selected values

instead of having to explicitly list every allowed value.

Another challenge is using the "between" operator. It only works well when the allowed values are consecutive. If the requirement is something like "include 01.01-05.01, exclude 03.01, include 07.01-09.01", it requires creating multiple separate conditions, which makes the rule difficult to maintain.

My questions are:

Is there any built-in way to exclude specific financial dimension values instead of listing all allowed values?

Is there another configuration or feature that is recommended for this scenario?

Is there a way to use NOT IN or a similar exclusion logic in advanced rules?

If not, is this simply a current limitation of Advanced Rules

Has anyone dealt with a similar requirement? I'd appreciate any best practices.

Thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

vishalsahijwani 273 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @calacakmak ,

Here are the answers to your questions : -

1) There is no default or out of box way to exclude specific financial dimension values instead of listing all allowed values.

2) The ideal and suggested approach as per best practices is to use "Duplicate" on the segment row to distribute values across multiple rows once you exceed 7 rows per line

3) There is no "NOT IN" or any similar kind of NOT operator among the already available operators.

4) Yes this is indeed a limitation of Advanced rules

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 431 Super User 2026 Season 1

#2

#3

Martin Dráb 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans