NAV 4.0 SP1 Rounding Problem

Sorcerer

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)

kine

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.

jm

Hi Sorcerer,

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

My result is 21.89.

br
Josef Metz

Sorcerer

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

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.

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.