Apply in different currencies

bogdandumbogdandum Member Posts: 26
edited 2005-03-29 in Navision Attain
I have the following situation:
exchange rates in currency table:
31.12.04 - 1EUR=39663LCY
1CHF=25513LCY
21.01.05 - 1EUR=37998LCY
1CHF=24636LCY
The following transactions were made from general journal:

1) 31.12.04
Account=customer X; balancing account=GL account Y
amount=2865 EUR - (exchange rate 1EUR=39663LCY)=113634495LCY

2) 21.01.05
Account=bank account in CHF currency; balancing account=customer X
amount=2865 CHF - (exchange rate 1CHF=24636LCY)=70582140LCY

The 2nd transaction is applied to the 1st
Navision posted a realized loss of 3092675,76LCY
From my calculation it should be 3092770,8
I calculated the amount like this:
(70582140/37998)*(39663-37998)

Did I calculated the right way or Navision works somehow different and how?

Thank you for your support

Comments

  • bogdandumbogdandum Member Posts: 26
    Navision uses a "currency factor" to store information about tranzaction exchange rate. This factor is calculated as 1/exchange rate, so rounding differences occurs further in application.
Sign In or Register to comment.