MSSQL numbers decimals are different from Navision decimals

mihai.valcea
mihai.valcea Member Posts: 95
edited 2006-01-09 in Navision Attain
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

Comments

  • kine
    kine Member Posts: 12,562
    It is only visual rounding in Navision... Navision is still working with full precision decimals... there is only default 2:2 precision for output...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • mihai.valcea
    mihai.valcea Member Posts: 95
    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
    kine Member Posts: 12,562
    Yes... it is why there is for example field for setup Unit amount etc...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories