Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Account Structure letting dimension value choose other values

(0) ShareShare
ReportReport
Posted on by 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?

  • Roger Mansson Profile Picture
    Roger Mansson 2 on at
    RE: Account Structure letting dimension value choose other values

    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,810 on at
    RE: Account Structure letting dimension value choose other values

    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,029 Super User 2025 Season 1 on at
    RE: Account Structure letting dimension value choose other values

    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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans