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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to add custom look...
Finance | Project Operations, Human Resources, ...
Unanswered

How to add custom lookup on standard financial dimension in D365 FO

(0) ShareShare
ReportReport
Posted on by DarshanaDeshpane 10

Hi,

I have 2 financial dimension LOB & SubLOB.

In LOB there are 3 values like 1001,1002,1002

and SubLOB are 1001-01,1001-02,1001-03,1002-01,1002-02,1002-03,1003-01,1003-02,1003-03

when I am selecting the value in LOB financial dimension is 1001

that time i want to show in SubLOB are 1001-01,1001-02,1001-03

i.e. I want to add custom lookup on existing Financial dimension base on another selected FD value in D365 FO

Please can any one help me for that

Thanks

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

    Hi Darshana,

    Is your question about journal entry or master data like default dimensions on customers? You can use account structures or advanced rule to define the relation. Then on journal entry, it will filter already out of the box. Also there is an option to use Organization hierarchies and add relations between dimensions based on internal operating units.

    If your question is about default dimensions on e.g. a customer details form, then there is no support out of the box.

  • Sophs@4Sight Profile Picture
    Sophs@4Sight 223 on at
    Good day
    Were you able to find a solution to this question?  I have a similar requirement.
    In my requirement certain users are assigned to one or more specific Brands. The Brand is a Financial dimension. 
    When the user creates a Purchase order and adds a Purchase order line, the lookup on the Financial Dimension for Brands should only show the Brands that he has access to.
    Then further a validation must be added to ensure that if the user typed in a Brand dimension value that the value is valid.
    Any assistance will be greatly appreciated.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at
    Hi Sophs@4Sight,
     
    You can achieve your requirement with help of a security policy. This is commonly known as Extensible Data Security (XDS). You can then restrict records to be visible for users based on a particular condition. 
    You can read about XDS and find some examples on my blog: Extensible Data Security examples for Microsoft Dynamics (dynamicspedia.com)

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

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 November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans