Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Enum value sync issue
Finance forum
Unanswered

Enum value sync issue

Posted on by 229

Hi All,

We are facing an issue with Enum value sync in DB.

Scenario :

We created a new enum, ex., TestEnum with elements as below and deployed to the Tier 2 environment.

Enum value

Name

0

B

1

C

2

D

Later, we added a new element and changed the enum value as below and deployed again to the Tier 2 environment.

Enum value

Name

0

A

1

B

2

C

3

D

But the enum values in the standard - 'EnumValueTable' is not getting changed unless we manually delete the data for the particular EnumId and resync the data. 

As we don't have provision to backend in Tier 2 environment, we are not able to proceed with this workaround.

Could someone please suggest your inputs on this issue!

Thanks!

 

  • Martin Dráb Profile Picture
    Martin Dráb 227,971 Super User 2024 Season 2 on at
    Enum value sync issue
    I've moved this thread from Dynamics AX forum, because several things suggest it's actually about F&O.
     
    It seems you created a non-extensible enum and then you manually changed the meaning of value 2 from TestEnum::D to TestEnum::C. Then it's you who "caused mismatches between UI and DB".
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Enum value sync issue
    Hi,
    In this case, I agree with Andre's approach. At present, I don't know why this problem arises or how to solve it, so we can avoid this problem in another way. You can choose to add a new record instead of modifying it and re-editing it to meet your needs.
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,115 Super User 2024 Season 2 on at
    Enum value sync issue
    Hi Suren,
     
    In case you have an enumeration with predefined values, I wonder why you renumbered the values. Why didn't you add A with enum value 3? You can then still manage the order for the user starting with an A. In that case, you don't have this type of issue.
  • Suren_G Profile Picture
    Suren_G 229 on at
    Enum value sync issue
    Hi Waed,
     
    Yes, we updated the exiting element name in the enum and added a new element. But the updated values are not syncing to the 'EnumValueTable' and it causes mismatches between UI and DB. 
     
    Thanks!
  • Waed Ayyad Profile Picture
    Waed Ayyad 5,060 Super User 2024 Season 2 on at
    Enum value sync issue
    Hi,
     
    Did you update the already-existing records, as some records will have wrong values?
     

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

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

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans