• From: Tanzania, Dar es Salam
  • Registered: 02/14/2013
  • Posts: 10

Topic: Issues with multiple currencies

Hi,
There is one account of "Gains/Loss in exchange rates" that involves only dollar transaction, its balance increases significantly once you post any transaction to any account with dollar value.
Te system doesn't record transactions using one currency given the exchange rate for the period. It sometimes treats USD transaction as if it was a TZshillings (my local currency) and sometimes treats TZShillings transaction as if it was USD. This bring much confusion in the report and also gives us a wrong and unrealistic exchange rates gain.

How do I solve this problem? Thank you

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Issues with multiple currencies

Please give a little more details on what you have been doing, so we can try to reproduce the error.

Joe

  • From: Tanzania, Dar es Salam
  • Registered: 02/14/2013
  • Posts: 10

Re: Issues with multiple currencies

Hi,
See, one of the account for "Gains in Exchange rates" automatically posts huge balances whenever there is a transaction of foreign currency( USD).

I have attached the current transactions within this account and the screen shot of ERP for further actions.
http://www.hisapepe.com/erp/shot1.jpg
http://www.hisapepe.com/erp/shot2.bmp (or http://www.hisapepe.com/erp/exported.xls )

4 Reply by apmuthu (edited by apmuthu 12/28/2014 07:46:40 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Issues with multiple currencies

You seem to have inverted your exchange rates by entering it manually!

Assuming
1 TZS = 0.00058 USD
means
1 USD = 1725 TZS

Instead of 1 : 1725 you may have made it 1725 : 1. This will result in 1725 * 1725 = 2975625 times the variance (nearly 3 million times)!

Remember your local currency is 1 and the exchange rate is the equivalent of 1 unit of your home currency in target currency.

apmuthu's Website