Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Override the lookup to...
Finance forum
Unanswered

Override the lookup to filter the values of the lookup on financial dimensions

Posted on by 108
Hi,
 
I am trying to customize the lookup to filter the value on the below lookups on specific dimensions. I want to get only those values that exist in my custom table which is integrated into an external system.
 
 
Can you help me out with this issue?
Thanks.
  • Martin Dráb Profile Picture
    Martin Dráb 227,979 Super User 2024 Season 2 on at
    Override the lookup to filter the values of the lookup on financial dimensions
    You must thing harder about what you actually want. Now you again talk about just showing or not showing the values, but we already clarified that this is not the complete requirement.
     
    Also, it's not enough to think about just the data input, but you need to consider what should happen later. For example, dimension value A was valid a week ago when a sales order was created, but it doesn't exist in your table today. May I confirm the order today and or will I be forced to change the dimension to one of the currently existing in MyCustomTable? There are a plenty of scenarios like this where you lack any definition of the expected behaviour.
     
    Also, please clarify what you mean by "my standard dimension values table". Do you mean the backing entity of a system dimension, such as ProjTable for the Project dimension?
  • ShahzaibAhmed52 Profile Picture
    ShahzaibAhmed52 108 on at
    Override the lookup to filter the values of the lookup on financial dimensions
    I have a set of values for the dimensions in my standard dimension values table.
    There is another table (MyCustomTable) that contains the same values that are connected to an external system.
     
    In MyCustomTable the values disappear based on the availability of several properties. 
    I want to filter the values on my standard lookup to show only the available values in MyCustomTable.
  • Martin Dráb Profile Picture
    Martin Dráb 227,979 Super User 2024 Season 2 on at
    Override the lookup to filter the values of the lookup on financial dimensions
    Hmm, you're giving us your requirements bit by bit... It would be more efficient if you gave us more information about your requirements on the beginning.
     
    Okay, so you agree that filtering the lookup wouldn't do what you need; your requirements are broader.
     
    Now please tell us more about the lifecycle of the data. When you say that you want to show only currently available values, does it mean that values already used as financial dimensions can be removed from the table? That would be a problem. Please confirm this before we continue with more steps of the analysis.
  • ShahzaibAhmed52 Profile Picture
    ShahzaibAhmed52 108 on at
    Override the lookup to filter the values of the lookup on financial dimensions
    I want to filter the values from the lookup and also from any other source (Upload or manual typing). There is an integration table that contains the values that change several times within a week. I only want to show the values that are currently available in that custom table. This is to be done only for three dimensions (Project, Property, and Unit). All other dimensions can stay as they are.
  • Martin Dráb Profile Picture
    Martin Dráb 227,979 Super User 2024 Season 2 on at
    Override the lookup to filter the values of the lookup on financial dimensions
    Do you really want to exclude other values just from the lookup? If so, they won't display in the lookup but they'll still be valid values, therefore users will be able to set them manually or used when importing records.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans