Rounding on Item Attribute of type Decimal

johnnyp

Hello.

I hope some can help me with this question about Item Attributes and the weird rounding of attribute type Decimal.

For starters, we are using Dynamics NAV 2017. I created an Item attribute of type Decimal. Then I added it to an Item and entered value 1000. I closed the Attributes window and reopened it, and the value was 1. I entered 1.000 with the same result, as 1.000,00 and 1000,00

I tried entering 10000, closed the window and reopened it, and the value was 10. Same hapened when I entered 100000, only the value was set to 100. It looked like it divided entries by 1000, however when I entered 1000000 it stored it as 1000000. Weird right? Some other numbers: 3400 rounded to 3,4. 250 not rounded. 34000 rouned to 34.

If anyone understands what the heck I'm talking about, I would greatly appreciate an explanation.

Best regards, John

Juhl

It does. But the user entry field is text, and then it is evaluated to decimal.
And its here it all goes wrong.
The client has a culturel setting, and when evaluated, its not evaluated to a culturel independed value.

Juhl

Hi John
I modified the solution, as it is error prone to culture. As I remember it’s due to not all functions in the solution being culture independent in handling decimal.
I modified it a few places to always evaluate to XML.
It’s because the value field in attribute is text, to be generic.

johnnyp

Thank you Juhl, but I'm afraid I don't quite understand what you mean.

DenSter

Check the table object and see if there is any code in OnValidate. Just a plain decimal field should not behave like that

Juhl

Its not a decimal, but a text field.

johnnyp

Oh, It's a text field? I thought that table 7501 stores texts in field "Value" and numbers in field "Numeric value" ... maybe i'm getting this all wrong.

Juhl

It does. But the user entry field is text, and then it is evaluated to decimal.
And its here it all goes wrong.
The client has a culturel setting, and when evaluated, its not evaluated to a culturel independed value.

johnnyp

A, yes, now I understand. Thank you for the explanation.