Amount rounding precision

aliennav

Hi
I am using NAV 2009 SP1.
what should be the amount rounding precision in case of Amount decimal places 2:5, considering i am using 5 decimal places.

or in other words

---

r these 2 related??

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Sog

The amount rounding precision should be related to the local currency.
So in dollar it would be 0.01, in belgian franks (depreciated)(the only currency I know of that didn't have cents) it would be 1.

crisnicolas

Sog wrote:

In belgian franks (depreciated)(the only currency I know of that didn't have cents) it would be 1.

Peseta (spain) did not use cents either. But of course this is over as Euros are used now...

aliennav

Sog wrote:

The amount rounding precision should be related to the local currency.
So in dollar it would be 0.01, in belgian franks (depreciated)(the only currency I know of that didn't have cents) it would be 1.

And what about the Amount Decimal places.
In case Rounding Precision is 0.01, then what should be the Amount decimal places??

bestianhow

Hi aliennav,
I think Amount decimal places use to control display purposes.
For example, 2:5.
minimum => 2 decimal places
maximum => 5 decimal places

While Amount Rounding Precision use in calculation part.
Example:
ROUND(Amount * CurrRate , GLSetup."Amount Rounding Precision");

aliennav

bestianhow wrote:

Hi aliennav,
I think Amount decimal places use to control display purposes.
For example, 2:5.
minimum => 2 decimal places
maximum => 5 decimal places

While Amount Rounding Precision use in calculation part.
Example:
ROUND(Amount * CurrRate , GLSetup."Amount Rounding Precision");

If I am entering 5 decimal places in transfer order and i have specified 2:5 in decimal places (Amount), and amount rounding precision is 0.01

---

The system gives me ERROR.
can u please explain this??

bestianhow

Hi aliennav,
Amount Decimal Places is depend on Amount Rounding Precision.
I guess Amount Rounding Precision is control in input & calculation, while Amount Decimal Places is for display only.

If you want the able enter 5 precisions e.g. 123.00456, then your Amount Rounding Precision should define in 0.00001.

Amount Rounding Precision as default is 0.01 & Amount Decimal Places is 2:2.

aliennav

bestianhow wrote:

Hi aliennav,
Amount Decimal Places is depend on Amount Rounding Precision.
I guess Amount Rounding Precision is control in input & calculation, while Amount Decimal Places is for display only.

If you want the able enter 5 precisions e.g. 123.00456, then your Amount Rounding Precision should define in 0.00001.

Amount Rounding Precision as default is 0.01 & Amount Decimal Places is 2:2.

Thanks Buddy....

Hanen

How can I do to get that :


17.8899 --> 18
and
49.007 --> 49

Mehdi

You can check the ROUND Function :
NewNumber := ROUND(Number [, Precision] [, Direction])

Direction :
'=' rounds up or down to the nearest value (default). Values of 5 or greater are rounded up. Values less than 5 are rounded down.

'>' rounds up

'<' rounds down

Hanen

Thanks but I used ROUND(Amount,0); and it didn't work that's why I posted that prob

crisnicolas

Precision should be 1, not 0.
Take a look at the examples provided on the C/SIDE Reference Guide