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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

EDT real with an upper limit

(1) ShareShare
ReportReport
Posted on by 328
We're trying to put an upper bound on a numeric Extended Data Type, i.e. such that it can never be higher than 99,999,999.99  I can only find EDT properties on MS learn for AX 2012, not D365, so there were a couple of properties at EDT level that looked like they had potential:
  • Scale
  • Display Length
  • No of Decimals
The third of these has the expected effect, the second just seems to change the size of the input control, and the first doesn't have any obvious impact, even after build, DB sync, dev box restart (last of these very much a desperation idea)
 
On the off-chance we could implement through the UI, we also tried two properties of the control on the form:
  • Display Length
  • Display Length Mode
  • Limit Text
  • Limit Text Mode
Again, these appear to have no effect: we're able to input numbers with more digits than the values specified in the above properties & they're saved to the DB & shown again when the form is refreshed. Can anyone please point to a property we're missing? Or do we need to extend the validateWrite method on the table to which we're adding the field?
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    238,308 Most Valuable Professional on at
    I don't think there is a way to do it through properties.
     
    The best method for the validation in GUI is validateField() on the table, because then the value is checked immediately on change; it doesn't require saving the record.
    But you still may want to validate it in validateWrite() as well, to ensure that the rule is enforced even when the value is set from code or so.

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…

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

Product updates

Dynamics 365 release plans