NAV 4.0 SP1 Rounding Problem

Sorcerer
Sorcerer Member Posts: 107
edited 2006-05-05 in NAV/Navision Classic Client
Hello,

could it be that 4.00 sp1 has a little rounding problem?

if you program a message with following code:

MESSAGE('%1',ROUND(21.888));

you will receive a 22 as result.
in navi 4.00 sp 2 you will receive a 21.89

seems the standard rounding precision is not set correctly....
(tested on sql clients)

Comments

  • kine
    kine Member Posts: 12,562
    It is not joke, you just need to read the on-line help:

    Part from the help for ROUND function:
    Precision

    Data type: decimal

    This optional parameter determines the precision used when rounding. The default value is 0.01 for the US version. In other countries, other default values may be used. Note that the default value is only used when you have not specified the rounding precision in the Amount Rounding Precision field in the General Ledger Setup table.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • jm
    jm Member Posts: 156
    Hi Sorcerer,

    i have tested with Version 4.0 SP1 (Build No 21666)

    My result is 21.89.

    br
    Josef Metz
    br
    Josef Metz
  • Sorcerer
    Sorcerer Member Posts: 107
    OK.

    You can NOT replicate it with standard database.

    I have tested it with our productive database (object version 2.60).

    It could NOT be the rounding precision in table 98. As i wrote the problem occurs with the SAME database when opend with sp1. When the SAME database is opened with sp2 the rounding function is working correct.

    So it seems something has changed between the rounding functionality in 3.70 (current client) and 4.0 sp1 and sp2...

    @BlackTiger: it was no joke. as i can only speak for me, i read the documentation.
  • themave
    themave Member Posts: 1,058
    BlackTiger wrote:
    kine wrote:
    It is not joke, you just need to read the on-line help:

    Part from the help for ROUND function:

    Beleive me, unfortunately, people usualy NEVER reading documentation. :D

    That's why it is a joke. :)
    Read the documentation, now that is a good joke, as an end user, we have to beg to get documention. All we ever get for progam updates is an ftp download of a few files.

    if we do track down a pdf file somewhere it is for a different version or it is the worldwide file, not the us file. ect ect ect.

    yeah documentation of navision, now that is a good joke.

Categories