Finance | Project Operations, Human Resources, ...

Real field mandatory but should allow 0

(0) Share

Report

Posted on by devgirlX

114

Hello,

I have a real field that is mandatory. How can I allow it to insert 0 as a value and not look into that 0 as empty? When I put "show zero" property to No, whenever I enter 0 in the field it resets to empty.

So the requirement is to be mandatory but being able to enter 0, so to distinguish between empty (null) value and 0 as value.

Is this possible in X++?

Thanks in advance

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

In x++ real number 0.0 is treated as null (in other words there is no Null) You can read it here: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-variables-data-types#null-values-for-data-types

If you can describe your business problem(without talking about code), someone may suggest a solution.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,660 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

It's impossible. You're wrong in thinking that a real field can contain null. A real field is considered empty if its value is zero; whether you see the number or an empty field is just the matter of visualization.

If you make it mandatory, you're saying that it mustn't be zero. If you want to accept zero, it can't be mandatory. You can't allow and disallow zero at the same time.

You can implement such behavior, but you'll need an extra piece of information saying whether the field is considered empty or zero. Such as an additional boolean field (and you'll allow edition of the real field only when the boolean field is true).

Was this reply helpful? Yes No