Editable grid - currency fields - funny error message - You must enter a number between...

(3) Share

Report

Posted on by Miha Mocnik

290

Hi Guys,

users got error message saying "you must enter a number between -922... and 922..." for currency fields on editable grids. It is not possible to change anything. If user opens the record, the value can be easily changed on the form.

Do you know what could be the case? We don't have any javascripts on these fields etc.

BR,

Miha

There-is-at-least-one-error-that-must-be-fixed-before-you-can-proceed.PNG

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Brackee 245 on at

Like (0)

Report

Hey,

I am experiencing the exact same thing. This have worked fine up until now.

I have tried forcing the message away through javascript, but with no luck.

We have Dynamics 365 v8.2 installed.

Anyone know why this are happening?

Was this reply helpful? Yes No
Brackee 245 on at

Like (0)

Report
I did some research.

I believe this error was introduced in the latest update: https://support.microsoft.com/en-us/help/4338685/service-update-14-for-microsoft-dynamics-365-8-2-2

The asterisk that marks whole-number fields as required in editable grids overlaps the number value

I do not know if this is actually the cause, but to me it looks like most possible reason.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Same error for me too.

As far as I can see, this is due to a javascript validation error for the currency fields: they're trying to compare a string representation of the value (eg. "€10.50") with the decimal range bounds.

As Bjørn said, the error was introduced in the last update: 8.2.2

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Am also experiencing the same exact thing with currency field in Editable Grid, and am with Dynamics 365 Version 1612 (8.2.2.1960).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

I am also receiving this error with currency field in Editable Grid, and am with Dynamics 365 Version 1612 (8.2.2.1960).

There is no JavaScript or business rules on the field too.

Was this reply helpful? Yes No
Suggested answer

Ben Thompson 6,350 on at

Like (0)

Report

Given that everyone is reporting the issue I would recommend that you all raise a support request at https://admin.dynamics.com . If enough people do that it should be identified and fixed rapidly...

Was this reply helpful? Yes No
Suggested answer

Drew Poggemann 4 on at

Like (0)

Report

Hi everyone,

I just tested this with 9.0 and it is working and not seeing the error but with a different side effect...

See the related post with my testing:

community.dynamics.com/.../286309

Thanks,

Was this reply helpful? Yes No
Ben Thompson 6,350 on at

Like (0)

Report

Drew, the bug seems to be recently introduced in the latest 8.2.2 service pack release...

Was this reply helpful? Yes No
Drew Poggemann 4 on at

Like (0)

Report

Hi Ben, understand. Just detailing behavior in 9, which works mostly with some issues as well though. Thanks much.

Was this reply helpful? Yes No
sclarebout 180 on at

Like (0)

Report

Exact same issue here. What did you do now? Did you start a service request with Microsoft? Or do we wait?

Was this reply helpful? Yes No