web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Account Structure lett...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Account Structure letting dimension value choose other values

(0) ShareShare
ReportReport
Posted on by Roger Mansson 2

If you want to force the user to select Department dimension value but not CostCenter value and vice versa, can be done like this

EitherOr.png

But what if we let user chooses Department in a range between 1000..9999, then the user can choose any CostCenter

or

if the user chooses a Cost center <=999, then the user can choose any Department value

I have tried using advanced rules with an additional condition for CC<=999 then Department *

Any ideas?

I have the same question (0)
  • Roger Mansson Profile Picture
    Roger Mansson 2 on at

    Hi. Sorry for long wait to reply. the forum didnt allow me to reply.

    Simply put

    For main accounts 5000..6599:6900-6999:

    1. Both cost center  + project fin dim allowed if

         a. cost center =50000..60000;80000;93000;980000

      OR

         b. if project <= 1000 any cost center can be used

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,818 on at

    Hi,

    Probably because of department code field is a string type field, your condition is not working. Try to use another operator such as the department equal to ZZZ (a not exist department code)

    Best.

  • saurabh bharti Profile Picture
    saurabh bharti 15,039 Moderator on at

    I think you should use advance rule for this?

    Also, are you saying use can choose cost centre first in some cases and department in some cases?

    But you will define segment in one sequence only depart then cost centre?

    Can you share exact rules requirement?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 417 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 325 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans