Amount rounding precision

aliennav
aliennav Member Posts: 449
edited 2010-11-15 in NAV/Navision Classic Client
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??

Comments

  • kriki
    kriki Member, Moderator Posts: 9,132
    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Sog
    Sog Member Posts: 1,023
    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.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • crisnicolas
    crisnicolas Member Posts: 177
    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
    aliennav Member Posts: 449
    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
    bestianhow Member Posts: 120
    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
    aliennav Member Posts: 449
    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
    bestianhow Member Posts: 120
    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
    aliennav Member Posts: 449
    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
    Hanen Member Posts: 281
    How can I do to get that :


    17.8899 --> 18
    and
    49.007 --> 49
    Regards

    Hanen TALBI
  • Mehdi
    Mehdi Member Posts: 16
    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
    Hanen Member Posts: 281
    Thanks but I used ROUND(Amount,0); and it didn't work that's why I posted that prob :cry:
    Regards

    Hanen TALBI
  • crisnicolas
    crisnicolas Member Posts: 177
    Precision should be 1, not 0.
    Take a look at the examples provided on the C/SIDE Reference Guide

Categories