web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Rounding issue.
Microsoft Dynamics NAV (Archived)

Rounding issue.

(0) ShareShare
ReportReport
Posted on by magesen 200

NAV Rounding issue.

Base Currency: MYR

USD Exchange Rate: 3.0695

Create Sales Order:-

Sales Order Customer Currency: USD

Qty: 1

Unit Price: 227,650 USD

Line Amount:227,650 USD

Check Stastic (F9):-

Sales (LCY): MYR 698,157.77

NAV rounding 698,157.775 to  698,157.77 instead of  698,157.78

Pls advise how to resolve this. This is happening to all Dynamics NAV that i have tested from 4.0 until 2013.

*This post is locked for comments

I have the same question (0)
  • rajesh kumar mishra Profile Picture
    rajesh kumar mishra 290 on at

    Try this

    go to general ledger setup--->Invoice rounding type (Select Nearest)

  • Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    You have rounding option on General Ledger Setup /field: Inv. Rounding Type (LCY)/. You can choose one of the options:

    -Nearest (this option will be solve your problem)

    -Up

    -Down

  • magesen Profile Picture
    magesen 200 on at

    tried as per your suggestion. still the same result. pls advise.

  • magesen Profile Picture
    magesen 200 on at

    hi mr. Aleksander,

    thanks for your advise.

    tried as per your suggestion. still the same result.

    pls advise.

  • magesen Profile Picture
    magesen 200 on at

    hi mr. Rajesh,

    thanks for your advise.

    tried all the 3 options still the same result. issue not resolved yet.

    pls advise.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    Try to set field 'Invoice Rounding Type' on 'Currencies" table. You have to set 'Nearest' option. This is setup for currency invoice rounding.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Magesen,

    I just tested this out in a 2009R2 W1 database, new company, all setups to default values, no invoice rounding. I get a different amount (LCY), but the amount is rounded down in this case... whether it's customer or vendor doesn't matter.

    Digging deeper, I landed in the T330.ExchangeAmtFCYToLCY() function. Stepping through with the debugger shows that the amount without rounding (and according to the fp-precision used by the runtime) is 698771,674999999999. Using the "nearest" rule this rounds to 698771,67.

    When you try the same in Excel, the fp-precision isn't enough to cause this. Also the handy pocket calculator doesn't produce this result... 3 decimals less accuracy than shown in the debugger.

    So... the usual fpmath-inaccuracy by being more "accurate" than we usually verify... There is one (technical) catch in it, though: The currency factor is in this case 1 / 3.0695, stored in the fp-format. This will cause the first inaccuracy. Dividing the amount through the currency factor again adds the next one. And so the errors sometimes cancel each other out, sometimes not... leading to less and less usable decimals, the longer the non-rounded calculation gets.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans