Options

Currency Calculation Error

itspeteritspeter Member Posts: 105
Hi,

In one of the transaction, my local currency exchange rate for USD is USD1=RM3.80 (Exchange rate=3.8005).

Invoice Amount: USD20250.00
Non-Navision calculation: -
USD20250.00 * 3.8005 = RM76960.125 (RM76960.13)

Navision calculation: -
USD20250.00 / (1/3.8005) = RM76960.12499999999994 (RM76960.12)

There is 1 cent different. What will be the Navision way to solve this issue?
Regards,
Peter Ng

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    I need more info on what you are doing.
    gen. journal line?
    Under function button there is Insert Conv. LCY Rndg. Lines, which creates another journal line for the one cent difference hitting your foreign currency gain/loss account.
    Sales Invoice? Purchase Invoice?
    Add the foreign currency gain/loss gl account and one cent.

    I might totaly not understand your question.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.