Decimal Places

fazlehasan

I don't know the reason why?...

I was trying to input data from C/SIDE (backend) in a decimal field of a table,
the decimal value had more then 2 decimal places, but it restricted me -
saying that I cannot input decimal places more then 2.
The DecimalPlace property of the table has default value "Undefined".
We use NAV 5.0 SP1

I could not debug the error where it is been triggered from.
Is it Code Unit 1 doing this?

Can someone tell me the reason, please.

Luc_VanDyck

Quoting the on-line help for the Decimalplaces-property:

DecimalPlaces
Use this attribute to tell the system how to display decimal numbers if you want a format other than the default, which is two decimal places (for amounts).

As the default values for the properties AutoFormatType and AutoFormatExpr are resp. <0> and <>, I quote the on-line help for the AutoFormatExpr-property:

Other Types of Data
AutoFormatType must be 0 and AutoFormatExpr must be blank for the system to format data using the default C/SIDE settings (Standard Format 0).

And finally, quoting the on-line help for Standard Format 0:

Decimal [nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp]Format [nbsp][/nbsp][nbsp][/nbsp]Example
<Sign><Integer Thousand><Decimals> [nbsp][/nbsp][nbsp][/nbsp]0 [nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp][nbsp][/nbsp]-76,543.21

Now I hope all this quoting leads to somewhere ;-)

fazlehasan

yes I got your point...thanks