Exchange Variance Error (Page 1 of 2)

You will need to provide more information. What is your home currency? What exchange currency is involved and what rate have you set?

My default Currency is USD, but the transaction with curency IDR.
The Exchange Rates is generate automatically is no problem.

Exchange Variance.png

The Exchange Rates is generate automatically.

Exchange Rates.png

Rupiah exchanges rates is generated automatically from
/*
    Choose Exchange Rate Provider
    Default is ECB for backwards compatibility
*/
$xr_providers = array("ECB", "YAHOO", "GOOGLE", "BLOOMBERG");
$dflt_xr_provider = 2;

the problem that may need to elaborate, in the different vendor and value, the exchange rates seems doubled from the last transaction, we check in the table currency, values in the some dates is wrong get from google shown 0.0001, but we have correctly this to 0.000074954090619496, even in the pages https://domain/fa/gl/manage/exchange_rates.php? this always shown 0.0001.

other trans is seems correct to automatically calc for exchange rate difference, but in this case, we still dont have any clue but some transaction will cause exchage rate difference double from the last value:
Journal Entry    360    30-Jun-2017             36,153,961,430,173.00        72,307,922,870,772.69    Exchange Variance
Journal Entry    361    30-Jun-2017             72,307,922,860,346.00        144,615,845,731,118.69    Exchange Variance
Journal Entry    362    30-Jun-2017             144,615,845,720,690.00        289,231,691,451,808.69    Exchange Variance
Journal Entry    365    30-Jun-2017             289,231,691,439,930.00        578,463,382,891,738.75    Exchange Variance

pls advice how we can solve this?

thanks

This is not happen on payment to supplier, but also other bank payments

Following example cash payment:

I enter internet bill payment of IDR 1,000,000. This equivalent to USD 74.95 (figure 1.png).
After that I check Journal Inquiry, there are new transactions that I input and also transactions that generate automatically by system with value of USD 3699,81 with description of Exchange Variance. (figure 2.png)
This is very impossible, because the transaction is only USD 74.95.

I have changed the exchange rate by 8 decimal
Exchange Rates.png)

base currency is USD, but we operate for costing is IDR

sorry for delay, seems punbb dont email for the updates.

thanks

The exchange rate calculations have been the same for over 10 years.

Fot huge currency rates, it is important to use adequate decimals. Otherwise the values will vary very much.

Joe

Here is a tedious way of troubleshooting it.
Turn on all debug including select in sql trail in the config file.
Insert the troubleshooting code at each place in the FA scripts sequentially to inspect where the error comes in.
Sample troubleshooting code:

$log_output = "\n\n Start dump of all variables \n\n" . print_r(get_defined_vars(),true) . "\n\n";
file_put_contents('D:/XAMPP/htdocs/fa24/tmp/log_file.txt', $log_output, FILE_APPEND);

Try to change the exchange provider and check it. 

$xr_providers = array("ECB", "YAHOO", "GOOGLE", "BLOOMBERG");
$dflt_xr_provider = 2;

change it from your config.php  .
And also enable debugging mode to see whether it throws any error during conversions.

FrontAccounting Enabling Debugging Mode

I tried to enable debugging mode. After that, what I should look into it?

Journal entry

Exchange variance

It is difficult with these huge exchange rate differences. As @apmuthu mentions, maybe a set of decimals in amounts to 0 will solve it.

I will show the discussion to Janusz.

/Joe

Hi @joe and @apmuthu,

Is the error message below related to this case?

Error message

Kevin Lee