MSSQL numbers decimals are different from Navision decimals

mihai.valcea

Hi,

I have a nice problem with some new features developed in Navision because of the numbers decimals.

Even in Navison numbers are viewed with 2 decimals if I look on MSSQL 2000 tables on same records the numbers are stored with at least 15 decimals. It cause program to raise false errors.

What can be done on Navision devs. to avoid such cases.

Thanks
Mihai

kine

It is only visual rounding in Navision... Navision is still working with full precision decimals... there is only default 2:2 precision for output...

mihai.valcea

Is ok with output decimals but the problem of working with so many decimals still remain.
As I specified in last post the extended number of decimals appears only on new developments not on standard one.
Is needed to round manually the amounts when operating with them ?

thanks

kine

Yes... it is why there is for example field for setup Unit amount etc...